Viewing 15 posts - 7,291 through 7,305 (of 22,219 total)
The best way is to have a full script that does the restore and cleans up the database to remove or modify the data that shouldn't be accessible, all as...
"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
October 28, 2014 at 7:40 pm
cdesmarais 49673 (10/27/2014)
"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
October 28, 2014 at 4:10 pm
Evil Kraig F (10/27/2014)
"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
October 28, 2014 at 4:08 pm
Matt Miller (#4) (10/27/2014)
Iwas Bornready (10/27/2014)
"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
October 28, 2014 at 4:02 pm
Iwas Bornready (10/27/2014)
"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
October 28, 2014 at 4:00 pm
Meow Now (10/27/2014)
"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
October 28, 2014 at 3:59 pm
Best thing to do is put the database into restricted user, not single user. Although, that presumes you're not letting your apps connect as 'sa'.
If you are, then have the...
"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
October 28, 2014 at 11:21 am
You should treat any SQL Server instance on a cloud VM the same way you'd treat it on a local VM or even on local hardware. You look to performance...
"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
October 28, 2014 at 11:16 am
Luis Cazares (10/28/2014)
Grant Fritchey (10/28/2014)
jeffgonzalez007 (10/28/2014)
"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
October 28, 2014 at 11:11 am
jeffgonzalez007 (10/28/2014)
"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
October 28, 2014 at 10:49 am
Koen Verbeeck (10/28/2014)
Grant Fritchey (10/28/2014)
"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
October 28, 2014 at 8:57 am
It's the last ID generated for any session in any scope. So another session may have experienced a rollback or something else that caused it to generate an identity value...
"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
October 28, 2014 at 8:41 am
The fundamentals are the same from 2005 through 2014, so on lots of levels, it doesn't matter which you study. However, your knowledge will have a longer shelf-life if 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
October 28, 2014 at 8:38 am
While it certainly could be AG, and that's really the only evidence we have, I'd suggest capturing a bunch of metrics in order to understand where the problem lies rather...
"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
October 28, 2014 at 7:41 am
I'd suggest looking at the system to see what it's waiting on. You can query the dynamic management views to pull information out. This book (free download) shows a number...
"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
October 28, 2014 at 7:38 am
Viewing 15 posts - 7,291 through 7,305 (of 22,219 total)