Viewing 15 posts - 11,446 through 11,460 (of 22,219 total)
And look at when it was created. You have that information in the sys.dm_exec_query_stats DMO.
"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 10, 2012 at 4:28 am
The cost of an execution plan is just an estimate based on how many CPU and I/O resources that the query optimizer estimates that query will use.
You can use this...
"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 10, 2012 at 4:27 am
azdzn (1/9/2012)
You will only know how many times it has been called since last...
"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 10, 2012 at 4:22 am
You can have the identity column increment up, or down, but not both at the same time. To have it increment to negative numbers, set the increment value as -1...
"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 10, 2012 at 4:18 am
And only run the shrink one time after dropping all the tables. If you run it multiple times you're going to be fragmenting your files a lot.
"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 10, 2012 at 4:12 am
Brandie Tarvin (1/9/2012)
I have this image in my head of me wearing a monocle and top hat while holding cane in one hand and a cuppa in the other.
Oh,...
"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 9, 2012 at 9:34 am
Roy Ernest (1/9/2012)
When I get time post some thing,...
"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 9, 2012 at 9:31 am
san43 (1/9/2012)
I am specifically looking for any document published by Microsoft regarding T-SQL standard coding guidelines or best-practices, so that I can suggest developers...
"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 9, 2012 at 8:31 am
Perry Whittle (1/4/2012)
Jeffrey Williams 3188 (1/4/2012)
Perry Whittle (1/4/2012)
"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 9, 2012 at 5:45 am
WayneS (1/6/2012)
Steve Jones - SSC Editor (1/6/2012)
User posts
SQLRNNR ...
"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 7, 2012 at 5:56 am
GilaMonster (1/6/2012)
Grant Fritchey (1/6/2012)
Brandie Tarvin (1/6/2012)
Evil Kraig F (1/5/2012)
"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 6, 2012 at 11:19 am
Ninja's_RGR'us (1/6/2012)
Where the 1000 pages actually comes from... & the guy who wrote that code at MS!
Yeah, Paul Randal's bottom. Ha!
1000 pags is a good a guideline as anything. 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 6, 2012 at 11:15 am
Brandie Tarvin (1/6/2012)
Evil Kraig F (1/5/2012)
"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 6, 2012 at 10:59 am
No, you'd need to use one of the standard methods, OPTIMIZE FOR, local variables, stats updates... which ever one worked best for your situation.
"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 5, 2012 at 1:13 pm
Backups. Make sure everything is backed up. And that's SQL Server backups, not file backups. Biggest error for people starting out is not getting good backups in place.
"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 5, 2012 at 1:10 pm
Viewing 15 posts - 11,446 through 11,460 (of 22,219 total)