Devendra Thakur

Devendra Kumar Thakur has a Master's Degree in Computer Applications from Jabalpur Engineering College, and has worked as a Lead Consultant with companies such as Siemens, Accenture, and his current employer, ITC. The majority of his experience is with SQL Server, SSRS, and Crystal report as a developer, however he is now trying to learn SSAS.

Interests: Bikes, XBox, Beaches and AI

Mastering Index – Index on Computed Columns

by Devendra Thakur

Help on SQL Server

This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...

2016-11-07

547 reads

Mastering Index – Index with included columns

by Devendra Thakur

Help on SQL Server

This article is the part of series Mastering Index, in this particular article we will be exploring Index with included...

2016-10-18

485 reads

Mastering Index – Unique Index

by Devendra Thakur

Help on SQL Server

This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a...

2016-10-14

464 reads

Mastering Index – Nonclustered Index

by Devendra Thakur

Help on SQL Server

This article is the part of series Mastering Index, in this particular article we will be exploring Nonclustered Index. Take...

2016-10-10

470 reads

Mastering Index – Clustered Index

by Devendra Thakur

Help on SQL Server

This article is the part of series Mastering Index, in this particular article we will be exploring Clustered Index. Take...

2016-10-03

506 reads

Mastering Index – Introduction

by Devendra Thakur

Help on SQL Server

One of the most interesting and talked about topic in database field is Index. I am writing this Series of...

2016-09-29

852 reads

Part 1 - Detecting and Monitoring Memory Pressure

by Devendra Thakur

Help on SQL Server

I will be writing
this article in four parts because this topic is huge and amount of information
can be overwhelming for...

2016-09-27

491 reads

Order by Month Number and Show Month Name

by Devendra Thakur

Help on SQL Server

This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...

2016-09-24

935 reads

Mastering Index - Filtered Index

by Devendra Thakur

Help on SQL Server

Mastering Index - Filtered Index

This article is the part of series Mastering Index, in this particular article we will be exploring Filtered Index. Take...

2016-09-23

612 reads

Learn Basic SQL in 30 minutes

by Devendra Thakur

Help on SQL Server

This article is for those who have no idea about Sql and I will be giving them a start point...

2016-09-21

436 reads

Blogs

Identity Columns Can’t Be Updated: #SQLNewBlogger

I’m not sure I knew identity column values could not be updated. I ran...

Rolling Back a Broken Release

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By ChrisJenkins

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Read the latest Blogs

Forums

Can someone please explain what happens?

I have mentioned this several times over several years. Can someone please help me...

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?

See possible answers