Create a time dimension

Hi !
I have a question : my dataBase contains a table which have an attribute startTime.
The startTime give the day and the hour of an event.
I want to 'display' the event for a period time (one day or one week, or between to date...).
But I don't know how to do... Because if I add a dimension with this startTime, and in my report I put parameter with two date, I can only choose in the date exit in the attribut StartTime, but as I have a lot, an with a small range, I can't display all days...

I would like that the user choose a date as 27/03/07 and the report display all event in this day...
but I don't know what to do, because StartTime is as 27/03/07 10:50:42...

Can anybody help me ? Thank you !!!

In a named calculation(data source view in SSAS2005) or in a view/table(AS2000) you can try this: http://blog.mike-obrien.net/PermaLink,guid,f3363145-8753-4604-8314-855012a00400.aspx

This works with TSQL

HTH

Thomas Ivarsson

|||Hi Thomas,
Thank you for your answer...
But I have a problem not with named calculation but with the dimension, I didn't understand how to do !
As I explain last time, I have a table with a dateTime value, so I have a list of a lot of event with all this dateTime value, I want to organize them by day, So i want a time dimension that give just the day (as your answer) and which it is link with my dateTime, for example I have 5 event the 25/03/2007, 14 event the 26/03/2007...
so I don't what to do...
May I have to create a time dimension from server and my TimeDate are linked to this table ?

|||

Hello! Maybe I am wrong but I understand your problem as that you have time fragments on your date columns in the fact table and that you would like to change that?

The link I have sent you have examples that transform dates with 2007-03-29:13:30:06:01 to 2007-03-29:00:00:00 . If you build a time dimension with a datetime-column and you enter 2007-03-29 you will get 2007-03-29:00:00:00 in that column and a match between the time dimension and the fact table on dates.

Regards

Thomas Ivarsson

Crashing server (Event ID 333)

Hello,
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type:Error
Event Source:Application Popup
Event Category:None
Event ID:333
Date:07.04.2008
Time:09:01:57
User:N/A
Computer:CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..à
0010: 00 00 00 00 4d 01 00 c0 ...M..à
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!!
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..
> 0010: 00 00 00 00 4d 01 00 c0 ...M..
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>
|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:

> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Contro l\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Crashing server (Event ID 333)

Hello,
We experience problems with machines running SQL Servers 2005 in our
production environment. This problem is rather connected to OS or network
settings but hopefully someone here can help. The error below appears several
times in a minute and leads to crash of a machine.
We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server 2005
SP2. This problem started to occur after installation of automatic updates
(bunch of security updates).
Has anyone solved similar issue? Could someone help to track down the problem?
Many thanks
eXavier
Event Type: Error
Event Source: Application Popup
Event Category: None
Event ID: 333
Date: 07.04.2008
Time: 09:01:57
User: N/A
Computer: CMPNT45
Description:
An I/O operation initiated by the Registry failed unrecoverably. The
Registry could not read in, or write out, or flush, one of the files that
contain the system's image of the Registry.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 00 00 01 00 6c 00 .....l.
0008: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0010: 00 00 00 00 4d 01 00 c0 ...M..Ã?
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......I am a consultant by trade and help people with SQL Server problems for a
living. But I gotta say when something like this occurs MY first action
would be (and my advice to my clients would be) call Microsoft PSS!! :)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:70DC487A-4928-40E1-9DC0-59FB0AB1B5AB@.microsoft.com...
> Hello,
> We experience problems with machines running SQL Servers 2005 in our
> production environment. This problem is rather connected to OS or network
> settings but hopefully someone here can help. The error below appears
> several
> times in a minute and leads to crash of a machine.
> We have clustered environment Windows Servers 2003 SP2 x64 + SQL Server
> 2005
> SP2. This problem started to occur after installation of automatic updates
> (bunch of security updates).
> Has anyone solved similar issue? Could someone help to track down the
> problem?
> Many thanks
> eXavier
>
> Event Type: Error
> Event Source: Application Popup
> Event Category: None
> Event ID: 333
> Date: 07.04.2008
> Time: 09:01:57
> User: N/A
> Computer: CMPNT45
> Description:
> An I/O operation initiated by the Registry failed unrecoverably. The
> Registry could not read in, or write out, or flush, one of the files that
> contain the system's image of the Registry.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 00 00 01 00 6c 00 .....l.
> 0008: 00 00 00 00 4d 01 00 c0 ...M..À
> 0010: 00 00 00 00 4d 01 00 c0 ...M..À
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
>|||Hello,
I agree with Kevin it's best taht you call MS PSS for memory dump analysis
on this server crash issue. For a complete list of Microsoft Product
Support Services phone numbers, please go to the following address on the
World Wide Web:
http://support.microsoft.com/directory/overview.asp
Also, you may want to use add/edit the following registry key to see if it
helps
In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
Manager\Configuration Manager subkey, configure the following entry:
Name: RegistryLazyFlushInterval
Data Type: REG_DWORD
Value data: 60 (decimal)
You may try to increase Windows paging file size to see if it's helpful.
It's possible that this kind of issue occurs when there are some issues
related to server hardware driver. For example, if the operating system
cannot satisfy the contiguous memory blocks under the 4 GB space, the
server may become unresponsive.
Reference the following HP site details:
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
objectID
=c00688313&jumpid=reg_R1002_USEN
Please let's know if you have any further questions or comments. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up responske may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
It seems the problem was really caused by drivers for extra sotrage added
during maintenace period.
Thanks for all responses!
Best Regards
eXavier
""Peter Yang[MSFT]"" wrote:
> Hello,
> I agree with Kevin it's best taht you call MS PSS for memory dump analysis
> on this server crash issue. For a complete list of Microsoft Product
> Support Services phone numbers, please go to the following address on the
> World Wide Web:
> http://support.microsoft.com/directory/overview.asp
>
> Also, you may want to use add/edit the following registry key to see if it
> helps
> In the new HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session
> Manager\Configuration Manager subkey, configure the following entry:
> Name: RegistryLazyFlushInterval
> Data Type: REG_DWORD
> Value data: 60 (decimal)
> You may try to increase Windows paging file size to see if it's helpful.
> It's possible that this kind of issue occurs when there are some issues
> related to server hardware driver. For example, if the operating system
> cannot satisfy the contiguous memory blocks under the 4 GB space, the
> server may become unresponsive.
> Reference the following HP site details:
> http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&
> objectID
> =c00688313&jumpid=reg_R1002_USEN
> Please let's know if you have any further questions or comments. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up responske may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
Nice to hear you solved the problem!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.

