Check the .NET Framework Version Installed
I haven’t ever worried about this, but I had the need recently to check. I was looking a SQL Sentry’s...
2010-11-10
1,866 reads
Appending Date to End of Report Name in Reporting Services Subscription
Recently, a friend of mine asked me how he could have the date appended to the end of a file...
2010-11-09
13,956 reads
Blogging and Saving Money at the Same Time
I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing...
2010-11-09
608 reads
Android Tablet
I was in Best Buy, actually returning a couple iPads the other day. I had gotten a few for a...
2010-11-09
1,518 reads
White Paper of Supportability Roadmaps
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and...
2010-11-09
681 reads
Back Home
And glad to be there. I was gone almost 7 days, home only for 24:15:00 before back out on another...
2010-11-09
819 reads
First Impressions
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...
2010-11-09
1,429 reads
Day 1 at SQLPASS Keynote Address
Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in...
2010-11-09
467 reads
PASS Summit 2010-Tuesday
Started my day by going up to the club floor for the continental breakfast, met Mark Souza on the elevator...
2010-11-09
565 reads
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap out a bit sooner. This month, I intentionally delayed...
2010-11-09
5 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