Good read mate.

Trying to get my head around this...Potentially a stupid question but does it allow you to:

- create a 2 node cluster, 2 Standalone instance, with no shared...

The default trace should give you an idea, depending on how long your logs go back.

Then/if the above bears no fruit.

Server-side trace to capture the ones you suspect of being...

Another one here for "why's it not being reused?"

Q: Has the drive always been this full?

I'd shy away from changing the recovery model if it is in fact not in...

Not sure if this applies but: http://support.microsoft.com/kb/963684

Carlton.

L' Eomot Inversé (10/10/2011)

---

Good question.

But the real answer of course is "it depends" on what the setting of ansi_nulls is; it's on by default in an SSMS query window, so...

Does the dbo schema own the stored proc?

Carlton..

My point exactly, "can't be installed with an odd number...

SQL can't be installed on a single socket machine?

Carlton.

I saw the extra Union/gotcha in this Qotd...but...

Qotd (as far as I understand it) is generally about teaching (at least some of us) something that we weren't aware of, not...

ammuprasath (7/14/2011)

---

hi,

I want to use a custom excel template to export my SSR 2008 report in SharePoint.Could you please help me out in this like how i can achive...

GilaMonster (6/29/2011)

---

No. It's not going to help at all if determining whether fill factor needs dropping as it makes no distinction between pages allocated in the middle of the index...

Certainly Cliff, well played 😉

Carlton.

I believe you certainly are...it's a joke.

Have you been drinking Steve? :hehe:

If DB is in simple mode: you can't back up the transaction log.

Need to break into smaller batches.

Carlton.