Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers. Take the survey before April 5, 2019. Your...
2019-03-19
23 reads
This morning, I received the following question from a user: Hello Madam, Could you please clarify SQLServer “Data Row” size: If I run the script below on SQL Server...
2019-03-19
23 reads
Watch this week’s episode on YouTubeAT TIME ZONE is great because it makes it easy to perform daylight saving time and...
2019-03-19 (first published: 2019-03-05)
9,339 reads
I’m in Redmond, or Bellevue, or somewhere nearby. Not completely sure where the Microsoft MVP Summit is this week (as...
2019-03-18
551 reads
I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred within it. If you haven’t heard of the GDPR,...
2019-03-18
15 reads
I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred...
2019-03-18
339 reads
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a...
2019-03-18
15 reads
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...
2019-03-18
451 reads
This is a trick I use in SQL Server Management Studio at least once a week.
Today’s scripts will be screenshots...
2019-03-18 (first published: 2019-03-02)
3,196 reads
SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been...
2019-03-18 (first published: 2019-03-05)
16,869 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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