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

201 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

859 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

575 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,017 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

How to Connect to SQL Server When Nothing Else Works – DAC

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Are luxury packages in Andaman suitable for a honeymoon?

By andamantourtravelpackage

Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table:

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960

If I run this code, what document(s) is/are returned?

SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers