First, based on what you said, don't use table variables. Performance will likely degrade.

Second... It really depends on what's going on here, but in general, views serve two purposes. They...

I love that article from MS on tuning using WAIT states. It's great.

Here's a simple article that might help.

http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/%5B/url%5D

There's "used" and there's "used"

Do the indexes get scanned or is there a seek operation against them? If scanned, how many rows are reported as being scanned?

Also, the code snippet...

Assuming the system hasn't been rebooted, yes. Right click the database and you can run a report called "Schema Changes History." It'll tell you everything done to the database in...

Not knowing the business needs, it looks like what you're doing is correct. Having a calculation or CASE statement in the SELECT criteria is not a bad thing. The only...

radu.poenaru (6/5/2008)

---

Ouch, good spotting!

I've this was a compilation from the creation script of the DB. It seems the table is initially created w/ a clustered PK , then that index...

Do you normally run the query against the view with no WHERE clause? Because it's returning everything, you're getting nothing but table and index scans. It's rather difficult to drill...

Thanks for the response Tanya. Like I say, I may whine a bit now & then, but I'm seriously addicted to your product.

Does this script really run? It defines the primary key twice. Once as a clustered index and once as a non-clustered index. If you're able to run this, you might...

You can call the agent from the command line. Put that behind an icon on their desktop.

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.