Viewing 15 posts - 13,201 through 13,215 (of 22,224 total)
I've found through a lot of testing that the use of ROW_NUMBER when returning more than a few rows has a tendency to degrade faster than using a TOP with...
"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
February 18, 2011 at 6:55 am
mstjean (2/17/2011)
Point taken regarding indexing. Let me ask a smaller question: The query...
"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
February 18, 2011 at 6:29 am
Brandie Tarvin (2/17/2011)
You people are strange.@=)
You're just noticing?
"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
February 17, 2011 at 12:48 pm
Unfortunately your tests are quite fair. You need to have an index on a column so that you see if the implicit conversion causes a problem or not. You had...
"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
February 17, 2011 at 12:40 pm
There must be duplicate data in Table1 or rows already exist in Table2.
"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
February 17, 2011 at 10:46 am
I've put just about everything except the server configuration itself into source control. Yes, you can do this will all projecs and objects. Visual Studio works really well with Team...
"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
February 17, 2011 at 10:44 am
jcrawf02 (2/17/2011)
and along those lines, am I the only one who can't read anything about HADRON without blinking and re-reading, then chuckling to myself?
Yep. It's just you.
"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
February 17, 2011 at 10:16 am
jcrawf02 (2/17/2011)
Brandie Tarvin (2/17/2011)
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
I'll supply 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
February 17, 2011 at 7:07 am
Could you explain what that means please? I don't understand what you posted.
"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
February 17, 2011 at 4:58 am
I'd go to the Quest web site and take a look at the SQL Litespeed documentation. Depending on how you installed Litespeed, it can use standard restore syntax.
"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
February 17, 2011 at 4:56 am
There is no way to tell where the trace was initiated from. You can just get the info you see there and the event and column info from fn_geteventinfo
"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
February 17, 2011 at 4:53 am
Whether or not data stays in memory is largely a function of the size of your memory and how volatile your cache is. Tables won't stay in memory unless they're...
"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
February 17, 2011 at 4:50 am
Brandie Tarvin (2/16/2011)
"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
February 16, 2011 at 12:23 pm
Brandie Tarvin (2/16/2011)
exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace_1', @maxfilesize, NULL, @filecount
Should be
exec @rc = sp_trace_create @TraceID output,...
"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
February 16, 2011 at 12:21 pm
Anna_SQL (2/16/2011)
One time when one of our servers got a hang or ran very slow, I tried...
"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
February 16, 2011 at 12:12 pm
Viewing 15 posts - 13,201 through 13,215 (of 22,224 total)