Manish Kumar

Manish is a Data warehouse/Business Intelligence Solution expert. He has a Master’s degree in Computer Applications with 11+ years of experience resulting from associations with organizations such as Mahindra Satyam, Verizon, ITC Infotech and Aditi Technologies. While associated with these companies, he has had the opportunity to work with well-known names such as Microsoft (R&D, AdCenter India) and Danske Bank Denmark. He is MCITP (SQL 2008 Business Intelligence Developer) certified and his skills and expertise include Design and Architecture definition for BI/DW solutions. He has successfully implemented various BI & DW projects with coverage across ETL, Data Modeling, OLAP, Data Analysis, Data Quality, Analytical Reporting, Data Mining, Dash Board design and implementation as well in fine tuning complex queries and databases.

Manish’s hobbies include writing and reading Hindi poems, cooking, hiking , sports, philanthropy, sharing technical knowledge and listening to music.

All authors

Blog Post

RANKING Function in plain SQL

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT  @StudentScore VALUES ('A',85),...

2012-06-11

64 reads

Blog Post

SQL Azure Federation

 What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.It is also known as...

2012-04-25

838 reads

SQL Azure Federation

 What is Federation?

Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...

2012-04-25

398 reads

Blog Post

CONCAT in SQL 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single...

2012-04-20

88 reads

Blog Post

CONCAT in SQL 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...

2012-04-19

464 reads

All authors

Blogs

Excellent article on securing msdb

By

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

T-SQL Tuesday #201: Temp Tables

By

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

When Do You Reach For A #temp Table?

By

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

Read the latest Blogs

Forums

OUTER APPLY Fundamentals: Part 2

By Imran2629

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