Viewing 15 posts - 5,386 through 5,400 (of 22,219 total)
You're posting in the 2008 forum with a 2005 question.
If you were in 2008 I could tell you to look at the system_health extended event session which captures deadlock information....
"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
November 12, 2015 at 4:41 am
No.
Differentials are like Full backups. You restore the backup using the STOPAT, then you can use logs to get to 5PM. If you use the differential, I think it'll error...
"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
November 12, 2015 at 4:38 am
Alan.B (11/11/2015)
sgrimard (11/11/2015)
Any suggestion on good books or site to learn how to create good index?
SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) by Grant Fritchey 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
November 12, 2015 at 4:30 am
BL0B_EATER (11/12/2015)
"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
November 12, 2015 at 4:25 am
The variable is not able to be sampled by the optimizer, so it generates an estimate from the statistics instead of using a specific value. When you pass a specific...
"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
November 11, 2015 at 8:03 am
samot-dwarf (11/11/2015)
Just steer clear of multi-statement table valued functions, and everything will be OK.
Maybe your devs want to replace RedGateMonitor.[utils].[SplitString] with something as at http://www.sqlservercentral.com/articles/Tally+Table/72993/ :hehe:
We have a winner!
"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
November 11, 2015 at 4:21 am
Steve Jones - SSC Editor (11/10/2015)
jasona.work (11/10/2015)
"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
November 10, 2015 at 12:39 pm
MattieNH (11/9/2015)
Although it completely violates the spirit of the editorial, I would suggest that thismost people make great and interesting choices
should read:
most people make great or interesting choices
Ha! Also...
"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
November 9, 2015 at 12:33 pm
Gary Varga (11/9/2015)
I now look back 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
November 9, 2015 at 8:01 am
Jeff Moden (11/8/2015)
Grant Fritchey (11/8/2015)
Agreed. Can't let the perfect become the enemy of the good. That said, when you're introducing technical debt, know that.
Heh... I was going to say "Good...
"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
November 9, 2015 at 8:00 am
Agreed. Can't let the perfect become the enemy of the good. That said, when you're introducing technical debt, know 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
November 8, 2015 at 7:38 am
tom-864693 (11/7/2015)
"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
November 8, 2015 at 7:36 am
Eirikur Eiriksson (11/7/2015)
Grant Fritchey (11/7/2015)
xsevensinzx (11/6/2015)
Least it has the database engines listed. :hehe:Get's even worse with the use of 'NoSQL' or 'Hadoop'.
Yeah, but it shows Profiler
BURN IT WITH FIRE!
Grant, 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
November 8, 2015 at 7:33 am
xsevensinzx (11/6/2015)
Least it has the database engines listed. :hehe:Get's even worse with the use of 'NoSQL' or 'Hadoop'.
Yeah, but it shows Profiler
BURN IT WITH FIRE!
"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
November 7, 2015 at 5:26 am
Lynn Pettis (11/6/2015)
"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
November 7, 2015 at 5:25 am
Viewing 15 posts - 5,386 through 5,400 (of 22,219 total)