There's a good blog post on this here

http://stanleyjohns.wordpress.com/2012/01/31/broker_receive_waitfor-and-database-mail/

He suggests resetting the Database Mail Executable Minimum Lifetime (seconds) parameter if this is bothering you

Also, both the smart keys I have also include a detachable manual key as well, for those moments when you need a genuine key.

The argument over what a "properly thought...

Just on the key thing, a number of manufacturers are going the "smart-key" route, and they are very nice to use. Not fumbling for keys etc. and proximity detection for...

I've read Kimberlys article and the follow up (http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx)

What I was more interested in getting some help with was managing the delayed replication, which appears to be preventing me from...

Between the two different subscriptions to replication, I'm not sure when that'll be!

Thanks for the advice.

Good article and some excellent comments

Not much in here on RAID 50, which is rapidly becoming one of my favourite RAID levels for Data and Backups

Logs and Tempdb are definitely...

You have two answers that are potentially correct here.

None, and None unless the rest of the command specifies one.

Shame I picked the wrong one!

Edit: I stand corrected. The CREATE INDEX...

One difference which I had always assumed (and may be wildly innacurate!) is that NAS communication is all through the Network Stack (TCP) where SAN is through the DIsk I/O...

Just goes to show that adding an index aint always the best approach, even if it seems logical at the time!

Hate to point this out, but ColdCoffee's approach is returning inaccurate results.

Specifically, it returns customers 6 and 7 from the original test data.

Had a play with this and was very impressed - nice job.

I played around and added this index

CREATE INDEX IX_#Purchase_ProductCode

ON #Purchase (

...

nobking (3/7/2012)

i want to partition the userinfo table because i thought that maybe improve performance of select operation

it can use 8 cpu to query each partition to get data by...

Columns in the index are in the where clause and are used to determine which rows to retrieve.

Columns in the include are used in the select clause and are the...

That's one heck of a piece of code!

You've got 250 columns being selected using sub-selects, CTEs, PIVOT and CROSS APPLY in there. Any chance of simplifying it?

How about moving all...

Create a separate instance of SQL on the same server and allocate the memory to that.

😀