User Defined Types and Temp Tables Gotcha
This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...
2020-04-02
4,386 reads
Daily Coping–2 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-02
24 reads
Learn SSIS and ADF for Free
It’s not from SQLServerCentral, though I hope to do more training across the next few months. Andy Leonard is offering Free Training for People Who Have Lost Their Jobs....
2020-04-02
55 reads
Data Bits – Episode 4 – Jules Behrens
SQL Server DBA Jules joins us on the show to talk DBA work, Chickens, Charity work, Mentoring and Shepherding (actual sheep!) See more at Jules’ site Edit: Honorable mentions: Minionware,...
2020-04-02
17 reads
Quickly Editing Data in SSMS
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having...
2020-04-02
69 reads
How To Fix OBS Black Screen when recording SQL Server Session Demo’s?
Everyone loves a demo. When I say everyone, I mean I personally love seeing a demo in a session which is why 99% of any sessions I present will...
2020-04-02
47 reads
User Defined Types and Temp Tables Gotcha
This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...
2020-04-02
20 reads
Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance
WARNING: This post contains information that can get you fired if you use it without express written permission. In some jurisdictions it might get you jail time as well....
2020-04-01
61 reads
The Power of Git–Getting Code
I find git to be incredibly useful, and this is a quick example of one of the ways that this matters to me. This post is also available in...
2020-04-08 (first published: 2020-04-01)
654 reads
Daily Coping 1 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-01
22 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
Alamat BCA KCU Soekarno Hatta Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
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
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