Viewing 15 posts - 10,711 through 10,725 (of 22,219 total)
Version 7 of SQL Backup does have VERIFY ONLY as part of the GUI, just so you know.
But, as was already pointed out, you can script the whole thing and...
"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 21, 2012 at 7:29 am
patrickmcginnis59 (6/21/2012)
Grant Fritchey (6/21/2012)
“By now, you might be able to see where I’m going in this section....
"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 21, 2012 at 6:47 am
Queries to return a single record should be able to be tuned to a fare-thee-well. It just depends on the parameters being passed in and how well you can apply...
"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 21, 2012 at 6:26 am
Have to make the comment, this is a classic example of using data types appropriately. If it's a number, store it as a number and refer to it as 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
June 21, 2012 at 6:19 am
Just received an interesting comment on this over on my blog that included this:
“By now, you might be able to see where I’m going in this section. I have made...
"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 21, 2012 at 4:13 am
L' Eomot Inversé (6/20/2012)
But I may not find...
"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 21, 2012 at 3:53 am
shahgols (6/20/2012)
Msg 536, Level 16, State 5, Line 1
Invalid length parameter passed to the SUBSTRING function.
I "fixed" it by adding 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
June 20, 2012 at 10:36 am
shahgols (6/20/2012)
Most excellent, thank you very much!BTW, when is your SS 2012 Performance Tuning book coming out?
Just got released today.
"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 20, 2012 at 10:34 am
Procedure cache comes & goes to a degree. Sounds like you're fine. Personally, I'd turn on the ad hoc optimization. It doesn't hurt anything, but it can help a little.
"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 20, 2012 at 8:18 am
Every query goes into the cache. Not just stored procedures or prepared queries (parameterized queries). All the ad hoc ones go there too (except when you've enabled 'Optimize for Ad...
"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 20, 2012 at 6:35 am
I just see this self-referencing foreign key
ALTER TABLE [dbo].[AT] WITH CHECK ADD CONSTRAINT [FK_AT_AT] FOREIGN KEY([AT_id])
REFERENCES [dbo].[AT] ([AT_id])
It joins the same table to itself.
"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 20, 2012 at 4:44 am
You can pull stuff straight out of the cache using dynamic management objects (DMO). The main couple that you're going to be interested in are sys.dm_exec_query_stats and sys.dm_exec_sql_text. Here's 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
June 20, 2012 at 4:39 am
matthew.peters (6/19/2012)
Thanks for the solutions, they're all great ideas, I'm looking to change the query structure first and see how that goes.
two questions
...
"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 20, 2012 at 4:15 am
mvillegascuellar (6/19/2012)
Thanks guys for the quick response.These are queries not stored procedures.
Second I would like to capture both table hints and query hints.
Even with queries, they're stored in cache. You'll...
"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 19, 2012 at 7:13 pm
Nothing wrong with Olla scripts at all. I do thing Michelle Ufford's are also worth a look[/url]. They're simpler and easier to deal with I think.
You might also want 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
June 19, 2012 at 3:44 pm
Viewing 15 posts - 10,711 through 10,725 (of 22,219 total)