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...
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.
December 23, 2009 at 10:54 am
Look on Paul's blog (link in his sig above). There's some stuff there on shrinkdatabase.
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?
December 23, 2009 at 8:52 am
Have you tried Google?
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...
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...
December 22, 2009 at 2:20 pm
PeterG-377490 (12/22/2009)
December 22, 2009 at 2:11 pm
Bru Medishetty (12/22/2009)
GilaMonster (12/22/2009)
Bru Medishetty (12/22/2009)
December 22, 2009 at 2:05 pm
Lynn Pettis (12/22/2009)
GilaMonster (12/22/2009)
Bru Medishetty (12/22/2009)
December 22, 2009 at 2:04 pm
Bru Medishetty (12/22/2009)
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...
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...
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...
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...
December 22, 2009 at 10:53 am
Viewing 15 posts - 35,116 through 35,130 (of 49,552 total)