Viewing 15 posts - 15,961 through 15,975 (of 22,219 total)
There is a mechanism, and after you look it up as Jeff is prompting, you need to know that it's not 100% accurate all the time.
"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 28, 2009 at 8:44 am
Not enough information to help you unfortunately.
To get a complete answer, please post the execution plan, some sample data and the structures involved. To get a partial answer, at least...
"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 28, 2009 at 8:39 am
GilaMonster (12/28/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 28, 2009 at 8:36 am
Matt Miller (#4) (12/28/2009)
Grant Fritchey (12/28/2009)
Busy yesterday. Splitting wood and working on a chapter for a book... oh, and playing Halo ODST.
Dragon Age: Origins for me, and putting together my...
"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 28, 2009 at 8:34 am
I'm not sure why you'd need to have the Internet Information Server. I don't use it day to day. It can be used by Reporting Services, so that might be...
"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 28, 2009 at 8:30 am
It's not free but I love Idera's Diagnostic Manager. It'll do what you want and more. You also might want to take a look at Red Gate's SQL Alert. It's...
"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 28, 2009 at 8:28 am
Busy yesterday. Splitting wood and working on a chapter for a book... oh, and playing Halo ODST.
"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 28, 2009 at 8:13 am
Luke L (12/23/2009)
Grant Fritchey (12/23/2009)
Luke L (12/23/2009)
Grant Fritchey (12/23/2009)
GilaMonster (12/23/2009)
Grant Fritchey (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 12:11 pm
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
Viewing 15 posts - 15,961 through 15,975 (of 22,219 total)