Arun Kumar

Arun Kumar has over 8 years' extensive working experience in database query development, design, supporting many different versions of MS-SQL. He has worked to develop efficient reports, index optimization for complex queries, and has finance and operation domain experience. He has also worked with SPLUNK and enjoys training technical and non-technical colleagues.

Interests: Database developer and designing

What is an Identity?

by Arun Kumar

TSQL Circle Live

Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but...

2016-01-26

129 reads

What is Normalization in SQL Server?

by Arun Kumar

TSQL Circle Live

In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a...

2016-01-26

202 reads

What is an execution plan? When would you use it? How would you view the execution plan?

by Arun Kumar

TSQL Circle Live

An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...

2015-12-28

862 reads

How do we insert the results of the stored procedure in a table?

by Arun Kumar

TSQL Circle Live

This question has two crinkle answers –· When the table is already created.
· When the table is to be created run...

2015-11-13

140 reads

How we can convert Comma Separated Value to Rows and Vice Versa?

by Arun Kumar

TSQL Circle Live

How we can convert Comma Separated Value to Rows and Vice Versa?
Basic fundamental

While we are working on reporting some circumstances...

2015-10-08

450 reads

HOW WE CAN GET WHO IS CONNECTED TO DATABASE?

by Arun Kumar

TSQL Circle Live

Some time we need to know that who is using database as of now or who all are connected to...

2015-10-07

576 reads

Table valued parameters (TVP)

by Arun Kumar

TSQL Circle Live

Table values parameters
How we can pass multiple rows in stored procedure or function as a parameter?
Table-valued parameters are a new...

2015-10-06

2,020 reads

Utility link for excel import to SQL

by Arun Kumar

TSQL Circle Live

Utility link for excel import to SQL

Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...

2015-09-30

442 reads

Blogs

Learn about Modern Microsoft Apps in San Diego

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps

Fabric has CI/CD built in, but if you've tried to use it for database...

A New Word: Attriage

attriage – n. the state of having lost all control over how you feel...

Read the latest Blogs

Forums

Alamat Kontak Bank BCA KCP Ubud Telp:08218154393

By Layanan_BCA_24jam

WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571

Alamat Kontak Bank BCA KCP Maluku Telp:08218154393

By Layanan_24jam

WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119

Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393

WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156

Visit the forum

Question of the Day

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers