Viewing 15 posts - 17,536 through 17,550 (of 22,202 total)
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...
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...
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...
May 1, 2009 at 6:40 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...
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...
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...
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...
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...
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...
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...
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...
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...
April 30, 2009 at 6:36 am
Using trace to capture execution plans can be an expensive operation so you need to be very judicious in it's application within a production system. That said, it really depends...
April 30, 2009 at 6:21 am
Compile time is a result of resources available and the complexity of the query. The more complex the query, the longer it will take. Also, if the query is in...
April 30, 2009 at 6:16 am
Viewing 15 posts - 17,536 through 17,550 (of 22,202 total)