Script and deploy the data for database from SSDT project
This post is a part of the series about SSDT and database project leveraging Visual Studio. We already know that SSDT can cover all objects but only on a...
2019-10-30
41 reads
Error 9002
This is very important error whenever you see this error it is clear that your database has “TLOG FILE FULL” and this could result into maintenance job failed or...
2019-10-30
33 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
6 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
24 reads
I’m Speaking at SQL Saturday Oregon
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
14 reads
SQL Server 2019 Feature Power Rankings
Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...
2019-10-29
551 reads
SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
13 reads
SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
12 reads
Last Week Reading (2019-10-27)
Hello and good morning! We have Tuesday morning, which means I experienced a delay in this post. But finally, it is out and have a look at how much...
2019-10-29
22 reads
Fail to cycle errorlog
sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle...
2019-10-29
33 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