Varun R | SQLINFO - We play with data and technology - Part 15

Author: Varun R

Varun is a Microsoft Certified IT Professional working as a Infra Architect in Fortune 100 company. He has written so many articles in his blog www.sqlinfo.in. He is a member in Professional Association for Sql Server (PASS).He holds around 10+ years of Experience in Database Design,Development , Business Intelligence & Administration. He has designed Data center for Fortune 100 companies. His area of skills lies in Data center design, Cloud computing, Business Intelligence etc.

Checking Isolation level in a Database

Recently I came across a situation to get detail...

19 Jul9 Nov

Varun R

Sql Server Keys Candidatekey,Primarykey,Foreignkey,self-referencing foreign key

One of my regular blog reader MrJithin requested...

7 Jul9 Nov

Varun R

Difference between Primary Key and Unique Key

So many people asked me this question; In many...

6 Jul9 Nov

Varun R

Difference between Union and Unionall

2 Jul9 Nov

Varun R

Difference between @@IDENTITY,SCOPE_IDENTITY() and IDENT_CURRENT

One of my friend and my colleague Mr Jithin asked...

30 Jun9 Nov

Varun R

Difference Between Varchar and Char in SQL Server

Difference Between Varchar and Char in SQL Server

25 Jun9 Nov

Varun R

Adding OR Removing IDENTITY To and From the Existing Column Using T-SQL

Recently while I am designing a Database, I came...

24 Jun9 Nov

Varun R

Extent Fragmentation High

I had come across a situation when one of my...

1 Jun9 Nov

Varun R