Then you should post this in a SQL 2000 forum.

You might also want to take a look at Adam Machanic's book Expert SQL server 2005: http://www.amazon.com/gp/product/159059729X/ref=cm_arms_pdp_dp

Especially chapter 9: "Spatial Data", which I think was written by HUGO KORNELIS (who...

No. Nor do I care if you are a student, in fact I still consider myself...

I have an idea on the shelf for an article/presentation called "The Top Ten Reasons that You Don't Already Use Service Broker".

Service Broker works great, once you've got it going,...

IS there a...

Like this:

UPDATE footable

SET fiscaldate = CAST(fiscalperiod+'01' as DateTime)

WHERE ...

This does look like homework.

If you look in Books OnLine, in the index for "attaching databases", you should find all of the information that you need.

I saw a lot of possible redundancy in the query plan, so it is possible that either some consolidation using WITH, or using Temp tables could work here.

It can be, but only if the partition is on...

Use PerfMon to measure the Disk response time during your tests on both Test and Production. If production is significantly slower, take the numbers to IBM to confirm that...

Any chance of getting the fully expanded query?

Holy Crap!

This may be the sickest thing I've ever seen!

Because .net would just make it harder. I would use .net if I needed to, bu so far this would be easier without it.

You just need to have multiple CASE functions:

create function udf_processlog( @mode int ) returns table as

return (

SELECT

case @mode When 2 then colb Else...