Viewing 15 posts - 19,921 through 19,935 (of 22,220 total)
I'd be more interesting in seeing the execution plan from the query.
"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
July 22, 2008 at 6:23 am
Thanks. Great description of automatic statistic maintenance, although it's for SQL Server 2000. Here's the BOL entry for 2005. There are a few differences, but nothing major.
I guess I wasn'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
July 22, 2008 at 6:19 am
Start here:
http://msdn.microsoft.com/en-us/library/ms191007.aspx
Move on to here:
http://msdn.microsoft.com/en-us/library/ms177499.aspx
"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
July 22, 2008 at 6:00 am
You've got two options. Set up TRY/CATCH and then return the error message that you want the user to see:
BEGIN TRY
RAISERROR('Major error in TRY...
"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
July 22, 2008 at 5:57 am
And possibly introduced others.
You do know that NOLOCK can cause duplicate data to be displayed, not just data that's in flux? I think that after FAST 1, NOLOCK is...
"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
July 22, 2008 at 5:53 am
Maybe I'm dense (ok, I am, but humor me), but if you're the one creating the temporary tables, don't you know the column names already?
"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
July 22, 2008 at 5:49 am
Since you are new to this, please take a piece of advice.
Don't use dynamic SQL.
Especially since you're just getting started. Do the work to figure out how to...
"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
July 22, 2008 at 5:47 am
The best thing you can do is set up regular monitoring of your data. You can get third party tools like Idera's Diagnostic Manager or the new one from SQL...
"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
July 22, 2008 at 5:37 am
GilaMonster (7/22/2008)
Grant Fritchey
You can also need to update statistics on smaller tables where large percentages of the data changes regularly.Wouln't the auto update take care of that?
I've found that...
"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
July 22, 2008 at 5:32 am
Your previous post scared me. I wasn't entirely kidding about sticking a fork in myself as a comarison. Using CLR is of questionable benefit in most situations. This one is...
"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
July 22, 2008 at 5:27 am
So what do I do with these pork chops? Sharpen the bones & throw 'em like a boomarang?
"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
July 22, 2008 at 5:24 am
Replaying Trace does work. It's a bit of a pain to set up, but it does work. However, a Trace is dependent on you already having a database and application...
"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
July 21, 2008 at 12:15 pm
I liked "DBAs of Dawn" better.
"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
July 21, 2008 at 12:00 pm
I've done a ton of testing of SQL Server 2000 and 2005. I've never tried load testing replication before, so I'm not sure of anything that would help you there.
The...
"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
July 21, 2008 at 10:26 am
It's not normal for a single procedure to take all the resources, no. But if the query is really poorly written or designed, it certainly could happen.
I'd make sure you...
"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
July 21, 2008 at 8:07 am
Viewing 15 posts - 19,921 through 19,935 (of 22,220 total)