Viewing 15 posts - 13,936 through 13,950 (of 22,219 total)
GilaMonster (11/14/2010)
Grant Fritchey (11/14/2010)
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?I might go.
Might go? Aren't you presenting there?
And that's why I might go.
"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 14, 2010 at 8:58 am
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?
I might go.
"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 14, 2010 at 8:39 am
Man, last week was a thrill ride. I too got to meet several of the regulars, although I didn't see nearly enough of Jeff. Sorry about that one. Johann even...
"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 14, 2010 at 6:25 am
Get Itzik Ben-Gan's book: T-SQL Fundamentals
"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 12, 2010 at 4:39 pm
We've had to build a system that does something like this. What we did was add a table that maintains versions. Then we had a master table, think of it...
"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 12, 2010 at 4:10 pm
GilaMonster (11/11/2010)
jcrawf02 (11/11/2010)
Craig Farrell (11/10/2010)
Must be the week...http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy spool 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
November 11, 2010 at 8:21 am
In SQL Server 2008, yes. You can call DBCC FREEPROCACHE(plan_handle). You just have to get the appropriate plan handle out of the procedure cache.
"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 8, 2010 at 3:20 pm
Let me put a question back at you. Since most of the topics you outline have extensive documentation, courseware, books, etc., how do you propose getting developers to that information?...
"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 8, 2010 at 11:36 am
You might take a look at the RML Utilties from Microsoft. They can help you interpret the information from a trace.
"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 8, 2010 at 11:20 am
It's not necessarily a problem. It's just another indicator. I'd see if you have other indications of performance problems, excessive waits or queues, long running queries, that sort of thing....
"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 8, 2010 at 11:17 am
I agree with Gus, I suspect parameter sniffing, although with something this complicated... it's hard to be sure. Get the execution plan for the procedure and the query and see...
"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 5, 2010 at 1:38 pm
Yes, absolutely. Assuming the default trace hasn't been overwritten, that's exactly the type of information it captures.
"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 5, 2010 at 1:35 pm
We're actually going through the process of evaluating both right now. However, we're going with SharePoint, so the question is Reporting Services or Cognos, integrated through SharePoint, not simply Cognos...
"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 5, 2010 at 12:21 pm
For those interested, the book on development will be released here[/url].
"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 5, 2010 at 8:05 am
Yeah, this is where it will be[/url] when they post it.
"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 5, 2010 at 8:04 am
Viewing 15 posts - 13,936 through 13,950 (of 22,219 total)