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

551 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

494 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

470 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

473 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

511 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

863 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

495 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

938 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

614 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

438 reads

Blogs

Excellent article on securing msdb

By Brian Kelley

Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...

T-SQL Tuesday #201: Temp Tables

This month we have a new host, which I am grateful for. So many...

When Do You Reach For A #temp Table?

By MarlonRibunal

I needed to do some research because there is more to #temp tables than...

Read the latest Blogs

Forums

OUTER APPLY Fundamentals: Part 2

Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2

Building Great Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Great Software

The Range of Customers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Range of Customers

Visit the forum

Question of the Day

The Range of Customers

I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):

orderid orderdate               customerid complete
3       2025-05-10 00:00:00.0002          1
21      2024-01-10 00:00:00.0003          1
15      2023-10-28 00:00:00.0004   1
13      2025-03-08 00:00:00.0006          1
11      2024-04-02 00:00:00.0007          1

If I run this query, how many rows are returned?

SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

See possible answers