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

My Black Friday Sale on Training Classes is Open Now!

Every year, I run a Black Friday sale to reward people who read the blog our all year long but can’t get their boss to spring for my regular full [...]

[Video] Office Hours: 4 Great Questions Off Canada
[Video] Office Hours: 4 Great Questions Off Canada

This is the third Office Hours in a row from the same cruise ship! Y’all keep banging out really good questions at https://pollgab.com/room/brento. Here’s what we discussed today aboard the [...]

Meet Hugo Kornelis, Execution Plan Expert.
Meet Hugo Kornelis, Execution Plan Expert.

Hugo Kornelis is a database consultant in the Netherlands. Here are a few of his sites that you might recognize: SQLServerFast.com – his useful and insightful blog The Execution Plan [...]

Why You Don’t Get Parallelism When You Ask for The Whole Table
Why You Don’t Get Parallelism When You Ask for The Whole Table

Let’s say you’re working with a big copy of the Stack Overflow database, and you wanna get all the users, like for a data export. SQL Server doesn’t parallelize this [...]

Copyright © 2026 SQLFolks – OnePress theme by FameThemes