Blogs about: Sqlcommitted 2
Featured Blog
SQL Server– How to Encrypt Column Data
Encryption is one of the most secure way to protect your confidential data like Social Security Number, Date Of Birth , Patient clinical information etc. We need to encrypt certain data to meet the bu… more →
SQLcommitted
SQL Server– How to Encrypt Column Data
wrote 2 months ago: Encryption is one of the most secure way to protect your confidential data like Social Security Numb … more →
SQL Server – New Analytical functions in SQL Server 2012 - Lead and Lag
— 1 comment
wrote 4 months ago: LAG: Using this function we can fetch the nth row before (Lag) the Current row without using self-jo … more →
SQL Server – Happy New Year 2013 and Happy First Anniversary to My Blog
— 8 comments
wrote 4 months ago: Wish you a very Happy New Year 2013. Today is a special day for me to celebrate the New Year because … more →
SQL Server – Order of Column and Impact of equality operator on Index operation
— 1 comment
wrote 4 months ago: Does order of Column in where clause matters? Before you answer to this question I recommend all to … more →
SQL SERVER – Trace Flags
wrote 5 months ago: To know about a topic we usually ask questions. Here I used the same method to explain about trace f … more →
SQL Server – Customize Database object Script
wrote 6 months ago: SSMS provides functionality to generate script for database objects. I’ve seen developer use this fu … more →
SQL Server– Unique Constraint VS Unique Index
wrote 8 months ago: Both Unique constraint and Unique Index enforces uniqueness of the column. When we define an Unique … more →
SQL Server– Template Explorer
— 2 comments
wrote 9 months ago: Yesterday when I was about to leave office , I got a call on my mobile from one of my friend. He wan … more →
SQL Server - Join Algorithm
wrote 9 months ago: Today we’ll find how SQL Server works when we do join operation. SQL Server optimizer chooses one of … more →
SQL Server – Error handling using Throw
— 2 comments
wrote 9 months ago: MS-SQL Server 2012 introduced a new way of error handling using THROW statement. Prior to SQL Server … more →
SQL Server - ROWCOUNT_BIG
wrote 9 months ago: ROWCOUNT_BIG returns the number of rows affected by the last statement executed. Syntax: ROWCOUNT_BI … more →
SQL Server - Non-clustered index seek is better than Clustered index seek
— 4 comments
wrote 10 months ago: I was working on removing duplicate indexes from a table. Before removing an index usually I check w … more →
SQL SERVER - OBJECTPROPERTY
wrote 11 months ago: I see many developers open tables in design mode to find whether a tables has an identity column or … more →
