Viewing 15 posts - 17,551 through 17,565 (of 22,219 total)
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
Paul White (4/30/2009)
Tim,You should use the event SQL:StmtRecompile instead of SP:Recompile in 2005 and later.
See http://msdn.microsoft.com/en-us/library/ms179294.aspx
The SP:Recompile event is there to allow tracing of SQL2K instances.
Hm. Interesting. I didn't...
"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:29 pm
WayneS (4/30/2009)
Gail - can you give a good answer to this? I kinda thought along these line also.http://www.sqlservercentral.com/Forums/Topic707743-338-1.aspx
I think Gail nailed it. I sure hope so since I posted 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
April 30, 2009 at 4:55 pm
You're probably getting a statement recompile rather than a procedure recompile. If you capture the SP:Recompile event in a trace you can see, probably multiple, the event show up with...
"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 4:54 pm
I don't know where you're located, but I'd suggest also getting in touch with a local user's group, if any. Go to the Professional Association of SQL Server users 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
April 30, 2009 at 1:05 pm
From a strict, structural stand point, no it doesn't make any sense to break that data out in that fashion. Not unless you're breaking down all the address information so...
"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:22 am
There are absolute, demonstrable, performance issues when you don't schema qualify the tables, views, stored procedures & UDF's. You can get away with not doing it, yes, but you're paying...
"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:11 am
One of two ways you can go about that. First option, run server-side traces to capture events over time. You can set those up through Profiler. You can then aggregate...
"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 6:36 am
Viewing 15 posts - 17,551 through 17,565 (of 22,219 total)