Viewing 15 posts - 35,116 through 35,130 (of 49,552 total)
Grant Fritchey (12/23/2009)
Jack Corbett (12/23/2009)
Start by looking at sys.dm_exec_query_stats. You'll need to use sys.dm_exec_sql_text to see the query being executed. This information is since last server restart.
Sorry to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2009 at 11:02 am
*raises hand* and it's 8pm here.
I'm days behind where I should be on the current project, partially because of lots of VM problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2009 at 10:54 am
Look on Paul's blog (link in his sig above). There's some stuff there on shrinkdatabase.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2009 at 10:54 am
leroy-1092048 (12/23/2009)
There are no foreign keys to other tables from this identity column.
So what's the column used for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2009 at 8:52 am
Have you tried Google?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2009 at 3:59 am
Sorry, I misread a table name.
Seeing as some of the tables in the exists don't join together, I'd prefer to split it apart.
Which table are those datetime columns in? There's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 23, 2009 at 2:48 am
If I were you, I'd write a nice, formal email detailing the risks of continuing as-is. Send it to the director, cc your immediate manager (and maybe his manager depending...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 2:20 pm
PeterG-377490 (12/22/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 2:11 pm
Bru Medishetty (12/22/2009)
GilaMonster (12/22/2009)
Bru Medishetty (12/22/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 2:05 pm
Lynn Pettis (12/22/2009)
GilaMonster (12/22/2009)
Bru Medishetty (12/22/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 2:04 pm
Bru Medishetty (12/22/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 1:52 pm
Then tell your sysadmin to get off his bu^H^H chair and do his job. If there are disk problems (of any form) that's the sysadmin's responsibility. Running repeated checkDBs to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 1:50 pm
You don't need the additional reference to Trn_Participants within the Exists. Also, exists just checks row's existence. It doesn't actually return any columns, hence no need for the long select...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 1:44 pm
The Dixie Flatline (12/22/2009)
You see a lot of those types of scenes in S.A. this time of year? 😀
Um, let me think. No.
We don't ever get that kind of scene...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 11:09 am
Is Windows freezing up on restart or is SQL freezing up on restart?
If windows, leave the DB alone and look in the Windows event logs.
If SQL, look in the SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 10:53 am
Viewing 15 posts - 35,116 through 35,130 (of 49,552 total)