Close, but no MCM Cigar
I failed.
There’s no other way to say it, but I’m not really disappointed or discouraged. I’m actually fairly upbeat about...
2011-04-12
1,201 reads
SSRS 2005 Error: The Declare cursor SQL construct or statement is not supported
Few days back I downloaded a SSRS 2005 file from one of our internal report server and started modifying it....
2011-04-12
2,891 reads
It's not about whether you're a consultant or full-time staff...
There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...
2011-04-12
1,338 reads
PASS SQLRally–Thoughts from an Organizer
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the...
2011-04-12
844 reads
PASS Women in Technology
The Professional Association for SQL Server (PASS) Women in Technology group first caught my attention at the PASS Summit in 2009...
2011-04-12
1,003 reads
Confessions of a DBA – Part 2
How I caused a fifteen minutes of blocking.
This particular incident happened when I joined this company. I joined this company...
2011-04-12
1,342 reads
Powershell Day 12
Day 12 ADSI Using Powershell you can work on Active directory as well. Active directory is introduced in windows 2000....
2011-04-12
482 reads
T-SQL Tuesday - Using APPLY to find out which queries are running on which CPU...
When I saw that Matt Velic's is hosting T-SQL Tuesday, and he has invited the SQL commmunity to participate, I was very...
2011-04-12
2,921 reads
Corporate Staffers = Second Class Citizens?
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to...
2011-04-12
775 reads
Corporate Staffers = Second Class Citizens?
Earlier today I read a blog post that compares consultants with corporate staff members. The author unashamedly compares consultants to...
2011-04-12
1,318 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