Viewing 15 posts - 7,291 through 7,305 (of 22,221 total)
It doesn't sound like it's 2014. It sounds like your linked servers and your DTC are not set up correctly. It's also possible it's a security issue. I'd suggest double...
"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 29, 2014 at 3:11 am
There are a few options. If you have access to MSDN at work, get a developer copy through that. Or, if you have MSDN at work, hook up your Azure...
"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:46 pm
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
Viewing 15 posts - 7,291 through 7,305 (of 22,221 total)