Viewing 15 posts - 17,701 through 17,715 (of 22,202 total)
Here's a video on exactly how to capture the execution plans & post them to SSC.
April 15, 2009 at 6:06 am
If I were doing that particular insert, I'd use the OUTPUT clause as part of a single transaction. That will allow you to insert into the BusinessEntity table and any...
April 15, 2009 at 6:01 am
Do you see an error? Is the process waiting for a long time? Disconnected?
A little more information would sure be helpful.
April 15, 2009 at 5:55 am
If the two queries are basically identical, then I suspect it's parameter sniffing (you can look that up). First, make sure that the queries are identical (I know you said...
April 15, 2009 at 5:53 am
There are basically three ways you can do it; MAX, TOP, and ROW_NUMBER. They all work. They all don't work equally well. I wrote an article, with code examples, comparing...
April 15, 2009 at 5:45 am
GilaMonster (4/15/2009)
April 15, 2009 at 5:29 am
vrabhadram (4/14/2009)
Is sqlserver sql is ansi standard or ascii standard
Yes.
SQL Server is compliant with most of the ANSI standard for SQL.
SQL Server supports and works with ASCI text.
This just...
April 15, 2009 at 5:28 am
No worries. Try the stuff Lynn is suggesting. He's looking over the queries. I just glanced at them. I'm interested in how the execution plans vary.
April 14, 2009 at 7:06 pm
OK. That's very complete.
Get the execution plans. Especially the one where the 2005 ran well, but the others too. That way we can tell what's happening between the two servers.
April 14, 2009 at 4:34 pm
Yeah, I thought I clicked on the PM button on a message of Gail's but I guess not. Poor Lynn. Time for me to go home. I have to run...
April 14, 2009 at 1:32 pm
Nah, you teasing us with the "mind boggling" thing. Not fair 'tall.
April 14, 2009 at 1:24 pm
Processes normally block and lock resources as they work. If you're hitting excessive blocking & locking than you should address the code and the structure, not using query & table...
April 14, 2009 at 11:46 am
I don't know anything about iBase either. I went and read through their literature. I suspect you would have a great deal of trouble using the iBase database as is...
April 14, 2009 at 11:43 am
It's not the same query if you've changed the code.
However, yes, with the same code, same data, same statistics distribution (you won't get the same statistics) you could get different...
April 14, 2009 at 11:31 am
Is it a table valued UDF or inline scalar? If it's table valued, that might the core issue righ there. And no, that's not unique to 2005.
Even if it's inline,...
April 14, 2009 at 8:56 am
Viewing 15 posts - 17,701 through 17,715 (of 22,202 total)