Skip to content
SQLFolks
Menu
  • Tips & Tricks
  • Indexes
  • Query Hints
  • AI
  • Links
  • Contact

Author: admin

Indexes / Tips & Tricks

SQL Index Creation Tutorial (Part 1): Heap Tables and Basics

Example: Data source: Heap table (a heap without a clustered index) Address_TEST, 9,963,912 rows, no nonclustered indexes. Query: Estimated Execution Plan 1: Estimated Subtree Cost: 143.514 – high number = …

Posts navigation

Newer posts
SEARCH:

Brent Ozar’s Blog

[Video] Office Hours: Desert Database Q&A
[Video] Office Hours: Desert Database Q&A

I’m in the Lake Mead National Recreation Area today, hanging out in the triple-digit heat, to answer your top-voted questions from https://pollgab.com/room/brento. Prefer listening to this via podcast? Good news! [...]

Miscellaneous Thoughts About Building Stuff with AI in July 2026
Miscellaneous Thoughts About Building Stuff with AI in July 2026

Over the past couple of years, I’ve been using the bejeezus out of AI. I don’t really feel like an expert by any means – it’s so hard to keep [...]

Need a Reference Check on Richie Rump? Here You Go.
Need a Reference Check on Richie Rump? Here You Go.

So your company read my post about 5 reasons you should hire Richie Rump, and you checked out his web site and his LinkedIn. Now, your HR department wants to [...]

Think You Know A Lot About SQL Server? Well, Actually…
Think You Know A Lot About SQL Server? Well, Actually…

Got a few minutes? Close that dating app and pay attention. Check out this little SQL swipe quiz: “Well, Actually…” Swipe right if you think the statement is true, left [...]

Copyright © 2026 SQLFolks – OnePress theme by FameThemes