Viewing 15 posts - 11,401 through 11,415 (of 22,219 total)
L' Eomot Inversé (1/17/2012)
Jeff Moden (1/16/2012)
I'll reserve my opinion on this but thought I'd give everyone a heads up...http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
I believe (sadly) that this will have no effect at all...
"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 17, 2012 at 5:45 am
We do have ASK.SQLServerCentral.Com if you really prefer posting to a place with a reputation system.
The thing is, some questions lend themselves to that style of web site. But many...
"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 17, 2012 at 5:32 am
You can make it a little cleaner:
DECLARE @MyParam1 VARCHAR(50) = '42',
@MyParam2 INT = 42,
@MyParam3 TINYINT = 2 ;
"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 17, 2012 at 5:25 am
A quick summary of the things you can do for database backup testing. The best thing you can do is to test the restore. There are some third party solutions...
"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 17, 2012 at 5:12 am
The cached plan only saves you recompile time for performance. A multi-statement table valued function is only good for working with very small data sets. This is because, as Gail...
"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 17, 2012 at 5:08 am
GilaMonster (1/13/2012)
azdzn (1/13/2012)
it still looks like 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
January 17, 2012 at 5:06 am
Gianluca Sartori (1/13/2012)
GilaMonster (1/13/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 17, 2012 at 5:05 am
Just so you know, you're venturing into a huge topic area. In my signature line are two books that might help. The one on execution plans is available in electronic...
"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 17, 2012 at 5:02 am
Queries don't stay available in the cache forever. If you ran it once and it had a low cost, chances are if there's any memory pressure on the system at...
"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 17, 2012 at 4:59 am
Jeff Moden (1/16/2012)
I'll reserve my opinion on this but thought I'd give everyone a heads up...http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
The House of Representatives have permanently shelved this abomination. We just need to light...
"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 17, 2012 at 4:41 am
Roy Ernest (1/16/2012)
And I got a A+ review for the year 2011 from my CTO. So...
"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 16, 2012 at 6:23 am
Best is really subjective depending on what you're looking for out of the tool. I'd recommend you take a look at SQL Monitor[/url] from Red Gate Software. Full disclosure, 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 16, 2012 at 5:05 am
L' Eomot Inversé (1/12/2012)
Grant Fritchey (1/12/2012)
GilaMonster (1/12/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had 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
January 13, 2012 at 4:04 am
If you're going to target the updates, I'd rebuild indexes that need it, then defrag those that need it, then update stats for those that were not rebuilt. But 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
January 12, 2012 at 4:28 pm
In general, most of the time, I run update stats on each individual index, not the table. I leave the table stats to fend for themselves. If I really, really...
"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 12, 2012 at 11:16 am
Viewing 15 posts - 11,401 through 11,415 (of 22,219 total)