Can you apply the DISTINCT keyword to only one column in a SELECT? No, it always applies to all the columns. I explain why and get the same result with GROUP BY.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
CEILING and FLOOR: Negative Values Change the Direction
CEILING and FLOOR follow numeric order even below zero. This example compares both boundaries with truncation and explicitly defines its displayed decimal types.
Stress Testing a Query Before Release
Stress testing a query before release reveals concurrency and parameter risks; learn to design realistic SQL Server tests and compare useful metrics.
SQL SERVER – Get Information of Index of Tables and Indexed Columns
sp_helpindex is a handy stored procedure that shows every index on a table, its description and the indexed columns. One line of T-SQL does it.
SQL SERVER – T-SQL Script to Find Details About TempDB Information
TempDB Information starts with the files and their actual locations. I inspect every data and log file before proposing changes.
SQL SERVER – Solution – Log File Very Large – Log Full
Is your log file too big, or is the log full? Fix it in three steps: back up the log file, truncate it, then shrink it. I link my two detailed posts too.
SQL SERVER – TempDB Restrictions – Temp Database Restrictions
TempDB Restrictions follow from how SQL Server recreates and uses this system database. I check them before applying user-database maintenance habits.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.