Forum Replies Created
Viewing 15 posts - 14,206 through 14,220 (of 22,227 total)
-
RE: Index tuning advisor errors. cannot find stored procedure
I'm still of the opinion that you are either not connecting to the correct database, or your security doesn't allow you to see those procs. It's also possible that they're...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Chad Crawford (10/4/2010)
Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?Doesn't really matter does it?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: GUID clustered indexes vs. RID
Rob Schripsema (10/4/2010)
(Just posted a similar comment on Glen Berry's blog at http://www.sqlservercentral.com/blogs/glennberry/archive/2010/3/22/why-uniqueidentifier-is-a-bad-choice-for-a-clustered-index-in-sql-server.aspx. This is not meant as a double post, just not sure if responses to older blog articles..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Performance monitoring strategies?
Until you get into the third party tools (my favorites, in no particular order, are Red Gate SQL Response, Confio Ignite, Idera Diagnostic Manager), then I'd suggest a combination of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Most costly queries
You might be looking for the DMO sys.dm_exec_query_stats. It contains an aggregation of the performance of the queries currently in cache. You can also look at sys.dm_exec_proc_stats in 2008.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Optimization best practices
I'm assuming you're not talking about disaster recovery (DR)?
Just for tuning performance, first thing I'd do is set up data collection to get a good set of metrics from performance...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Women and Men - Same or Different?
Matt Miller (#4) (10/4/2010)
Steve Jones - Editor (10/4/2010)
david_wendelken (10/4/2010)
...So, rather than piss and moan about not getting equal pay for equal work, why not learn what career and job negotiating...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Performance testing and tuning for a beginner
sql_er (10/4/2010)
I think some of this was mentioned to some extent in the replies, but here are my two cents:1. Subtree cost: Not sure how often people use this, but...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Jeff Moden (10/4/2010)
Dave Ballantyne (10/4/2010)
Still cant believe that my name is sitting on the same agenda as all these MVPS , MCM's (yes plural , the universe doesnt collapse if..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Jeff Moden (10/4/2010)
Dave Ballantyne (10/3/2010)
Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Women and Men - Same or Different?
Hey Wendy! Excellent editorial. 110% agreement. You really couldn't have put it any better.
BTW, regarding boys & girls & toys, I have twins, one boy, one girl, our intention was...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Altering table doesn't refresh view
It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are referenced. On...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: lock on select
Tim Parker (10/1/2010)
The senior DBA that I work with gave me that idea. So I cheated a bit... 😀No, no, no. We don't call it cheating. We call...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 14,206 through 14,220 (of 22,227 total)