This is the list of the all the articles in the series of computed column.
SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example
In one of the recent consultancy, I was asked if I can give working example of BINARY_CHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows.…
Read More
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.
SQL SERVER – Find Queries using Parallelism from Cached Plan
I recently came across wonderful blog post of Feodor Georgiev. He is one fine developer and like to dwell in the subject of performance tuning and query optimizations. He is one real genius and original blogger. Recently I came across his wonderful script, which I was in fact writing myself…
Read MoreSQL SERVER – Identifying Statistics Used by Query
“Can I know which statistics were used by my query?” Recently, someone asked this question in my training class of query optimization and performance tuning. I really liked the question. The answer for me is very simple. “No.” Well, if I stop here suggesting only “No,” it will be an…
Read More