Viewing 15 posts - 12,781 through 12,795 (of 22,227 total)
In addition to roles, also use schemas. That way you can grant execute permissions for a role to a schema. It makes things much easier to manage as Steve says.
"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:41 am
Excellent selection on the feedback, Brad. I also like your advice on filegroups and files. It's not something I had considered before, but certainly will going forward. I can't wait...
"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:37 am
There are a couple of ways you could try to fix this. Probably the easiest is to look at the column order on the primary key of the first...
"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:08 am
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
Viewing 15 posts - 12,781 through 12,795 (of 22,227 total)