Topic
SQL ServerBeginnerError 8152 never said which column. Message 2628 on SQL Server 2019+ (or trace flag 460 on 2016/2017) names it. Then fix the data or the column, and watch for silent truncation.
#data-types#troubleshooting#t-sql
A diagnostic catalogue of slow query causes in SQL Server: how to tell running from waiting, the plan or wait signature of each cause, and the fix.
#execution-plans#performance#troubleshooting
SQL ServerIntermediateSame proc, same code, suddenly 100× slower, and fast again when you run it in SSMS. Here's how parameter sniffing causes it, how to prove it and the fixes that actually hold.
#execution-plans#performance#troubleshooting
SQL ServerIntermediateNOLOCK doesn't just risk dirty reads. It can skip rows, count rows twice and fail with error 601. Read Committed Snapshot Isolation removes the blocking without the wrong answers.
#concurrency#locking#transactions
SQL ServerIntermediateExecution plans tell you exactly how SQL Server ran your query. Learn which operators matter, how to spot bad estimates and what the warnings really mean.
#execution-plans#performance#t-sql
SQL ServerBeginnerAdd or subtract days, months, hours and other units from a date with DATEADD in SQL Server, and handle month-end results, overflow errors and index-friendly filters.
#t-sql
SQL ServerBeginnerGet row counts for every user and system table in a SQL Server database instantly from catalog metadata, and know when you need an exact COUNT instead.
#t-sql
SQL ServerBeginnerFind out how much disk space a SQL Server database, table or index uses with sp_spaceused and sys.dm_db_partition_stats, and read the numbers correctly.
#t-sql
SQL ServerBeginnerUse ASCII, CHAR, NCHAR, CHARINDEX, LEFT, LEN, LOWER, LTRIM and DIFFERENCE correctly in SQL Server, with examples, results and the pitfalls of each.
#t-sql
SQL ServerBeginnerCreate, alter and drop views in SQL Server, update data through them safely, and understand schema binding, indexed views, permissions and common mistakes.
#t-sql
SQL ServerBeginnerNumber rows with ROW_NUMBER() in SQL Server, then use it to get the latest row per group, delete duplicates and page results without surprises.
#t-sql
