Viewing 15 posts - 5,791 through 5,805 (of 22,226 total)
Yeah, you're trying to create an Azure SQL Database copy of Adventureworks. You're in a VM. That's just like any other version of SQL Server. So you can go to...
"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
August 4, 2015 at 11:54 am
Steve Jones - SSC Editor (8/4/2015)
Is there value in getting the questions/knowledge that people lack in interviews published? 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
August 4, 2015 at 10:58 am
JoshDBGuy (8/4/2015)
Grant Fritchey (8/4/2015)
"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
August 4, 2015 at 10:51 am
Luis Cazares (8/4/2015)
Grant Fritchey (8/4/2015)
xsevensinzx (8/3/2015)
"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
August 4, 2015 at 8:49 am
xsevensinzx (8/4/2015)
Grant Fritchey (8/4/2015)
xsevensinzx (8/3/2015)
"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
August 4, 2015 at 8:41 am
xsevensinzx (8/3/2015)
"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
August 4, 2015 at 4:50 am
You're better off doing custom scripts. MERGE can, and does, function. But, it's not very tuneable. You get a single execution plan for the INSERT/UPDATE/DELETE regardless of which is used...
"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
August 4, 2015 at 4:42 am
Capture your wait statistics during the backup process. That will tell you what is causing things to run slowly. As Gail explained, it won't be blocks, but it could be...
"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
August 4, 2015 at 4:39 am
Trying to do all this dynamically is going to be a bear. Can you break apart the USE statement and the ALTER statement?
"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
August 3, 2015 at 8:48 pm
All the minor upgrades. And, when you don't have a choice. It's just not as safe as having a second server sitting right there.
"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
August 3, 2015 at 8:45 pm
Pretty much exactly the same as any other restore. The only exception is you'll need to use the WITH MOVE option to change the location of the files. Here'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
August 3, 2015 at 4:47 pm
PJ_SQL (8/3/2015)
So, the data got deleted around 3:30 PM on Friday.
In order to restore I...
"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
August 3, 2015 at 12:06 pm
Jack Corbett (8/3/2015)
Alvin Ramard (8/3/2015)
SQLRNNR (8/3/2015)
Lynn Pettis (8/3/2015)
ok, thank you very much.
I inherited these...
"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
August 3, 2015 at 11:25 am
BSharbo (8/3/2015)
Maybe a dumb question... But at the company I work for, pretty much every table has an autoincremented primary key that 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
August 3, 2015 at 11:21 am
The problem is, you can't restore parts of transactions. Instead of restoring to your existing database, I'd suggest restoring your database to the point prior to the delete, recover just...
"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
August 3, 2015 at 11:15 am
Viewing 15 posts - 5,791 through 5,805 (of 22,226 total)