Viewing 15 posts - 13,891 through 13,905 (of 22,219 total)
I'm a little surprised by the approach too. Was it SQL Saturday in NYC? Which presenter was it? I'm curious to see the presentation now.
"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
November 23, 2010 at 3:41 pm
You must test indexes suggested by the missing index process. It is absolutely not to be blindly trusted. I've seen it recommend an index on Column A and an Index...
"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
November 23, 2010 at 3:35 pm
Use sys.dm_exec_requests and see what is causing the procedure to wait. If it's blocked, trace the blocking chain, again, available from the same DMO.
"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
November 23, 2010 at 8:24 am
GilaMonster (11/23/2010)
Grant Fritchey (11/23/2010)
I see how you consultants keep making money though. Seems like these shops are mushrooms. They're springing up all over the place.
There are stories I could tell,...
"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
November 23, 2010 at 8:21 am
With only a single row to send, I'd suggest just creating a procedure or parameterized query that lists the columns and send that over. That really is the better approach....
"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
November 23, 2010 at 6:24 am
First question I'd ask is, what are those procedures doing. If it just runs and runs, something is up in that code. Rather than try to determine what's happening at...
"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
November 23, 2010 at 6:21 am
Just add an alias:
SELECT MAX( RowNumber ) FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY MSG_DTM_LASTSTATUSTIME DESC) as RowNumber
FROM
Message_MSG msg with(nolock)
) AS x
"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
November 23, 2010 at 5:13 am
Can you use PowerShell instead? If so, I've got a good script I can point you to.
"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
November 23, 2010 at 5:06 am
First thing I'd do is get the data model. Do you have a data modelling tool like ERStudio or ER/Win? If not, you'll have to use the built in model...
"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
November 23, 2010 at 5:04 am
Thanks for the article Sarvesh. You may want to spend a little more time on the next one, just nail down why these things occur. As you showed, it's not...
"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
November 23, 2010 at 4:23 am
DavidL (11/22/2010)
"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
November 23, 2010 at 4:17 am
Paul White NZ (11/23/2010)
GilaMonster (11/23/2010)
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of...
"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
November 23, 2010 at 4:15 am
Some other potential optimizations. You have a whole bunch of DISTINCT operations. These are aggregates and when you see them everywhere in a query it's usually indicative of poor programming...
"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
November 23, 2010 at 4:13 am
pavan_srirangam (11/22/2010)
"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
November 22, 2010 at 6:53 pm
Jeff Moden (11/22/2010)
I just don't ever want to be that "productive". Down-time is very important to me.
What is this "down-time" of which you speak?
"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
November 22, 2010 at 6:51 pm
Viewing 15 posts - 13,891 through 13,905 (of 22,219 total)