Junior DBAs - Where to start?
I personally would start with your local user groups. Getting to know people and networking may be your best bet...
2013-12-06
428 reads
DBA On The Go
Blocked processes: Quick Tips
Sometimes activity monitor just isn't fast enough. Maybe it's not telling you what a specific query is doing. Below is...
2013-12-05
468 reads
Ideal Working Conditions and Free Training Winner!
Contest Winner!
So last Monday I announced a giveaway that I think is a great gift to give away. Every Monday...
2013-12-04
588 reads
Testing labs
What sort of testing lab do you setup when you're testing things out? I hear see the world adventureworks almost...
2013-12-13 (first published: 2013-12-03)
1,265 reads
Index Rebuild Status Update And Giveaway!: Quick Tips
I have a Free 1-Month code to PluralSight. There's no catch or gimmick, If your comment is in this post,...
2013-12-02
493 reads
Free Friday: Training
There are a number of good sites that offer free training and free E-Books. The community around MS SQL is...
2013-11-29
1,191 reads
Decrypting Stored Procedures Thanksgiving Special:Quick Tips
Update: Thanks for your response Jon Gurgul! I have updated the files to reflect your updates. It's faster and cleaner...
2013-12-06 (first published: 2013-11-28)
3,488 reads
Wasted Space Per Database For Fill Factor: Quick Tip
As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own...
2013-11-27
2,578 reads
Things I've Learned In Regards To Fill Factor:Quick Tips
I don't have much today... It's been a good week so far. I think I'm becoming a bit obsessed with...
2013-11-26
635 reads
Usage grouped by Database: Quick Tips
Quick script just to give you an idea of how your databases are being used. Mainly useful for exploring.
select db.name...
2013-11-25
8,903 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...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
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