Viewing 15 posts - 15,976 through 15,990 (of 22,226 total)
CirquedeSQLeil (12/23/2009)
Better yet, lock them down so they can't do anything in the systems :Whistling:
But, it's Dev. I have to let them work somewhere. At least that's what the boss...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:51 am
Luke L (12/23/2009)
Grant Fritchey (12/23/2009)
GilaMonster (12/23/2009)
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.
Time to fetch...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:51 am
GilaMonster (12/23/2009)
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.Time to fetch the chain-saw?
Too messy and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:39 am
GilaMonster (12/23/2009)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:36 am
Jack Corbett (12/23/2009)
Grant Fritchey (12/23/2009)
Jack Corbett (12/23/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:30 am
CirquedeSQLeil (12/23/2009)
10 am here - and not seeing a rousing response about work.Next question is: Who has mentally checked out for the holidays?
Oooh! Guilty!
And I need to work on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:25 am
Jeff Moden (12/22/2009)
The Dixie Flatline (12/22/2009)
Bring forth the Holy Pork Chop of Antioch! 😛
Heh... paraphrased from one of my favorite "B" movies...
"Glory be to the [Code], and to the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:22 am
CirquedeSQLeil (12/23/2009)
Today is the 23rd, and several we know are on vacation.So, who is really working??
<Hand Up>
Fighting with a messed up development deployment. I love when developers mix up scripts...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 11:21 am
If there are only a few thousand rows in the table what the heck is causing it to dump millions of ID values? That's fairly odd behavior.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 9:08 am
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 jump on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 9:05 am
How about DBCC SHOW_STATISTICS?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 23, 2009 at 8:59 am
Bru Medishetty (12/22/2009)
CirquedeSQLeil (12/22/2009)
Bru Medishetty (12/22/2009)
http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx
Recollect some of his / her famous threads.
Lock Pages in Memory
How to see password
How...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 22, 2009 at 1:23 pm
Absolutely love it!
If you're going to use it though, I strongly recommend navigating over to CodePlex and getting the Enterprise Policy Management Framework. It allows you to run policies...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 22, 2009 at 9:22 am
I don't use Maintenance Plans because I don't feel they provide me with the granular level of control I need. However, I strongly recommend you update the statistics on a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 22, 2009 at 9:07 am
Alvin Ramard (12/22/2009)
I'm about to go offline for the next week or two, so it's time to wish y'all a very Merry Christmas and a Happy New Year.🙂
Right...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 22, 2009 at 6:11 am
Viewing 15 posts - 15,976 through 15,990 (of 22,226 total)