Thanks guys. I realize it's kind of an obscure topic, but I had such a hard time tracking down the individual pieces of information that I felt compelled to share...

That's a report definition file, a part of Reporting Services used by the Management Studio to show the data. It shouldn't be something you have to create.

That's actually what the report is doing. I watched it through Profiler.

You can add a nullable column to a table using alter table. It won't affect the rest of the table at all.

NO CHECK is functionality around check constraints. If you...

Cool! I'm glad to hear something worked. Thanks for the feedback.

Not a problem. Just alias the table. Self-join or not, you're looking at the equivalent of a cursor.

Yeah, I actually posted some comments about that issue at your other post.

Not seeing the code or the execution plan, it's hard to say, but it could be parameter sniffing...

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.