"Just name a hero and I'll prove he's a bum." --Gregory "Pappy" Boyington

Being "the keeper of the secret information" is stupid. There. I've said it and I...

http://xkcd.com/936/

Understand execution plans.

Try restarting the SQL Agent service.

@Silok

Re: "Only one question after the deleting the reserved space did not go down, it was the same as before any reason for that?"

I'd strongly suggest reading the...

Re: I will have to place the query in a SQL job and run that weekly once, please help me out.

With 2.2 billion records in your table, why would...

@below86

I guess the real draw would be if you wanted to automate a series of events. I'm probably not coming up with the best example but maybe...

I recall plinking around with server-side traces a while back and vaguely remember that if Profiler is writing to the file, it locks the file. I had to write...

I apologize for being late to the party. Typically I'd quietly read but I'd like to post my thoughts even though I'm not at the level of prior contributors...

My apologies to all SQL Server Central readers in this thread.

It's amazing how a conversation 10 minutes before posting can influence the thought process. I'd just had a discussion...

Got it. I understand now. I just had to laugh at [what I thought] was a ...less than informed... choice.

I agree with you: MS could definitely...

I may be wrong but I think [not] putting this functionality in the product encourages third party vendors to "partner" with MS to provide add-on products, spreading the wealth...

I just...

Re: DBCC SHOW_STATISTICS ... multiple tables

In BOL, review the <option> argument.

@tfifield

I apologize for not replying to your question. I was in the middle of rolling out our production SAP implementation at corporate when I posted and, well,...

How about including [both] tables? (I'll stop at this point to include the usual disclaimers: "if the key columns are indexed...", etc.)

/* Create some test tables with data */

IF...