Change SQL Startup Parameters with PowerShell
Backups Abound
The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-03-31
14,434 reads
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-03-30
2,127 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have...
2011-03-30
16 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-03-30
3,895 reads
Dude, where’s my memory?
A session I have wanted to see. Marciej Pilecki has done this before with high ratings and I have missed...
2011-03-30
1,663 reads
Brad McGehee talking about tempdb issues
Brad presented a session that tries to help you identify and fix tempdb problems. Performance monitor is your friend. the...
2011-03-30
1,856 reads
Brian Kelley on Security at SQL Server Connections
Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a...
2011-03-30
1,898 reads
I laughed, I cried, it was better than CATS: The Fast Track Data Warehouse 3.0 Reference Guide
Careful what you say about cats, lady.
You know what’s crazy?
A comprehensive, technical, well thought-out, and ENJOYABLE document. One written with...
2011-03-30
1,794 reads
Improving Meetings
Most folks I know hate meetings. They especially hate meetings about meetings. Recently I was working with a developer who...
2011-03-30
2,099 reads
Tampa IT Camp 2011 Lessons Learned Part 1
On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys...
2011-03-30
1,745 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
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers