That's what I had assumed but wasnt sure if there was a magic DBCC CreateMiraclesFrom('ThinAir') that I could run.

I shall most definitely have a look.

I have a bunch of my own that I've never bothered to share (not because I am selfish but because i suffer...

I've not heard of it. So probably not. What is it?

I did the following:

backup database BOB to disk = 'c:\backups\bob.bak' with stats=1

Hi Tom,

Wow, I am pleased (whilst feeling a bit...

How does one best guess or arrive at a value for Cost Threshold for Parallelism?

Cheers

Cheers Joe.

The reason I didn't want triggers is firstly, this a vendor app and whilst we have control over the SQL Server, we can't get into the guts of the application...

Apologies for my slow reply: Settings are the default as follows:

Cost Threshold for Parallelism = 5
Max Degree of Parallelism = 0

There are no explicit MAXDOPS...

Perhaps screen shots will do a better job of explaining it than I am verbally:

Take a look at the first query that does not include a filter for...

Okay, so weird plot twist.

If  I comment out the portion of the where clause where it filters by compression_desc, then I need some of the tables that have...

Yes because I wanted to see tables that are not compressed with PAGE compression, yet the table that IS compressed by PAGE compression is still showing.

Thanks Chris.

No we're a private company though we do bid on government contracts. The DBA's report to the Infrastructure lead at the moment. The Report writers report to...

Mostly because it seems actual presentations tend to do better than plain proposals with facts.

So I guess ultimately, I am asking for ideas on how to pad it...

Hi Jeff,
I was only joking about banning CSV's.

In regard to the header guff that appears we are talking with the provider, who in turn is talking with...

Mind=Blown.

I thought the row delimiter WAS the LF. Or even at a push the field delimiter + the row delimiter.

I need to lay down whilst working...