Time for a Little PD
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...
2011-06-13
740 reads
2011-06-13
Afterthoughts: SharePoint Saturday Tampa 2011
This past Saturday June 11th, 2011 I had the opportunity to co-present at SharePoint Saturday Tampa thanks to a special invitation...
2011-06-13
1,072 reads
Non use of persisted data
Working at a client site, that in itself is good to say, I ran into a set of circumstances that...
2011-06-13
630 reads
What is the best value for Fill Factor in SQL Server?
Introduction
When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to...
2011-06-13
7,487 reads
Database Documentation with a Data Dictionary Part 2
A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing...
2011-06-13
1,488 reads
Moving On To New Challenges
After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara,...
2011-06-13
846 reads
Don't touch that Maintenance Plan Job
Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...
2011-06-12
1,934 reads
SQLcruise review
The most amazing journey that I have done in the past years was definitely SQLcruise
(see http://www.sqlcruise.com) – a SQL Server
event organized...
2011-06-12
570 reads
Database Owner - Error Message
Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.
You...
2011-06-12
407 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