Jeff Moden (2/10/2014)

---

SQLRNNR (2/10/2014)

---

Jeff Moden (2/10/2014)

---

SQLRNNR (2/10/2014)

---

jewel.sacred (2/10/2014)

---

@Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle...

Now you just wait it out. The spid is in a rollback state and all you can do is wait for it to finish.

Jeff Moden (2/10/2014)

---

SQLRNNR (2/10/2014)

---

jewel.sacred (2/10/2014)

---

@Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No...

Lynn Pettis (2/10/2014)

---

Ed Wagner (2/7/2014)

---

Lynn Pettis (2/7/2014)

---

jasona.work (2/7/2014)

---

Lynn Pettis (2/7/2014)

---

I have been home since Sunday afternoon and today is the first day it has been warmer than it has been...

Jeff Moden (2/10/2014)

---

Take a backup before doing the shrink and a backup prior to doing what comes up next...

If you don't mind NOT having point-in-time backups while the indexes are...

Have you checked with the local recruiting agencies?

I have seen this happen at a client for the following reasons.

Master database files were deleted (by the hosting service). The backup was restored on a different server and...

MyDoggieJessie (2/10/2014)

---

@SQLRNNR - I agree with you 100% - I didn't say it wouldn't - I was saying it would not force new execution plans to be created.

I was answering...

MyDoggieJessie (2/10/2014)

---

Shrinking a database wouldn't cause the creation of any new execution plans.

Yes, this will cause your log file(s) to fill/grow (especially so with the index maintenance)

If space...

jewel.sacred (2/10/2014)

---

@Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No disrespect to Olla's...

http://www.pinkspage.com/us/home

MHilsher (2/10/2014)

---

Well I will add my 2 cents after over 30 years in the IT business. Including twice owning my own consulting business. And my pet peeve is...

hisakimatama (2/10/2014)

---

Hm. Personally, I left my last job after a year and a half; things started out rather good, but after the first year, management became rather frustrating to...

Eye disease

Luis Cazares (2/10/2014)

---

Welcome to the forums and SQL.

Files with extension .sql are simple text files with scripts. You can't query them as a database.

If you want help over skype or...