Kapil Singh

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported

by Kapil Singh

Kapil Blogs

Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...

2016-02-03

1,388 reads

Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported

by Kapil Singh

Kapil Blogs

Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...

2016-02-01

542 reads

SQL Server – Check the status of active Trace Flags

by Kapil Singh

Kapil Blogs

Hi friends, few days back I was exploring data masking features introduced in SQL Server 2016. I got stuck in...

2015-12-14

551 reads

SQL Server – Trace flag changes in Dynamic data masking in SQL Server 2016 CTP 3.0

by Kapil Singh

Kapil Blogs

Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...

2015-12-10

482 reads

SQL SERVER – Random function in Dynamic Data Masking in SQL Server 2016 CTP 3

by Kapil Singh

Kapil Blogs

Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...

2015-12-08

578 reads

SQL Server – DROP IF EXISTS in SQL Server 2016

by Kapil Singh

Kapil Blogs

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets...

2015-11-27

1,132 reads

Steps to create SQL database at Azure

by Kapil Singh

Kapil Blogs

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into...

2015-11-26

875 reads

Steps to install SQL Server CTP 3 on Windows Azure

by Kapil Singh

Kapil Blogs

Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...

2015-11-23

492 reads

How Client Statistics helps in improving performance in SQL Server

by Kapil Singh

Kapil Blogs

Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received...

2015-11-17

491 reads

SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns

by Kapil Singh

Kapil Blogs

Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...

2015-10-26

604 reads

Blogs

Streamlining Azure VM Moves Into Availability Zones

One of the more frustrating aspects about creating an Azure virtual machine is that...

Monday Monitor Tips: Native Replication Monitoring

Redgate Monitor has been able to monitor replication for a long term, but it...

Advice I Like: Art

Superheroes and saints never make art. Only imperfect beings can make art because art...

Read the latest Blogs

Forums

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

Comments posted to this topic are about the item Think LSNs Are Unique? Think...

A Big PK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Big PK

The AI Bubble and the Weak Foundation Beam

Comments posted to this topic are about the item The AI Bubble and the...

Visit the forum

Question of the Day

A Big PK

In SQL Server 2025, how many columns can be included in a Primary Key constraint?

See possible answers