Thanks for the response.

I can probably use TCO figures to derive what I'm looking for, but that's more for comparing products, which does need to factor in.

I was hoping to...

pretty simple query. Not much SQL to tune.

looks like building a nonclustered index on mode will help this query a great deal.

Be cautious when adding indices, as they slow...

I also home-brewed a solution with C# (SMO) and powershell...

it is an important thing to do and it would be pretty awesome if I didn't need to have spent...

great article. Thanks for sharing!

I know you're not necessarily asking this, but your issue is the result of too much ad-hoc SQL and the caching of those permissions.

Microsoft will tell you to reduce the...

ecause on every instance I see the following entry daily in the log:

A significant part of sql server process memory has been paged out. This may result in a performance...

carl-793059 (3/4/2010)

---

It seems to me the ADO.NET datasource is also a valid answer. A ForEach Loop Container can also reference an object variable as a datasource via ADO.NET. See the...

Jonathan Kehayias (3/1/2010)

---

SQLBOT (3/1/2010)

---

It's the random insertion, not the datatype that causes the problem.

What's the differece if the data inserted is Johnson, Jonsonn, Johnsen or three guids?

Under the hood,...

the STATS_DATE() function can tell you the last time the stats were updated.

I think if you're using sp_updatestats you're fine, but I've found that it actually isn't quite enough sometimes...

http://msdn.microsoft.com/en-us/library/ms176034(SQL.90).aspx

Your new SQL Server should register itself with perfmon when it's installed.

I'm not sure about your experience level or anything so don't take this the wrong way:

are you pulling down...

I also forgot to say that there is the NEWSEQUENTIALID() function if you're going to batch load.

That should wreck your cluidx a little less, too.

obviously the super-best data type for...

Very impressive article!

I'm just now being asked to transition to some DW work after eons of doing primarily OLTP support.

I'm bookmarking this article!

Thanks so much for your efforts.

At first I was disturbed by the lack of a rollback, then realized it was an istead of trigger.

I'm going to use that in my robotic arsenal, thanks BB!