You can trust her pretty much 1000% on what she writes ;-).

Ray K (10/19/2011)

I thought about it, but I figured that it was already going on The Thread. No need...

Well #1 is easy

Select cust, sum() FROM group BY cust

From there you probably could do this :

CROSS <or outer> APPLY (SELECT TOP 1 via, anything else you need FROM...

Short answer is that they are not equivalent so you can't compare performance.

Long answer (series) => http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup

Apparently it's also too long to post the full question!

As someone real smart said => 😀

Be quick! before they run out of pants!

I was talking about Mario's script. 🙂

Here's a handy way to have stock on hand!

I can't believe this hasn't come up yet.

PANTS. 😀

Hey wait 1 sec.

The error says that the INSERT fails.

So maybe you can reset the quoted identifier setting and see if that fixes it.

Google doesn't give much usefull info besides...

Sounds like a bug in DBCC (or anything outside your control).

Unfortunately aside from upgrading or running this live I have nothing to offer.

Plan C might be to run a query...

Backup / restore to local/test server.

I'm sure that is alraedy coded somewhere to test the backups 😉

Easy way to figure it out :

Check the current avg space used in the page in sys.dm_db_index_physical_stats .

Then drop the fill factor below that figure by 5-10 points.

In my...

Can you run the code manually in QA (assuming this was in a job)?

Did the error message say in which object there was an error?

Anything more in the sql error...