2011-01-05
9 reads
2011-01-05
11 reads
Quick SQL Server Sessions Troubleshooting
Summary
I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server....
2011-01-05
1,445 reads
Temporary Post Used For Theme Detection (7152665d-114f-4469-a816-6ca6880e832a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (95b57a7c-aa49-471e-a63c-76ea6775d1d4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2011-01-04
524 reads
SQLRally Session Voting Schedule Change
Jack Corbett posted the official announcement to his blog - I'm posting here as well to make sure we reach as...
2011-01-04
365 reads
PASS SQLRally Update–Voting Pushed Back
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. Unfortunately we are having to push back the voting...
2011-01-04
7 reads
31 Days of SSIS – Folder Structures (4/31)
31 Days of SSIS
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I...
2011-01-04
433 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other two books earlier in the year in 2010 and...
2011-01-04
9 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other...
2011-01-04
582 reads
MCM Prep – Sliding the test
If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night...
2011-01-04
650 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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
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