Viewing 15 posts - 15,076 through 15,090 (of 22,227 total)
OK. That was really weird. I think that was serious. Or if it was meant to be funny, it was really sad.
"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 10, 2010 at 6:44 am
And in 2005/2008, it's pretty easy to see the changes from the default trace. In Management Studio, right click on the server name, in Object Explorer, and select, Reports, Standard...
"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 10, 2010 at 6:43 am
I'd say a basic backup and recovery plan should cover you well. Schedule a full backup on a regular basis. Most of our db's are less than 100gb, so we...
"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 10, 2010 at 6:37 am
You'll get a much better response on new questions if you post them to the group at large. The only respondants you'll see here are those that are already subscribing...
"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 10, 2010 at 6:02 am
avanch-990710 (5/7/2010)
--Object reference not set 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
May 7, 2010 at 12:31 pm
There is no hard and fast formula as in "You MUST use it here, you MAY NOT use it there." It's a case by case basis.
However, one general rule 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
May 7, 2010 at 9:25 am
jacroberts (5/7/2010)
Grant Fritchey (5/7/2010)
"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 7, 2010 at 8:59 am
Nadrek (5/7/2010)
Are the backups sharing any of the same spindles (EMC Raidgroups) as 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
May 7, 2010 at 8:58 am
Carl B. (5/7/2010)
This morning we set the treshold to 25. Rigth after that, locking and performance problem arose. We waited but the situation did not tend to return 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
May 7, 2010 at 8:50 am
Jeff Moden (5/7/2010)
Grant Fritchey (5/7/2010)
"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 7, 2010 at 8:42 am
Bradley B (5/7/2010)
I was working with the Army on a FileNet project that had a SQL backend. All...
"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 7, 2010 at 7:22 am
Brandie Tarvin (5/7/2010)
On the other hand, the DELETE statements are kinda weird. I've never seen DELETEs phrased this way and I find myself thinking there...
"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 7, 2010 at 7:07 am
I agree this sounds like parameter sniffing.
As an experiment, you can create local variables within your procedure and then use them in the WHERE clause. You should see a...
"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 7, 2010 at 6:59 am
While waiting on the table defs, could you try this?
FROM T_IDYou.[dbo].[HST] h
LEFT JOIN srv1.T_id.dbo.MO s
ON h.refID=s.DistributorOrd
AND s.DistributorOrderNumber is null
"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 7, 2010 at 6:53 am
Two things, using views is fine, but if you starting joining views against views, you can completely overwhelm the ability of the optimizer to simplify your queries to only use...
"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 7, 2010 at 6:52 am
Viewing 15 posts - 15,076 through 15,090 (of 22,227 total)