SQL Saturday Advice–Upload Decks Early
One of the neat features for the SQL Saturday site is that it allows the speakers to upload a deck...
2011-02-03
1,418 reads
SQL Saturday #63 Dallas Needs YOU
Dallas’ first SQL Saturday ”was full of nothing but smooth, rich #awesomesauce.” And we had Italian gelato.
Dallas’ second SQL Saturday (BI edition) ”had over...
2011-02-03
474 reads
Time’s Makin’ Changes
Some History Almost exactly 7 years I ago my wife and I decided to apply to be missionaries with New Tribes Mission. We decided at that time to...
2011-02-03
6 reads
PASS Update #52 (ERC)
We’re doing weekly calls for the ERC (election review committee) and we seem to be making some progress. This past...
2011-02-03
659 reads
Who Changed Jobs in 2010?
Linked in sent me an email saying that an astounding 209 of my connections changed jobs in 2010, out of...
2011-02-03
539 reads
Is the new 4k sector hard drives a blessing or is it going to be the next best thing after Internet?
I read on lots of websites that the new hard drives will be moving to 4K sectors instead of the...
2011-02-03
1,745 reads
What SQL Server Service Pack Do I Have Installed?
If you’ve used SQL Server for a while, you’re probably familiar with the @@version function. @@ variables are system variables that...
2011-02-03
853 reads
Time’s Makin’ Changes
Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...
2011-02-03
787 reads
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-03
11,121 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-02
1,934 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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