Have You Studied SQL Server Enough?
Photo Credit – yum9me
SQL Server is a fairly big and complicated product. There are quite a few areas that you can...
2014-01-29
1,498 reads
Blog Posts
Master Data Services for the Beginner Part 02
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,231 reads
Master Data Services for the Beginner Part 04
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,098 reads
New SSIS Training Class from Andy Leonard
Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class...
2014-01-29
1,405 reads
Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
549 reads
SQL Server Data Compression
SQL Server Data Compression Overview
I have been reviewing the options for data compression in SQL Server and believe it can...
2014-01-29
1,291 reads
SQL Server Quickie #10 – Forwarding Records
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-29
780 reads
SSIS #116–What is the variable value at runtime?
Using variables in SSIS packages can make your ETL process more dynamic and respond to different scenarios during runtime.
Not...
2014-01-29
9,309 reads
SSIS and PowerPivot training in Baton Rouge
I’m happy to announce that I’ll be teaming up with my Linchpin People colleague Bill Pearson for a day of...
2014-01-29
930 reads
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...
2014-01-29
1,247 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