SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one...
2011-05-17
1,527 reads
Presenting at Denver SQL Server User’s Group on May 19
I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May...
2011-05-17
600 reads
On Transactions, errors and rollbacks
Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...
2011-05-17
13,279 reads
Updated SQLSaturday Advisory Council
About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...
2011-05-17
701 reads
SQLRally Nordic
With all the talk about SQLRally Orlando you may have missed that we’ve got another SQLRally event in the pipeline...
2011-05-17
686 reads
DBA Brush-Up
I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”. The idea is that there’s...
2011-05-17
794 reads
PASS SQLRally Orlando–We took the Checkered Flag
We did it! SQLRally happened and, from everything I heard, it was a success! That’s not to say that there weren’t some glitches and lessons learned, but we accomplished...
2011-05-17
5 reads
Checking Permissions
Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_idThat’s a little ugly, so let’s fix...
2011-05-17
2,245 reads
SQL Server News, Upcoming Local Events & Webinars.........
Wow! It's only Tuesday, and there's so much going on in the SQL Server World! I wanted to share some...
2011-05-17
666 reads
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,137 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