November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-09
1,303 reads
SSC Editorial: Back in Time 100 Years
I wrote the editorial asking what people would have been if they had been born 100 years earlier. It’s a...
2010-11-09
454 reads
PASS Summit: Day 1 Keynote Live
It’s the first day of the PASS Summit 2010 and I”ll be live blogging the first keynote here. Click on...
2010-11-09
516 reads
SQL PASS 2010 Keynote, Day 1
The day 1 keynote was kicked off by a Tina Turner impersonator doing a rendition of “Simply the Best”. Rushabh...
2010-11-09
962 reads
Priorities and the PASS Summit
As most of you know, I am not attending the PASS Summit this year. I had all my plans made,...
2010-11-09
627 reads
MS SQL Server 2011 aka Denali, Next Version of SQL Server - CTP 1 Now available!
Ladies and Gentlemen, SQL Server 2011, aka Denali, CTP 1 is now available as public download :
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Although, I'm not attending...
2010-11-09
3,559 reads
Official Blogger at 2010 PASS Summit
I will be one of the “official” bloggers during the 2010 PASS Summit, which means that I get to sit...
2010-11-09
483 reads
Windows 7 in GodMode
I recently became aware of a special hack in Windows 7. It is called GodMode and can very simply be...
2010-11-09
658 reads
The Future Of PASS Elections
Am I stirring up a hornets nest or beating a dead horse bringing up a the PASS elections the day...
2010-11-08
474 reads
So Spaced Out
I had some fun last week presenting to the Space Coast User Group in Melbourne as well. They were so...
2010-11-08
328 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