That's always a nice surprise

jasona.work (5/7/2013)

---

I love it when I find out I don't need to do something I thought I'd need to do because of something I did...

I'm all set to shrink a...

I will add my thanks to the list -...

That would be correct. After the shrink, you will need to rebuild due to the fragmentation the shrink will cause.

jasona.work (5/7/2013)

---

SQLRNNR (5/7/2013)

---

Another option is to find the largest table in the database, multiply it by 1.5. Once you have that number, shrink the file to leave at least...

Another option is to find the largest table in the database, multiply it by 1.5. Once you have that number, shrink the file to leave at least that amount...

I was timely -...

What, no controversy for this question?

Thanks Vinay

Well, it could be just your copy. It could be the drive that is no good. And it could also mean that the original bak file is also...

I'm with Steve, I think the file might be corrupt.

The optimize for adhoc is storing a plan stub instead of a full plan. You may have more stubs getting stored because you have more space. The stub...

Did restore headeronly produce the same error or did it run?

Also, do you have any IO related errors in the event logs?

My experience with both courses is that they are limited in how much database work is involved. The CS degree is generally more development oriented and the CIS is...

If memory serves correctly, MS has partnered with MeasureUp previously.

With that hardware, I would probably install SQL Server and User databases to the RAID 1. Save the other drive for the backups or maybe for tempdb.

With these kinds...