Viewing 15 posts - 17,146 through 17,160 (of 22,219 total)
hi_abhay78 (6/18/2009)
SELECT MIN(TicketId) FROM TicketActivity
The above 2 queries are different.
But you can also run the min query as below :
select top 1 ticketid from TicketActivity order...
"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
June 19, 2009 at 7:52 am
What you've got are an ordering query, TOP, and an aggregate query, MIN. The ordering query must have an ORDER BY statement to work. You can't know what order things...
"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
June 19, 2009 at 7:49 am
GilaMonster (6/19/2009)
One I asked once (in an interview for senior position) was how to repair a torn page without losing any data. Anyone want to guess the answer I got?
I'm...
"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
June 19, 2009 at 7:29 am
Excellent article. Thanks for putting it up. I just wish you had posted it a few years ago. I'm going to print it out now & keep it handy as...
"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
June 19, 2009 at 6:10 am
jason brimhall (6/18/2009)
I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I...
"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
June 19, 2009 at 5:56 am
Matt Miller (6/18/2009)
"What is...
"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
June 19, 2009 at 5:51 am
Have you tried querying the dynamic management view sys.dm_exec_query_text yet? Any inline queries will be visible there, for the time that they're in cache.
"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
June 19, 2009 at 5:49 am
mazzz (6/19/2009)
Has SSC ever had a thread like this?
That is a weird one isn't it? It doesn't look like Phil helped matters much.
I have to say, some of our discussions...
"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
June 19, 2009 at 5:46 am
Sure, errors will cause gaps, deletions, anything that causes an incomplete transaction, implicit or explicit, can lead to gaps. If you need a perfectly flawless incrementally increasing number, with no...
"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
June 19, 2009 at 5:43 am
Nope. Never mind. I was wrong (again). Showplan XML Statistics Profile does include the actual execution plan. Whew. I feel a little better 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
June 18, 2009 at 1:12 pm
I have to get serious again for a moment and stop talking about beer...
I thought that Profiler in 2005/2008 Showplan XML would show the actual execution plans. It's not. 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
June 18, 2009 at 1:04 pm
It was an industry standard... about 15 years ago.
In addition to the problems outlined above, you may hit serious problems with rogue data. I had to deal with a system...
"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
June 18, 2009 at 11:41 am
It's difficult to get the right set of conditions to see filtered indexes get chosen by the optimizer. Hints frequently don't help. It's VERY difficult to get filtered statistics 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
June 18, 2009 at 9:12 am
Wayne West (6/18/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
June 18, 2009 at 8:30 am
A create table statement takes a day or more? No, that's pretty abnormal and not expected behavior in 2008 (or 2005 or 2000 or 7... maybe in 6.5).
Ummmm... Let's see....
"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
June 18, 2009 at 8:15 am
Viewing 15 posts - 17,146 through 17,160 (of 22,219 total)