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...

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack in interviews published? Not...

JoshDBGuy (8/4/2015)

---

Grant Fritchey (8/4/2015)

---

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...

Luis Cazares (8/4/2015)

---

Grant Fritchey (8/4/2015)

---

xsevensinzx (8/3/2015)

---

In my years working in software development from a marketing perspective, the right way always seems a bit too subjective from the people who are...

xsevensinzx (8/4/2015)

---

Grant Fritchey (8/4/2015)

---

xsevensinzx (8/3/2015)

---

In my years working in software development from a marketing perspective, the right way always seems a bit too subjective from the people who are advocating...

xsevensinzx (8/3/2015)

---

In my years working in software development from a marketing perspective, the right way always seems a bit too subjective from the people who are advocating change. That doesn't...

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...

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...

Trying to do all this dynamically is going to be a bear. Can you break apart the USE statement and the ALTER statement?

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.

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...

PJ_SQL (8/3/2015)

---

I have full backup taken every day at 10 PM and transaction log every 15 mins.

So, the data got deleted around 3:30 PM on Friday.

In order to restore I...

Jack Corbett (8/3/2015)

---

Alvin Ramard (8/3/2015)

---

SQLRNNR (8/3/2015)

---

Lynn Pettis (8/3/2015)

---

Read the following comment made today by Silver Spoon on a 4 year old thread:

ok, thank you very much.

I inherited these...

BSharbo (8/3/2015)

---

It is helpful and I truly appreciate it.

Maybe a dumb question... But at the company I work for, pretty much every table has an autoincremented primary key that is...

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...