T-SQL Tuesday #051: Place Your Bets
Place Your Bets All bets on the table please. This is the last call for bets, no new bets will be allowed. This marks the 51st invitation for TSQL...
2014-02-04
6 reads
Blog Posts
Upcoming Presentations
Since I took the leap last year and submitted to talk at SQL Saturday, I’ve come to enjoy the challenge that...
2014-02-04
619 reads
Using sys.objects When Scripting Permissions? You're Missing Something!
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user...
2014-02-04
1,109 reads
Announcing the SQLpassion Performance Tuning Training Plan
You are a developer and/or DBA and want to learn in a very compact way the essential things about performance...
2014-02-03
1,085 reads
Blockades and ladders to learning new tech
It’s been a long time since I’ve been a true newbie to a technology. There are plenty of things I...
2014-02-03
587 reads
Cumulative Update – 15 for SQL Server 2008 Service Pack 3 Is Now Available !
The 15th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...
2014-02-03
759 reads
Cumulative Update – 8 for SQL Server 2012 Service Pack 1 Is Now Available !
The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all...
2014-02-03
1,228 reads
Eight Essential Questions for Every Corporate Innovator
Reflect before you leap into action.
from HBR.org http://ift.tt/1behXS1
via IFTTT
2014-02-03
271 reads
HBR’s 10 Must Reads: The Essentials
If you read nothing else, read these 10 articles from HBR’s most influential authors: 1) “Meeting the Challenge of Disruptive...
2014-02-03
367 reads
Installing VMware vCenter 5.5 on Windows Server 2012R2
Recently I encountered a small glitch while trying to install VMware’s vCenter 5.5.0b Server on a new VM with Windows...
2014-02-03
1,313 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