Viewing 15 posts - 20,236 through 20,250 (of 22,224 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 5, 2008 at 5:29 am
You can call the agent from the command line. Put that behind an icon on their desktop.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 12:19 pm
When it comes to triggers... Absolutely!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 11:48 am
If you used a trigger wouldn't it have to be an "instead of" trigger?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 10:46 am
I'm pretty sure you can't.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 10:26 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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 8:21 am
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 8:20 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 8:18 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 4, 2008 at 7:39 am
Viewing 15 posts - 20,236 through 20,250 (of 22,224 total)