Viewing 15 posts - 8,011 through 8,025 (of 22,224 total)
The issue is around even older versions of SQL Server. You can't take a SQL Server 2000 backup and restore it to 2012. You have to convert it to 2005...
"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
June 12, 2014 at 3:34 am
Personally, I think the blame lies mostly with the DBAs. Ten to Fifteen years ago, when all the modern development paradigms were starting to shake out, when object oriented programming...
"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
June 12, 2014 at 3:28 am
I have not noticed a general slowdown with SQL Server 2014, so some more details are needed in order to understand what's happening. Although, it's possible that it's the version...
"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
June 11, 2014 at 4:02 am
There's not a real way to say Plan A is better than Plan B. Instead, Plan A results in behavior 1,2,3 and Plan B results in behavior 4,5,6. It's 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
June 10, 2014 at 12:01 pm
GilaMonster (6/10/2014)
Jeff Moden (6/10/2014)
But that's what I'm talking about. That doesn't sound "fully durable" to me but I could be mistaken in what my definition of "fully durable" means.
Hang...
"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
June 10, 2014 at 11:55 am
Jeff Moden (6/10/2014)
GilaMonster (6/10/2014)
Jeff Moden (6/10/2014)
Grant Fritchey (6/9/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
June 10, 2014 at 8:36 am
jasona.work (6/10/2014)
dax.latchford (6/10/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
June 10, 2014 at 8:10 am
It sounds like a good approach, but, one point. You do know that it's actually not likely to speed up your restore process. Assuming you script your restores, currently 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
June 10, 2014 at 8:06 am
Yep, John has nailed it. I'd add a +1 if we had that capability here.
"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
June 10, 2014 at 6:10 am
Compatibility mode is supposed to be a temporary fix as part of the migration of your database to the new server, allowing time for the code and application to catch...
"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
June 10, 2014 at 5:02 am
Assuming we're talking SQL Server 2012, you don't have to set the traceflag any more. The system_health extended event session captures deadlock information automatically.
Deadlocks are fundamentally a performance problem. 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
June 10, 2014 at 4:53 am
SMALLDATETIME only runs January 1, 1900, through June 6, 2079. It sounds like the value you're trying to convert falls outside that range. Or, as Koen already said, it's 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
June 10, 2014 at 4:50 am
Just a suggestion, instead of granting permissions to a user, create a role, assign that role permissions, add the user to the role. That way, you can give multiple users...
"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
June 10, 2014 at 4:48 am
John Mitchell-245523 (6/10/2014)
vijay.singh 14112 (6/10/2014)
Please find the error message below.
Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 8.00.0760. That version...
"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
June 10, 2014 at 4:42 am
But it's like Karen already said. You can create a table in Azure without a clustered index, but you can't put data into it, so what's the point? If anything,...
"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
June 10, 2014 at 4:40 am
Viewing 15 posts - 8,011 through 8,025 (of 22,224 total)