When it comes to triggers... Absolutely!

If you used a trigger wouldn't it have to be an "instead of" trigger?

I'm pretty sure you can't.

You don't want my help. Here's a short[/url] account of all the problems we ran into attempting to virtualize some of our servers.

BTW, running the functions against the columns means you're only going to get table scans. The indexes will not be used.

Get an estimated execution plan for the query. It won't be terribly accurate, but it should give you some information as to why you're seeing things run so incredibly slow.

Seems like overkill.

Generally we approach it this way:

"Here are the top 10 poor performing procedures for database x"

"We have evaluated these procedures and identified possible fixes"

"Performance before the fix looked...

It sounds like you're not exactly working from a good set of SOA standards. By and large, in most cases, you should have one system defined as the absolute authority...

In 2005 use ordered GUID's. They make a huge difference in performance, especially if you have clustered indexes on the GUID. In 2000, you'll have to just deal with the...

Any time you're asked to tune a performance problem but told you can't touch the code (unless it's a third party app), you need to push back. More often than...

How many rows are in the table? I ran into a similar issue and posted it on Microsoft Connect because I thought I had a bug. It has to do...

We have similar problems. We've used two steps to resolve it. First, identify absolute owners of all the data you possibly can. The primary keys generated by those owning systems...

One way that comes to mind is to have a tinyint column that you increment manually as you insert data. Put two constraints on the column, one to make it...

There's a dependency in there somewhere. Why not get a copy of Red Gate's Dependency Checker (or whatever it's called) and run it against the database. It's VERY thorough and...

Sweet. Thanks for posting that Jeff.