Viewing 15 posts - 16,456 through 16,470 (of 22,226 total)
espanolanthony (9/23/2009)
but Chim, i want to grant on all the stored procedures. and by that process i can grant only one by one stored procedures.
You can grant execute to 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
September 24, 2009 at 5:57 am
I don't think there's any tools out there that will do quite what you're looking for. You can get bits & pieces of it. For example, a good ER diagramming...
"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
September 24, 2009 at 5:53 am
Bob Hovious 24601 (9/23/2009)
AllRIGHT! Extra effort paid off. I just got approval to go to PASS. 😀 😀 😀
Excellent. See 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
September 24, 2009 at 5:34 am
You're stepping into a minefield of sorts here. This is the long-standing discussion between natural keys and artificial keys. I don't want to kick up too much mud, so I'll...
"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
September 23, 2009 at 1:10 pm
If you're planning on storing the entire file, I wouldn't recommend using SQL Server. Instead, I'd store it on the file system. If you're using 2008, you could use 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
September 23, 2009 at 1:06 pm
Without bringing in other langauges such as PowerShell or C#, you're probably doing the best you can, especially when you consider that gathering information on 2008 is really different from...
"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
September 23, 2009 at 8:41 am
jeardilam (9/23/2009)
while (select id_promotionSub FROM dbo.sipFTdataStage)=5
begin
...
"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
September 23, 2009 at 8:40 am
Roy Ernest (9/23/2009)
It is very quiet... And where is Gail? Is she doing fine? It has been long time since I have seen her comment.
I've talked to her offline. She'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
September 23, 2009 at 8:27 am
Sorry I'm late to the party Lynn. This is a fantastic article. It's practically a how-to on writing a good performance test article. Well done.
"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
September 23, 2009 at 6:36 am
Jack Corbett (9/22/2009)
Grant Fritchey (9/22/2009)
Jack Corbett (9/22/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
September 22, 2009 at 5:20 pm
Jack Corbett (9/22/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
September 22, 2009 at 12:06 pm
SSSolice (9/22/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
September 22, 2009 at 11:30 am
Just an insert is not a cause for deadlocks. You've got to have more than one process attempting to get exclusive access to a row or page. Two shared locks...
"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
September 22, 2009 at 9:06 am
jcrawf02 (9/22/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
September 22, 2009 at 9:03 am
Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something wrong 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
September 22, 2009 at 8:36 am
Viewing 15 posts - 16,456 through 16,470 (of 22,226 total)