Andy,

Great article!  I especially like the fact you pointed out what happens when the backup fails on part of the mirror, and I'd echo your sentiments... be good if there...

I think it's pretty good, but a couple of other additions that are useful:

The microsoft health and history monitoring tool.... it's pretty slick and is very helpful when it comes...

Nice article!

It is a pretty good example of CTE.... if you think about some other logic in the CTE other than just creating 10, maybe something more complex.... it would...

I wonder if maybe it could be a good idea on a read-only database.  Many situations I've worked with in the past had a 'readonly' db used as a datamart...

Good article!  It was very informative.

Excellent article!

I knew it increased performance setting nocount off; the fact that the performance increase is so slight is interesting....  I would have expected more of a performance increase.

Mark

Jambu,

Thanks for sharing your info - this topic sparked a great discussion on the topic!

Mark

Mark,

I've found that UDF's that return table variables, or larger data sets tend to be awful slow, since the returned 'table' ends up not using any indices.  If you can...

What I've seen in the past is that table variables tend to be a little faster with smaller data sets than temp tables.  has anyone else noticed the same thing?

I...

Roy,

Pretty good article.

I have a little script I use to determine if I'm running out of space on each of the server drives and send me an email when the...

But what would stop them from having multiple connections or multiple accounts? if you use 500,000 connections you'd still get them all out in 1 second?

Spam is big business - these guys are making lots of $$$.  Somehow make it less lucrative for them and you'll solve the problem.

I've found working full-time it's been hard of late to convince employers of the value of training - that's part of the reason I've gone back into contracting.

I worked for...

Right.. I guess you'd have to look real close at each object and make really sure it's not being used.  It could point you in the right direction I guesss...  You...

This one scares me a little bit; if you have some procs that are run once a quarter or once a month would they show up in the cache?