Picking The Next Cell Phone
Cell phones are incredibly useful tools. Even a bad one is better than not having one, but a bad phone...
2014-01-07
474 reads
Blog Posts
Powershell in a Month – Day 7 Adding Commands
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-07
1,355 reads
Predictions for 2014
I love technology predictions because they are usually so wildly inaccurate that at the end of the year it’s pretty...
2014-01-07 (first published: 2014-01-06)
2,579 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
415 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
1,121 reads
Reminder: Orlando Code Camp on March 22, 2014
Ninth annual!
Yes, Orlando Code Camp #9 this year, being held at Seminole State College on March 22, 2014. I’ve submitted...
2014-01-07
363 reads
SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents, gaining access to this data is an on-going challenge...
2014-01-07
21 reads
SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents,...
2014-01-07
1,925 reads
SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents, gaining access to this data is an on-going challenge...
2014-01-07
24 reads
SQL Server 2014 In-Memory OLTP (Hekaton) Limitations
One of the biggest new features in SQL Server 2014 is SQL Server In-Memory OLTP, known mostly by its code...
2014-01-07
4,169 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