sqlfriends (8/8/2014)

---

But my question is why bother to grant all these permssions, but just grant this account db_owner role. Becaue it pretty much need all the permissions: read, write, and...

Table definitions, index definitions and actual execution plan please.

RESTORE HEADERONLY FROM DISK = '<path to backup file>'

One of the fields will tell you the version of SQL which created the backup.

Not if the snapshot has been dropped.

Andy Warren (8/8/2014)

---

Technical Lead isn't a bad title, though I'd like it better if it were Database Technical Lead or SQL Technical Lead. Still, I think most reading the title...

senthil kumar d (8/8/2014)

---

But the downside is that the DBA informed me that we are using a SIMPLE recovery database and it is not possible to have filegroup based backup...

Wrong question

SQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't, it...

WHERE <date column> IS NULL

What does "Technical Lead" say about me, I wonder...

Could you be a little more specific about what the problem is?

ScottPletcher (8/7/2014)

---

Seems to me it...

Then do so.

No order by, no guarantee of order. End of story.

Tables don't have a defined order. They are unordered sets of rows.

Edit: and put the TOP on the select. Along with...

alex_pixley (8/7/2014)

---

It's like insulating your home. There is the upfront cost of time and effort. ...

Ok, good, I'm not the only one who would think 'blocking' long before thinking 'let me post this impossible situation on the forums'