SQL- Useful links
Useful links – I hope you might like it too..
http://www.sqlskills.com/blogs/paul/sqlskills-holiday-gift-to-you-all-2012-insider-videos/
2014-01-08
623 reads
Blog Posts
Transactions: What are they?
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...
2014-01-08
1,414 reads
Understanding the Copy_Only option in Backups for SQL Server
The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of...
2014-01-08
1,067 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.7: Additional Plugin Functionality
By Steve Bolton
…………In order to divide this segment of my amateur tutorial series on SQL Server Data Mining (SSDM) into...
2014-01-07 (first published: 2013-12-31)
2,261 reads
Being a Better IT Pro – Get to the Point
When writing emails or other communications, state your point or request right at the beginning.
For instance, if you need...
2014-01-07
432 reads
Day 11 – Purging syspolicy
This is the eleventh installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-07 (first published: 2014-01-04)
1,825 reads
Don't Hitch Your Wagon To MS Access
I know this might seem like an odd topic on a SQL Server blog, but it's a common and critical...
2014-01-07
1,173 reads
Exploring Excel 2013 for BI Tip #14: Sparklines and Pivot Tables
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-01-07
1,254 reads
Happy 2014
I am a bit late with the almost obligatory “How was my past year and how do I think next...
2014-01-07
593 reads
I’m Speaking at the PASS BA Conference
This May PASS will be hosting their second annual Business Analytics (BA) Conference in San Jose, CA. The conference brings...
2014-01-07
580 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