I just came across very simple error and the solution was even simpler. While concatenating NEWID to another varchar string, I had to CONVERT/CAST it to VARCHAR and I accidentally put length of VARCHAR to 10 instead of 36. It displayed following error.
Msg 8170, Level 16, State 2, Line 1
Insufficient result space to convert uniqueidentifier value to char.
Today I will be speaking on the subject of Spatial Database at Community Tech Days at Ahmedabad. The event is absolutely FREE. We have so far received 500+ RSVP but there are only limited 250 seats are available. We are doing our best to inform everybody about their registration status. If you have received confirmation email, I suggest that you come in early enough to reserve the place.
I am including a few of the interesting quotes today. Let us see Funny Technology Quotes. Here are few interesting new lessons.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
