Heh... Nope.  It's almost 13 years old and I wasn't the one that necro'd it. 😀  I congratulated the person that posted yesterday and asked a simple question.

I've found it to be much more fun and useful to pork chop anyone that sends me data in XML format. 😀

Do you teach people how to count in the book?

My sweetie and I keep the house at a balmy 68 degrees F (20 C) all winter long.  I found that letting the house cool down while were not home...

Let's hope that, after nearly 13 years, the OP is still interested. 🙂

Looks like your book is getting some good reviews, Kriti.  Congratulations.

Thank you for the feedback, Christi.

Just a quick venting/raging......Entity frameworks using code first is the spawn of the devil himself. It is seriously one of the worst anti-patterns I have ever seen....

I thought the question was just fine because what the system runs has no actuals in it and so that inherently makes it "estimated" even if SSMS didn't exist at...

Can you use FORMAT? I have only ever used it in ad-hoc queries to make numbers easier to read, and I can't vouch for its performance, but it seems...

It's a prelude to spam.  Go look at the profile of the op.  They do this kind of crap to "reserve a spot" and then they come back after the...

Still can't get pass this error:

Type conversion in expression (CONVERT(int,[d2].[attValue],0)) may affect "CardinalityEstimate" in query plan choice, The query memory grant detected "ExcessiveGrant", which may impact the reliability. Grant...

You've logged in exactly twice and you "love this group".  I might be missing something but that sounds like an old prelude to SPAM.

Multiple CROSS APPLYs do add a tiny bit of overhead and, in this case, a fair bit of complexity.  We can simplify Thom's good code a bit by cascading the...

I found the offending query when I look at the Query Plan.

Type conversion in expression (CONVERT_IMPLICIT(int,[d2].[attValue],0)) may affect "CardinalityEstimate" in query plan choice.

How do I go about fixing..

THanks.

            
March 8, 2022 at 3:51 am
            
#3995423

            
            
                                                
        

Now - with all that said, loading 120K rows shouldn't take more than a couple of minutes at most. The fact that it already takes several hours I would...