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

BSharbo (8/3/2015)

---

I can understanding adding an identity key to a table to facilicate joins to other tables.

However in this instance there is only the one table.

I still probably wouldn't make...

Jeff Moden (8/3/2015)

---

ben.brugman (8/3/2015)

---

Thanks for you reply.

I do tend to get hung up to much by 'numbers' in general, and like to...

I've run into the same type of thing over and over (especially, for some reason NOLOCK, it becomes a magical talisman somehow). There are no easy solutions once people get...

A single one-off shrink of the database just is not a big deal. What happens is that people hit issues with disk, transactions, etc., and they set up automated shrinks...

It's just based on how long the pages have stayed in memory. So from one minute to the next, a page has stayed in memory, at least 60 seconds, so...

Whether or not the primary key for the table should be clustered really is down to experimentation and testing. I'm with Tom that, at least from the description provided, you're...

MJ-1115929 (8/1/2015)

---

@Grant Fritchey

Thanks Grant and hope you are doing well, we had chats several times some time back.

I have one query if we want to force the sql server to...