And you tested that statement and confirmed it to be true?

Why are you looking for an alternative to NOT EXISTS?

renitaj (5/31/2014)

---

Problem with this database is that I have deleted data in the past and hence the fileids are not consecutive and hence when i attach it on the destination...

Lack of log backups don't cause negative used space.

Sequences sound like a good choice here.

ramana3327 (5/29/2014)

---

What I understand is that, we have to put all the values from the left table to the table variable, first. Then we have to UPDATE the table variable...

If the indexes are absolutely identical, then it cannot matter which you drop because they are identical.

A table variable, like any other variable, is only in scope until the end of the batch. If you run the table variable declare, then as another batch run the...

High memory utilisation is good. It means SQL is correctly using the resources that you've told it that it can use (via max server memory)

Michael_Garrison (5/30/2014)

---

1. Why use CTE? I see a number of times when people answer others questions that they use CTE's. I understand for recursive code issues. ...

The location does not exist. If it did, you wouldn't be getting this error:

You need to figure out where SQL is trying to create...

Without seeing some code, there's nothing anyone can do but guess.

In general, dynamic can be faster if you're encountering parameter sniffing problems or other problems related to an unstable...

The error log lists the NUMA setup. Post that.

If Steve's managed to squeeze a 6 week break into a 2...

Did you ever test the backup after it was made?

Restore it somewhere else and check as well.

Also, make sure you restored the right backup in the right place. 🙂