CPU Using - Audit Logout

I have a VP app. that uses some queries from SQL Server 2000.
I'm noticing in SQL Profiler that the event "Audit Logout" is using alot of
cpu at times.
How can I decrease these CPU times ?Keep the connection open.
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||> Keep the connection open.
i cant keep the connection open.
Is there any other solution for this problem.
> "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > I have a VP app. that uses some queries from SQL Server 2000.
> >
> > I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
> of
> > cpu at times.
> > How can I decrease these CPU times ?
> >
> >
>|||My guess is that it is cleaning up a lot of server side cursors when it
spikes the cpu. Can you tell if the times when it happens if any of the
queries used server side over client side?
--
Andrew J. Kelly SQL MVP
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||We have a VB application. Over Timer control, we have run SQL queries. These
query types are, sometimes SELECT sometimes UPDATE. Everty time that app.
run, these queries executed. Every Connecion's Cursor Location is Client
Side. When we check SQL Profiler, Audit Logout events's CPU has been
increased. I think this is caused for operating systems CPU usage. How can
we decrease that high CPU usage or How can we decrease Audit Logout usage ?
Thanks a lot.
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:OFpNTl%23wDHA.1908@.TK2MSFTNGP10.phx.gbl...
> My guess is that it is cleaning up a lot of server side cursors when it
> spikes the cpu. Can you tell if the times when it happens if any of the
> queries used server side over client side?
> --
> Andrew J. Kelly SQL MVP
>
> "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > I have a VP app. that uses some queries from SQL Server 2000.
> >
> > I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
> of
> > cpu at times.
> > How can I decrease these CPU times ?
> >
> >
>|||The logout is probably not using much time at all. More of a total. I know
this is true of duration, and I am pretty sure it is true of CPU. It is not
a perfect addition of all of the other rows, so I might be wrong, but I am
sure that the logout operation is not one of the more costly operations.
However, if applications are making and breaking too many connections, it
can become an issue.
--
----
--
Louis Davidson (drsql@.hotmail.com)
Compass Technology Management
Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are
interested in consulting services. All other replies will be ignored :)
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||But it's a cumulative count of the resources used for the lifetime of the
connection so whilst it may appear high it should be roughly the sum of the
CPU the connection used executing queries etc. Thus it being high or low
does not mean much, it's generally more interesting to look at those
statements that consumed most of the resources during the lifetime of the
connection if you see what I mean
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> I have a VP app. that uses some queries from SQL Server 2000.
> I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
of
> cpu at times.
> How can I decrease these CPU times ?
>|||Yes as Jasper points out this is a cumlative counter and will increase over
time as expected.
--
Andrew J. Kelly SQL MVP
"Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
news:%23L1$80%23wDHA.2316@.TK2MSFTNGP10.phx.gbl...
> We have a VB application. Over Timer control, we have run SQL queries.
These
> query types are, sometimes SELECT sometimes UPDATE. Everty time that app.
> run, these queries executed. Every Connecion's Cursor Location is Client
> Side. When we check SQL Profiler, Audit Logout events's CPU has been
> increased. I think this is caused for operating systems CPU usage. How can
> we decrease that high CPU usage or How can we decrease Audit Logout usage
?
>
> Thanks a lot.
>
>
> "Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
> news:OFpNTl%23wDHA.1908@.TK2MSFTNGP10.phx.gbl...
> > My guess is that it is cleaning up a lot of server side cursors when it
> > spikes the cpu. Can you tell if the times when it happens if any of the
> > queries used server side over client side?
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> > news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > > I have a VP app. that uses some queries from SQL Server 2000.
> > >
> > > I'm noticing in SQL Profiler that the event "Audit Logout" is using
alot
> > of
> > > cpu at times.
> > > How can I decrease these CPU times ?
> > >
> > >
> >
> >
>|||Ok. Firstly, Thank you very much. From Now on, what sholud we do ? Have you
any idea ?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O8v2zj$wDHA.1500@.TK2MSFTNGP12.phx.gbl...
> But it's a cumulative count of the resources used for the lifetime of the
> connection so whilst it may appear high it should be roughly the sum of
the
> CPU the connection used executing queries etc. Thus it being high or low
> does not mean much, it's generally more interesting to look at those
> statements that consumed most of the resources during the lifetime of the
> connection if you see what I mean
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Tahir Ozmen" <tahirozmen(at)hotmail.com> wrote in message
> news:O9QSMS9wDHA.1996@.TK2MSFTNGP12.phx.gbl...
> > I have a VP app. that uses some queries from SQL Server 2000.
> >
> > I'm noticing in SQL Profiler that the event "Audit Logout" is using alot
> of
> > cpu at times.
> > How can I decrease these CPU times ?
> >
> >
>