Technical Article

T-SQL Maintenance Plan Creation

Use this script ot be able to create DB Maintenance Plans fast. If you need to create the plans on servers similarly set up, edit the required parameters once, and when you create a new plan, you will only need to specify a database name and one task start time, run the script and the […]

You rated this post out of 5. Change rating

2007-02-05 (first published: )

987 reads

Blogs

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

My Social Media Rules

By

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Harapan Indah Tlp:08217555651

By layanan_Bca88

Hub Via Wa:628217555651 Alamat Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No....

Alamat Kantor BCA KCU Bekasi Telp:08217555651

By m4rt1n4

Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...

Alamat Kantor BCA KCU Garut Telp:08217555651

By R4nt4u

Hub Via Wa:628217555651 Alamat Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut,...

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