Viewing 15 posts - 20,101 through 20,115 (of 22,202 total)
No, it's not the same at all. 2005 really is better.
June 19, 2008 at 7:00 am
Pull up the execution plan. That will help you find out where to look.
I suspect it's this:
(D.Did in (select max(Did) from D group by Aid) ...
June 19, 2008 at 6:51 am
I can't find the documentation. Here's a support article, but it's not what I meant:
http://support.microsoft.com/kb/281671
And Kalen
http://www.sqlmag.com/Article/ArticleID/16078/sql_server_16078.html
June 19, 2008 at 6:47 am
Mike Levan (6/18/2008)
Exactly.Can you pls update my proc with your best performance ideas.
Actually, quite a few of us get paid to rewrite 500 line stored procedures. We'll help, but you...
June 19, 2008 at 6:35 am
First, I'd try posting in the SQL Server 2000 forums, not the 2005 forum.
Second, there isn't an immediate method to do this. There are some options. If you're running a...
June 19, 2008 at 6:21 am
I agree with Matt. There are some fantastic articles right here that will move you along. As for books, Wrox has a decent one called Professional SSIS. The one our...
June 19, 2008 at 6:09 am
It really does sound like recompiles either from causes within the code or due to changes in the data. Especially since it seemed to happen over time and somewhat randomly,...
June 19, 2008 at 6:02 am
I wish I had a contact or three at MS. I'd love to see this moved up the chain... I'm going to try contacting a couple of people.
June 19, 2008 at 5:52 am
While GUID's can be a unique value, you didn't put a unique constraint on the key, so when combined with the other part of your where clause, you're probably getting...
June 18, 2008 at 10:06 am
It sounds like Steve nailed it in one.
We had a similar issue, waits for compiles, which lead to other waits for compiles, etc.
Our code was actually compiling due to changes...
June 18, 2008 at 10:03 am
Ummmm. That was strange. Where the heck did the execution plan go?
If I run this query, I can see it.
SELECT
p.*,
q.*,
...
June 18, 2008 at 9:33 am
A log file is a mechanism I'd only use from the application side. If you're capturing error information inside SQL Server, just write it out to a table.
June 18, 2008 at 9:21 am
The optimizer, along with a whole of the rest of the engine, was changed between 2000 and 2005. It's not at all surprising that you'll see different execution plans in...
June 18, 2008 at 8:48 am
There's not a good source for this information. Experimentation is how I'm getting by.
I can recommend three sources that can help, in addition to posting here (althouth only a...
June 18, 2008 at 8:16 am
Viewing 15 posts - 20,101 through 20,115 (of 22,202 total)