Category Archive

SQL Server

Installing SQL Server on Linux (Ubuntu)

How to Install SQL Server on Linux: SQL Server 2025 on Ubuntu 24.04, Step by Step

Install SQL Server 2025 on Ubuntu 24.04 and make it production-ready: supported version pairs, disk layout, mssql-conf settings, the mssql...

September 25, 2025

Stopwatch and magnifying glass over query cards, representing finding slow queries in SQL Server

Find Slow Queries in SQL Server: DMVs and Query Store Step by Step

How to find slow queries in SQL Server right now, in the plan cache and in Query Store history, how...

September 17, 2025

Laptop with an update arrow, representing updating SQL Server Management Studio

How to Check and Update SQL Server Management Studio (SSMS)

Why SSMS is updated separately from SQL Server, how to check your SSMS version, how updates work for SSMS 21...

Block columns of different heights with a ruler, representing measuring table sizes in SQL Server

Find Table Sizes in SQL Server: Rows, Data, Index and Unused Space

Queries to find table sizes in SQL Server split into data, index and unused space, the largest tables across all...

Three tables linked by key connections, representing SQL Server foreign key relationships

List Foreign Key Relationships in SQL Server: Columns, Rules and Untrusted Constraints

Queries to list every foreign key relationship in SQL Server with columns and cascade rules, find and fix untrusted constraints,...

Database table connected to several objects under a magnifying glass, representing finding stored procedures that use a table

Find Stored Procedures That Use a Table in SQL Server: Dependency Queries That Actually Work

How to find every stored procedure, view, function and trigger that uses a table or column in SQL Server, including...

Table block with one column pulled out, representing safely dropping unused columns in SQL Server

Safely Drop Unused Columns in SQL Server: A Script That Handles Dependencies

A two-stage method to retire unused SQL Server columns, and a query that generates the drop script with default, check...

Cubes passing one by one through a gate next to the same cubes grouped into one block, representing row-by-row cursors versus set-based SQL

SQL Server Cursors: Syntax, Options, Performance and Set-Based Alternatives

How SQL Server cursors work, which options to use, why they're slow, four cursor patterns rewritten as set-based queries, how...

Columns of blocks with the top blocks raised, representing top N rows per group in SQL Server

Top N Rows per Group in SQL Server: ROW_NUMBER, DENSE_RANK and CROSS APPLY

Three ways to get the top N rows per group in SQL Server, how ROW_NUMBER, RANK and DENSE_RANK handle ties,...

Calendar and a highlighted range on a timeline, representing SARGable date filters in SQL Server

Date Math in the WHERE Clause: Writing SARGable Date Filters in SQL Server

Why YEAR(date) = 2026 and similar date predicates can't use an index, how to rewrite them as SARGable ranges, the...

Prev 1 2 3 4 5 … 10 Next