Viewing 15 posts - 12,781 through 12,795 (of 22,224 total)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.
"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
April 13, 2011 at 5:00 am
I'M SPARTACUS!
Uh, I mean, I'm a Gila Monster too. Really.
"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
April 12, 2011 at 1:45 pm
One other note, you can't create a nonclustered materialized view. The very construct is always a cluster. No other way to do it.
"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
April 12, 2011 at 1:20 pm
Dale Cunningham (4/12/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
April 12, 2011 at 1:04 pm
The thing to do is restore to a moment in time before the event, but do the restore on a separate database. But then, you have to figure out how...
"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
April 12, 2011 at 12:45 pm
What event are you capturing in the trace? When I run a trace on a database with forced parameterization set, I still see values passed in. If you're seeing that,...
"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
April 12, 2011 at 12:36 pm
You're asking for more control than is possible through SQL Server. DBCC is how you determine where data other than tables are stored. Tables storage is defined when you create...
"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
April 12, 2011 at 12:24 pm
Craig Farrell (4/12/2011)
Grant Fritchey (4/12/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
April 12, 2011 at 11:12 am
You've got a couple of options. My favorite is to use Dynamic Management Objects such as sys.dm_exec_requests or sys.dm_exec_sessions to see what's happening on the server. You can combine these...
"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
April 12, 2011 at 6:46 am
A key lookup or a RID lookup, operation is caused when the nonclustered index that the optimizer uses doesn't have all the columns to satisify the query. The common method...
"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
April 12, 2011 at 6:38 am
It really sounds like you've got a non-standard design, so I doubt any standard set of checklists on performance tuning is going to help. All the stuff Wayne supplied 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
April 12, 2011 at 6:35 am
Piling on, Michele's scripts are excellent. I'd absolutely support putting those in place on any production system I supported.
"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
April 12, 2011 at 6:30 am
Craig Purnell (4/9/2011)
I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:
SQL Agent for the Beginner...
"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
April 11, 2011 at 4:20 pm
Scalability Doug (4/5/2011)
Ever wonder what's in your SQL Plan cache? Wonder...
"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
April 11, 2011 at 4:17 pm
Yep, absolutely, Itzik's books are the way to go.
"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
April 11, 2011 at 10:01 am
Viewing 15 posts - 12,781 through 12,795 (of 22,224 total)