Viewing 15 posts - 20,206 through 20,220 (of 22,197 total)
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...
June 5, 2008 at 6:45 am
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
June 5, 2008 at 6:39 am
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...
June 5, 2008 at 6:38 am
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...
June 5, 2008 at 6:35 am
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...
June 5, 2008 at 6:29 am
radu.poenaru (6/5/2008)
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...
June 5, 2008 at 6:22 am
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...
June 5, 2008 at 6:16 am
Thanks for the response Tanya. Like I say, I may whine a bit now & then, but I'm seriously addicted to your product.
June 5, 2008 at 6:04 am
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...
June 5, 2008 at 5:29 am
You can call the agent from the command line. Put that behind an icon on their desktop.
June 4, 2008 at 12:19 pm
If you used a trigger wouldn't it have to be an "instead of" trigger?
June 4, 2008 at 10:46 am
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.
June 4, 2008 at 9:21 am
BTW, running the functions against the columns means you're only going to get table scans. The indexes will not be used.
June 4, 2008 at 8:21 am
Viewing 15 posts - 20,206 through 20,220 (of 22,197 total)