Let us learn today about Negative Identity Seed Value and Negative Increment Interval. I have also included a video in this blog post.
SQL SERVER – Computed Column – PERSISTED and Performance
This is the list of the all the articles in the series of computed column.
SQLAuthority News – T-SQL Challenges and Hints and Suggestions
Those who read my blog are for sure know my very good friend Jacob Sebastian. He is SQL Server MVP and founder of wonderful site T-SQL Challenges. No matter how expert we are, challenges are made to make us think and try to go to next level. There are certain people who writes always challenging code, however there are many who are yet not expert but the passion of T-SQL is on them. Jacob has many wonderful ideas and T-SQL challenge is his contribution to community, where he helps community to think, help them to mentor and help them to become one better coder.
SQL Tips – 5 SQL Server Best Practices
In this blog post we will see 5 SQL Server Best Practices.
Backup Master. I am going to have a backup of the database using script; however, the backup script has not been updated for a long time now.
SQL SERVER – Check Advanced Server Configuration
I was recently asked following question about how to Check Advanced Server Configuration.
SQL SERVER – Computed Column – PERSISTED and Storage
This is the list of the all the articles in the series of computed column.
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char
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.