we all knew Maximum size of an index key is limited to 900 bytes..But with SQlServer 2016,this limit has been removed.. [Read More]

This error occured for me when trying to establish a connection to SQLServer immediately, after SQL restart [Read More]

I have finally installed SQLServer on linux..It was good exeperience.Thanks to Microsoft for good documentation.. [Read More]

What happens when you press a key on keyboard..? How they add numbers....... [Read More]

I did a quick search to know what are the differences,but i am unable to find any…So thought of posting this Traceflag 1204 was introduced in SQLServer 2000 and it outputs deadlock info to SQLServer error log in text format.. Below is a sample of Traceflag 1204from my instance..(stripped node... [Read More]