Viewing 15 posts - 13,681 through 13,695 (of 22,224 total)
Thank you. I hope the book has been useful.
"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, 2011 at 7:36 am
There's also Red Gate SQL Virtual Restore, that would allow you to "restore" the database to a different location and pull the data off. The nice thing about this 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
January 9, 2011 at 7:34 am
You have a lot of options. We do this at work just using the nightly backup to perform a restore. It does two things. It gets us that test environment...
"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 8, 2011 at 6:02 am
I would be extremely cautious about taking the missing index reports at face value. They are frequently more than a little bit inaccurate and can lead to too many indexes...
"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 8, 2011 at 5:20 am
pascalbjr (1/7/2011)
"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, 2011 at 1:56 pm
Another vote for Red Gate tools. They're pretty amazing. They primarily will help in development and maintenance. In terms of performance, they have a new tool, SQL Monitor that will...
"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, 2011 at 1:48 pm
Craig Farrell (1/7/2011)
Donalith (1/7/2011)
"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, 2011 at 1:42 pm
Do you think Documentum or SharePoint are the best document management tools? Hard to say right? But they each one use a different schema, so saying, "This schema is best...
"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, 2011 at 1:34 pm
If I recall the chapters in Kalen's book correctly, there is a strong bias to row locking, but, no you can't really guarantee the locking type, and to a degree,...
"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, 2011 at 1:26 pm
johnl 80306 (1/7/2011)
"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, 2011 at 11:10 am
Yeah, it could be an implicit conversion on the date causing the issue. Either way, because the strings are different and the values are different, you can't guarantee that you'll...
"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, 2011 at 11:08 am
Maybe I don't understand the question, but shouldn't you just modify the process that is running the backups so that it overwrites the file each night instead of generating 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 7, 2011 at 10:23 am
Yeah, that's an easy one:
UPDATE SysLog SET Hostname ='eub-dc-psesx-07'
from syslog
WHERE (DateTime >= 'Jan 2 2011 2:40:50:443AM')
AND (IP = '10.20.98.156') AND (Hostname = 'eub-dc-psesx-07') AND (EngineID = 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 7, 2011 at 10:20 am
I know of this book. It's pretty good. It's on the MCM reading list... look down near the bottom of my post.
"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, 2011 at 8:16 am
If you're working with SQL Server 2008, I'd go for using Change Data Capture. It's going to give you a lot more functionality, easily, than you can build yourself.
"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, 2011 at 7:56 am
Viewing 15 posts - 13,681 through 13,695 (of 22,224 total)