What is SPARSE Column in MS SQL SERVER?
Introduced in SQL Server 2008, The SPARSE column is better at managing database size when null values are plenty in that…
0 Comments
November 2, 2016
How to convert XML to JSON in MS SQL SERVER
JSON is a data-interchange format that is both Human and Machine readable. It is easy for developers to interpret and pinpoint…
October 5, 2016
How to get record count of large or locked tables in MS SQL?
Ever wondered why it takes so much time to get the count of rows in an SQL table with millions of…
October 4, 2016
How to optimize T-SQL Query in MS SQL Server
As an T-SQL Developer, we always tend to wonder why my query takes considerately more time when everything is set on…
October 3, 2016
How to send database emails using sendgrid SMTP T-Sql
Now this is tricky and pretty impulsive when you try to send emails from database using SendGrid and the mail fails…
October 2, 2016
How to generate connection string when SQL management studio is not installed
One common issue generally every developer faces in his initial days of development is how to generate connection string that connects…
October 1, 2016
When to use Temp Table, Table Variable and CTE.
As a layman or a novice, when we come across the concept of local temporary tables, global temporary tables, table variables…
October 1, 2016