here you go[/url]

GilaMonster (4/22/2012)

---

A query's cost is not the number of seconds that SQL thinks it will take to run. Yes, the documentation says it is, the documentation here is wrong. Costs...

CTP will have no bearing when maxdop is...

Have you thought of throttling the Litespeed backups

Cost threshold is in secs based on what the optimiser thinks a query wy take in secs

balasach82 (4/21/2012)

---

Perry,

While creating a DB, if the size is not given, it takes the size of the model, whereas if the size is given (which is greater/lesser than model size),...

+1, but the only...

balasach82 (4/21/2012)

---

Thanks Gail for the immediate clarification. I too was wondering that it does not make sense to modify model (which eventually would have an effect on the new user...

evevea (4/20/2012)

---

Thank you very much. I have seen that page but was expecting a bit more than just "How to obtain ...." and How to install SQL server itself.

For...

The advantage of course is that the table\indexes are still available during the rebuild operation.

Asynchronous only is supported in Enterprise edition

lbrigham (4/19/2012)

---

the next concern is that transactions logs from all databases every 15...

SQL server 2008 R2 express edition can only participate in replication as a subscriber!

meckeard (4/19/2012)

---

Hi everyone.

My company will be setting up a clustered instance of SQL server 2k8 r2 on vm's and I wanted to know if anyone had recommendations for a book...

You're welcome, if you reference the links in my article there is detail in there...

It's installed with...