Grant Fritchey (5/2/2011)

---

Steve Jones - SSC Editor (5/1/2011)

---

So I've gotten more than a few complaints about posts like this from Syed Jahanzaib Bin hassan.

http://www.sqlservercentral.com/Forums/Topic1101142-146-1.aspx#bm1101269

I can certainly appreciate he/she is annoying,...

Did you READ THE SCRIPT? There's no compression in it.

For the 10TH TIME already, stop blabbering answers just for the sake of getting points and links to your useless...

Ray Mond (5/2/2011)

---

As stated by the other guys, a backup file only contains data pages that are actually used. If you run the following script:

CREATE DATABASE sizetest ON PRIMARY(NAME...

SanDroid (4/29/2011)

---

Ninja - If the reports running these mystery querries are Crystal Reports or Business Objects Reports you are in for some fun.

I worked in a large environment...

Between Grant and I we must have studied over 10 000 plans. We can't possibly tell you all the things to check on this thread alone. We need...

Syed Jahanzaib Bin hassan (4/29/2011)

---

Yes,because he doesnt mention how many files and he mentioned files are 5GB restricted growth its mean each file have restriction of 5GB ,database size is...

Please post the actual execution plan for both servers (not estimated).

How could that possibly...

cfradenburg (4/29/2011)

---

Ninja's_RGR'us (4/29/2011)

---

Maybe I missed it but I can't see a with async option on the create/update stats command. Does that mean that the setting is only at...

Plz don't cross post, I had already answered that question in that thread.

Plz finish the discussion there.

http://www.sqlservercentral.com/Forums/Topic1100743-8-1.aspx

cfradenburg (4/29/2011)

---

It's asynchronous so...

Jason Selburg (4/29/2011)

---

On a serious and slightly related note. Years ago, I believe sometime around 2005, Steve and Red Gate gave out free copies of SQL Prompt for the "top...

Can you ask to have those file names sent with timestamp? It's really not that much work. Also it makes it easier to understand what's in the...

Check out Try catch in books online (sql server's help file).

I understood what you meant, I just felt I had to clarify even further... nothing wrong wiht ioure anglich dud! 😉