I also selected 0 for this answer. None of the statements returned any data. They actual execution plan confirms this.

Cheers,

Andre Ranieri

Great question Lokesh. It's helped me bone up on my SQL 2012 skill set.

Cheers,

Andre Ranieri

+1 🙁

Happy belated Thanksgiving. STUFF() is an understatement.

You're right, this is not an issue with banker's rounding or 3.45 would have rounded even to 3.4

Andre

Cool question, this makes me want to get my hands on a SQL 2012 server 🙂

Nice question. I learned something new about T-SQL today. Thanks!

Andre Ranieri

Great back to the basics question, it's always good to keep the foundations of SQL sharp in my mind.

Thanks,

Andre Ranieri

Great write Erin! I capture wait stats hourly so I can see a delta between two given points in time. This has been helpful for troubleshooting and...

Great question, thanks!

Can you imagine the blocking issues if every other insert trans to that table had to wait to see if the IDENTITY seed was going to be reset?...

Good reminder, thanks !!

The wording of the question was "how many rows are returned from the SELECT statements" . . . I maintain that 2,0 is the correct answer since it's the INSERT...

I run CHECKDB on the restored backup to make sure that, not only is the prod database healthy but also the backup and restore process doesn't create corruption.

I have a...

Thanks, I'm adding the schema name (dbo) and will get back to you with results.

I'm starting to think this is an execution plan issue such as parameter sniffing.

As a beset...

Here's the connection string used globally by all CRM users:

Application Name=*****;Data Source=******;integrated security=SSPI;Database=******;Connection Timeout=0