Viewing 15 posts - 31 through 45 (of 192 total)
THe following gives a good guide to pulling the relevant info from the default trace
http://blogs.msdn.com/cindygross/archive/2009/12/16/sql-server-s-default-trace.aspx
March 30, 2010 at 4:53 am
repent_kog_is_near (3/25/2010)
March 25, 2010 at 9:34 am
repent_kog_is_near (3/24/2010)
Paul,Do you have a link for Kimball's star-schema that you refer to, for OLAPs?
For a good starter, Google "A Dimensional modelling manifesto"
March 25, 2010 at 9:04 am
Legato won't 'have' it - it'll just be wherever you backed it up to, not in Legato's store. So yes, the sequence will be broken as far as your...
March 25, 2010 at 6:50 am
March 19, 2010 at 5:45 am
How about using something like the following to allow a number of retries before timing out of the query the user is running encounters a lock (adjust timing and reries...
March 16, 2010 at 9:39 am
ESAT ERKEC (3/16/2010)
I think you can use READPAST or WITHNOLOCK hint in the query.
Well, you can ...
On rare occasions it may even be a good idea. However, there are...
March 16, 2010 at 9:25 am
Ah well - so much for that stab in the dark
March 16, 2010 at 8:17 am
Do you run a reindexing job overnight, if so are the queries which are affected those which are pulling data for the current day rather than historical data?
March 16, 2010 at 8:11 am
Check the default trace
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
March 16, 2010 at 7:54 am
Well - it depends. If you use the diagramming tool to set up your FKs it will automatically generate indexes.
Except when it breaks when you're saving. Then you...
March 16, 2010 at 4:51 am
For a highly flexible, configurable and well regarded index maintenance script which does what you appear to be looking for try http://sqlfool.com/2009/06/index-defrag-script-v30/
March 16, 2010 at 3:07 am
With that level of growth I was tempted to suggest looking for the sp where someone loads the 5 largest tables into temp tables and then joins them using cursors
March 15, 2010 at 11:05 am
Molly Cary (3/15/2010)
Date3/15/2010 12:00:21 AM
LogSQL Server (Archive #1 - 3/15/2010 6:32:00 AM)
Sourcespid18s
Message
This instance of SQL Server has been using a process ID of 5964 since...
March 15, 2010 at 9:55 am
Molly Cary (3/15/2010)
March 15, 2010 at 9:21 am
Viewing 15 posts - 31 through 45 (of 192 total)