Viewing 15 posts - 11,656 through 11,670 (of 22,224 total)
Daryl AZ (11/18/2011)
I was questioning whether switching from a clustered index on an Identity to a clustered index on non-sequential keys would affect...
"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 18, 2011 at 8:53 am
I would strongly recommend having a clustered index on the table. It doesn't have to be the primary key, but by and large, in most circumstances, a table with 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
November 18, 2011 at 8:40 am
Gianluca Sartori (11/18/2011)
Grant Fritchey (11/18/2011)
Gianluca Sartori (11/18/2011)
The technique described there uses DBCC commands,...
"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 18, 2011 at 7:19 am
Gianluca Sartori (11/18/2011)
The technique described there uses DBCC commands, but it works 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
November 18, 2011 at 6:27 am
That's just so open-ended... How are you at query tuning? Are you an SSIS expert? What about hardware, do much with hardware? Networking? Virtuals? SANs? Performance Monitoring? Operating Systems? 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
November 18, 2011 at 6:24 am
You can't alter that out of a table. So, you have to create a second table with the structure you want, copy the data across, drop the original table, rename...
"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 18, 2011 at 6:16 am
I'm not even going to try to wade through all that.
Here's a question. How many rows are returned by that multi-statement table valued user defined function? I ask because, if...
"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 18, 2011 at 6:14 am
You can also enable traceflag 1222 which will output deadlock info to the error log in SQL Server whenever a deadlock occurs. This is frequently easier than trying to capture...
"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 18, 2011 at 6:09 am
You can do network backups. As long as the the SQL Server service account can see the location that you are backing up to, you're golden.
However, be sure of 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
November 18, 2011 at 6:07 am
If the internal proc returns a data set... there's not much you can do. What is it that you're trying to do with the procs?
"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 18, 2011 at 6:05 am
My title is Product Evangelist, but my job is Booth Babe.
"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 18, 2011 at 5:56 am
Chad Crawford (11/17/2011)
Very happy - Passing...
"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 17, 2011 at 2:49 pm
Disk queue length is a completely meaningless measure on a SAN system. Some of the other measures are ok, but for details you're going to have to work with your...
"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 17, 2011 at 7:04 am
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...Same here.
No offense if I forgot anything else. I didn't reread the whole 2 weeks either :hehe:.
Excellent wrap-up. Thanks.
"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 15, 2011 at 7:00 am
Ninja's_RGR'us (11/15/2011)
Grant Fritchey (11/15/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
November 15, 2011 at 6:30 am
Viewing 15 posts - 11,656 through 11,670 (of 22,224 total)