Viewing 15 posts - 9,346 through 9,360 (of 22,224 total)
You're basically running into limitations of the generic nature of Maintenance Plans. If they work for you, great. If they don't, the only real recourse you have is to start...
"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
December 2, 2013 at 10:41 am
Yeah, the text is part of the issue and forced parameterization could help some. But it's use is pretty limited. Again, I'd turn it on to see if it can...
"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
December 2, 2013 at 4:35 am
Plus the fact that no unique constraints radically changes the optimizers choices for retrieving data. I'll bet you see a LOT more scans than you should since the optimizer has...
"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
December 2, 2013 at 4:10 am
Three suggestions.
Most of what you're going for from that basic list are either system variables (@@servername, @@version, etc.) or can be accessed from the sp_configure query. So yeah, getting 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
December 2, 2013 at 4:06 am
This introduces the concept of the a partial backup. As everyone has already stated, you can only do this if you design the database and it's structure to support 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
December 2, 2013 at 3:59 am
I'm going to follow on what the others have said. You first have to demonstrate that you have the core knowledge of SQL Server before I start asking you other...
"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
December 2, 2013 at 3:51 am
Forced Parameterization has a very limited set of cases where it will be applied. It's only slightly more likely to be used by the optimizer than simple parameterization. Check 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
December 2, 2013 at 3:47 am
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk to him...
"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
November 22, 2013 at 7:54 am
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
No one is aware...
"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
November 18, 2013 at 11:27 am
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...
No one is aware of anything like 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
November 18, 2013 at 9:30 am
You're also missing some JOIN criteria here:
LEFT OUTER JOIN SALES_TAX RIGHT OUTER JOIN
"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
November 16, 2013 at 7:16 am
You can trace each statement within the procedure by using Extended Events. You can set up to capture each statement start and end. That will give you precise information on...
"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
November 16, 2013 at 7:14 am
mstanl (11/15/2013)
Thank you very much for the reply Tom,And yes Grant this is the same person that talked to you in Dallas SQL Saturday.
Mike
HA!
I'd say I recognized your question, but...
"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
November 15, 2013 at 2:25 pm
RBarryYoung (11/15/2013)
SQLRNNR (11/15/2013)
Barry, where have you been?Mostly just working. I answer questions over at StackOverflow sometimes, but that's about it.
StackOverflow? Traitor!
Ha!
Good to see around, even if only virtually.
"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
November 15, 2013 at 2:21 pm
Functionally, it's no big deal. A little bit of a pain having to maintain two unique indexes, one for the PK and one for AK, but I've worked with such...
"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
November 15, 2013 at 10:45 am
Viewing 15 posts - 9,346 through 9,360 (of 22,224 total)