Viewing 15 posts - 17,551 through 17,565 (of 22,226 total)
You might be able to get that by using a trace and capturing the cache miss event and then pairing that with the sp or rpc starting events to 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
May 4, 2009 at 12:40 pm
There's nothing that will automatically suggest an indexed view. They really depend on what you're doing with the data. There isn't a set formula for their use, although there are...
"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 4, 2009 at 12:32 pm
The Inside SQL Server series, specifically the book on performance tuning could help you. I'd like to recommend my book as well, in the link below.
"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 4, 2009 at 12:28 pm
Just to pile on a bit & reinforce what everone else said, when possible, avoid table valued functions like the plague. They are serious performance killers because SQL Server cannot...
"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 4, 2009 at 12:27 pm
Bob Hovious (5/4/2009)
Warren Zevon was a singer/songwriter who died a few years ago. One of his greatest hits was a song called "Werewolves of London", which I...
"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 4, 2009 at 12:09 pm
You also performed a service linking to Connect. Hopefully this'll get some more votes.
"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 4, 2009 at 8:47 am
Great article Roy. Well written and informative.
I was kind of hoping you had a fix to the problem with removing TDE though. 😀
"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 4, 2009 at 8:37 am
Florian Reischl (5/3/2009)
I HATE EXCEL!! I'm about to finish my first article and want...
"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 4, 2009 at 6:13 am
Dave Smith (5/1/2009)
"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 4, 2009 at 6:12 am
Lynn Pettis (5/1/2009)
So, denizens of The Thread, when do you think we'll hit 4,000 posts?
You never know, but it just takes the right question or comment to spawn about six...
"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 1, 2009 at 11:35 am
We have the same issue from Cognos. There's also a sp_prepare statement running before those queries that you're seeing. That's what sets the value for those integers you're seeing. Look...
"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 1, 2009 at 7:01 am
Well, another problem that most people don't notice is that they change the bloody thing, regularly, and don't tell you that they did it. I've been using 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
May 1, 2009 at 6:40 am
Well, do you mean having a particular user or set of users run this stored procedure? You can DENY execute privileges to the role or user.
DENY EXECUTION ON schema.proc 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 1, 2009 at 6:36 am
I'm on board with questioning the ability of the person who said it's in the plan to drop the schema definition. We've been able to set developers up to create...
"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 1, 2009 at 6:00 am
The question bugging me is, how the heck did you know that? There are so many changes between 2000/2005 and then on top of it to 2008. I catch 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
April 30, 2009 at 7:51 pm
Viewing 15 posts - 17,551 through 17,565 (of 22,226 total)