Viewing 15 posts - 20,431 through 20,445 (of 22,224 total)
I still think it all comes down to a business verification. I can't tell you how many times I've gotten the word to restore the backup for a certain date....
"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
May 12, 2008 at 7:57 am
You should have Profiler. You can capture that.
You can also run Perfmon to capture the counters over time. Output them to a file and then you can use those with...
"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
May 12, 2008 at 7:54 am
There's always the documentation:
http://msdn2.microsoft.com/en-us/library/ms130214.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
May 12, 2008 at 6:44 am
It's called SQL Server Agent and it runs as a seperate service on all server installs (it's not in Express or Compact).
"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
May 12, 2008 at 6:42 am
Do these transactions include lots of data changes? You might be getting recompiles on your procedures. You'll need to follow Gail's advice and get the wait stats.
"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
May 12, 2008 at 6:41 am
And you will need to show execution plans so that bottlenecks can be identified.
"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
May 12, 2008 at 6:39 am
The wizard should work. You can also select all your procedures in the Object Explorer Detail window by first clicking on the Procedures folder in the Object Explorer window. 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
May 12, 2008 at 6:23 am
Can't you simply open another connection to the database and fire the procedure asynchronously? That way it won't be part of the main application's execution path.
"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
May 12, 2008 at 6:17 am
It's also worth pointing out that the ANSI 92 joins will cause problems in SQL Server 2005 and above when doing outer joins. From BOL: The outer join operators (*=...
"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
May 9, 2008 at 9:49 am
dfalso (5/9/2008)
"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
May 9, 2008 at 9:40 am
Jane Matheson (5/9/2008)
"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
May 9, 2008 at 7:31 am
22?
Oh lordy, I knew you were wet behind the ears, but I had no idea. I could be your father... Oh, yuck. No offense, just lamenting my lost youth.
Anyway,...
"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
May 9, 2008 at 5:56 am
Huh, I wonder why that's running slow. 😀
Sorry, that's not nice. Actually, except for the enormous set of columns in the GROUP BY, this isn't too bad a query based...
"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
May 9, 2008 at 5:43 am
Rollback the transaction before you insert into your audit table. Here's a sample using Adventureworks:
BEGIN TRY
BEGIN TRANSACTION
UPDATE [HumanResources].[Department]
SET [Name] = NULL
WHERE [Name] IS NOT NULL
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
INSERT INTO dbo.[AuditLog]...
"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
May 9, 2008 at 5:35 am
Just a quick follow-up. It looks like, based on the code you posted, that you're missing the concept of part of the UPDATE statement. You went inline on both your...
"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
May 9, 2008 at 5:30 am
Viewing 15 posts - 20,431 through 20,445 (of 22,224 total)