Viewing 15 posts - 18,751 through 18,765 (of 22,219 total)
Seems a little extreme... two words, Guy Fawkes.
"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
January 13, 2009 at 7:55 pm
Steve Jones - Editor (1/13/2009)
Thanks for the note and I do appreciate the kind words. I'd wear the Gears of War shirt,...
"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
January 13, 2009 at 11:55 am
GilaMonster (1/13/2009)
A single transaction is a single transaction, regardless of whether it's in one huge procedure of split up among several smaller procedures all called from a parent. Locks are...
"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
January 13, 2009 at 11:50 am
DavidB (1/13/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
January 13, 2009 at 11:49 am
DavidB (1/13/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
January 13, 2009 at 10:54 am
Steve Jones - Editor (1/13/2009)
Hmmmmm, I think I...
"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
January 13, 2009 at 10:52 am
Brandie Tarvin (1/13/2009)
I was going to make due with what I had, but I'd like to...
"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
January 13, 2009 at 10:50 am
And, SQL Server 2008 has a monitoring suite built in, although it's not as sophisticated as the offerings from Quest & Idera and others.
"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
January 13, 2009 at 10:11 am
Seth Lynch (1/13/2009)
I suspect it is incomplete and someone put SET in by mistake and left it there.
The strange thing it that SQL Server 2000 seems to ignore it and...
"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
January 13, 2009 at 9:27 am
It looks like incomplete code. I would have thought what was meant was something like:
DECLARE @fId INT;
SET @fId =42;
Of course with 2008 you can:
DECLARE @fId INT = 42;
"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
January 13, 2009 at 9:05 am
Red Gate offers a tool that does a bare-bones, is it up or does it have a problem type of monitoring. Idera has a pretty good tool that does what...
"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
January 13, 2009 at 8:59 am
Jack Corbett (1/13/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
January 13, 2009 at 8:49 am
nitinpatel31 (1/13/2009)
Grant Fritchey (1/13/2009)
Under what circumstances have you seen seperating a statement from one procedure into a seperate procedure lead to deadlocks? That's a new one for me.
If proper transaction...
"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
January 13, 2009 at 8:45 am
GermanDBA (1/13/2009)
I thought it sounded a little complicated the way that they had suggested.
It also seemed a little silly that MS would bring something like that to market, especially...
"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
January 13, 2009 at 8:41 am
DavidB (1/13/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
January 13, 2009 at 8:38 am
Viewing 15 posts - 18,751 through 18,765 (of 22,219 total)