Viewing 15 posts - 18,766 through 18,780 (of 22,226 total)
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
GilaMonster (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:36 am
DavidB (1/13/2009)
Briefly start the trace and then pause it. Goto File->Export->Script Trace Definition and pick your DB version, and save to a file.
The reason I asked is because, 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:29 am
GermanDBA (1/13/2009)
as of yet no issues in itself. It looked extremely clumsy when you want to control the database objects between DEV,QAS and Prod systems. Maybe I/we...
"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:03 am
I'm not a fan of maintenance plans, not enough control.
Use the TRY/CATCH mechanism to trap the errors. As long the error doesn't cause a disconnect, you should be able 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 6:58 am
nitinpatel31 (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 6:52 am
1) Actually for performance, I'd do this:
IF NOT EXISTS (SELECT * FROM Users WHERE UserID = @UserId)
BEGIN
If you need to use the parameter value @Name later, then the first choice...
"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 6:50 am
You guys are describing how to save the trace definition, not the template. Is that what you need Brandie?
"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 6:44 am
I don't know the precise mechanisms (you'll need to ask Microsoft) that the DTA uses, but I know that it relies on the statistics on the indexes and tables 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 6:42 am
Viewing 15 posts - 18,766 through 18,780 (of 22,226 total)