Don't use an Instead Of trigger for this. It will block legitimate inserts and updates, unless you code around them. Much easier to do in an After/For trigger.

CREATE...

I just did this test:

create table #T (

C1 int,

C2 int,

C3 int,

X1 int,

X2 int)

create index IDX_T_1 on...

Do you have access to the execution plans from 2000? If so, comparing the two plans would be the best place to start.

It can be worked with, but a plan saved as a plan gives a lot more information and is quite...

It should be easy enough to build something yourself in Reporting Services/Notification Services.

If not, RedGate has a beta product called SQL Response that might fit your need. Check it...

Looks to me like you're getting 110 deadlocks per second. That's quite a few.

There isn't one. Not native anyway. Exchange can connect to SQL Server and feed stuff in there (or so I understand, haven't actually used that). I read...

I've been using Vista since beta, and I guess I'm a serious minority, but I really like it.

The first machine I used it on was significantly more than "3 years...

The closest I get to physical fitness these days is walking my dogs 3-4 times per day. Between a bum knee, arthritic hips, heel spurs, a neck injury (caused...

I spotted the implicit conversion and was about to go into the details on it, but then realized Simon had already covered it.

Good question. Understanding implicit conversions is a...

The "replace Nth character" doesn't actually catch the Nth instance of a particular character, it just replaces the Nth character.

Try it on "Susy sells sea shells by the sea shore.",...

I haven't used the Red Gate Compare tool, but the ApexSQL Diff product is quite good for comparing structure, code and data between databases. I find it extremely helpful...

If I'm not mistaken, Standard requires a server OS, not a desktop OS, just like Enterprise.

On XP, you can only install Express or Dev editions, to my knowledge. Might...

Probably the first one, but it's hard to tell, because A1 isn't included in any of them, so it's going to have to at least do a bookmark lookup. ...

I've seen an ad for a tool that would go through .NET code and document dependencies, but I seriously doubt there's anything that can go through your whole system and...