Viewing 15 posts - 10,936 through 10,950 (of 22,219 total)
I have a book on that topic, linked the signature below, or you can search online and find a free e-book copy of the book. I also post regularly on...
"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
May 7, 2012 at 5:03 am
The simplist option is to restore the production database on your development environment. I agree with the previous poster, you should set up scripts to clean out any sensitive information.
After...
"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
May 7, 2012 at 4:59 am
If you're in transactional replication, did replication fail? Is the distributor down?
"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
May 4, 2012 at 12:19 pm
Although, if you're simply testing the restore to validate the backup, the fact that logins don't sync correctly is not an issue you need to worry about.
"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
May 4, 2012 at 9:16 am
Yeah, you can't test this against production systems. Good first choice.
After that, just take the backups that are already running in production and test them in a restore against 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
May 4, 2012 at 7:34 am
Megistal (5/4/2012)
It works exactly as you described. It even works when using FORCESEEK (as it should as Microsoft stated)
It would be nice having an index hint that force index...
"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
May 4, 2012 at 6:37 am
That's not one I've hit on all the 2012 installs I've done. I'd suggest taking it to Microsoft. Go through support or post it as a Connect item.
"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
May 4, 2012 at 5:18 am
A backup is a bit-by-bit copy at the page level of the database. No way to single out objects from it, at all. You have to script this.
700 stored procedures...
"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
May 4, 2012 at 5:15 am
Glad the book is useful.
Not that one though. This one is out soon.
"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
May 4, 2012 at 4:33 am
Index intersection is rare and hard to demo. I have a demo of it in my query tuning book, but it's pretty contrived. You won't see it in the wild...
"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
May 3, 2012 at 12:21 pm
Lynn Pettis (5/3/2012)
SQL Kiwi (5/3/2012)
Lynn Pettis (5/3/2012)
SQL Kiwi (5/3/2012)
One possible test is to imagine one's mother reading the post before hitting 'reply' and wondering if it would make her proud.
Not...
"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
May 3, 2012 at 10:58 am
Sean Lange (5/3/2012)
/soapbox on
We are starting to lean too far to the arrogant side with many of our replies (and yes I am guilty...
"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
May 3, 2012 at 10:54 am
Replication & log shipping are going to require you to upgrade the servers involved, so no, you have to do a full upgrade. SSAS & SSRS can be installed seperately,...
"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
May 3, 2012 at 5:50 am
SSIS is just like the database, you can't go backwards on the versions, so you'll have to move them by hand too.
In addition to data types, make sure you...
"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
May 3, 2012 at 5:49 am
Take a look at Amit Banerjee's write-up on that wait type[/url]. It might be a less than optimal measure due to how it accumulates artificially.
"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
May 3, 2012 at 5:40 am
Viewing 15 posts - 10,936 through 10,950 (of 22,219 total)