Craig,

I've spent a good bit of time looking at the script and the execution plans. There's a fair bit to say about them at face value, but I'm reluctant...

Which edition of SQL Server is this? Standard?

CELKO (12/10/2010)

---

>> There might be an edge case where putting the join predicates in the WHERE clause makes sense, but I've never come across it. -- Paul <<

LOL! You...

JohnnyDBA (11/26/2010)

---

The book I'm reading says that you can JOIN in either the FROM or the WHERE clause but gives no examples in the WHERE. I've only ever seen...

GilaMonster (11/23/2010)

---

WayneS (11/23/2010)

---

LOL! Yeah, I just bought two a couple of weeks ago (brings me to 3 on that list) - Kalen's and Grant's are the ones I picked up...

GilaMonster (11/23/2010)

---

Anyone up for a challenge?

http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx

I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of NOLOCK to start...

One can only create partitioned tables on Enterprise, it's true, but ALTER TABLE...SWITCH works regardless of any partitioning.

All tables are partitioned (they...

Why use a row-by-row T-SQL scalar function? There's also a horrible hidden cast...

DECLARE @ThisWouldHaveBeenHelpful

TABLE (

Id INTEGER NOT NULL,

Amount ...

No. Why do you need to do this? More information gets you...

Since this is in the SQL Server 2008 forum, you could also use bulk-logged INSERT...SELECT then ALTER TABLE...SWITCH.

The technique is outlined in the Data Loading Performance Guide

It's the same basic...

Yes, recommended but not essential. This maximizes the window where...

Craig Farrell (11/19/2010)

---

Hm, I believe I've tripped on that article before Paul, and it's quite an impressive optimization. I see where you're going with that though. I am...

As written, the function does not work for UPDATE statements because the check constraint will only be evaluated if the column used in the parameter to the function is changed....

Celko has the right idea, that's a much better design. Do that, if at all possible.

The materialized view Mike suggested is the usual 2005 workaround for the lack of...