Tag: sql · Just Some Code

© 2024. All rights reserved.

#sql

2023

2023-09-18 How to automatically format SQL files with Git and Poor Man's T-SQL Formatter

2022

2022-05-02 Brent Ozar’s Mastering Courses: My Honest Review
2022-04-18 BugOfTheDay: Object definitions, spaces, and checksums
2022-04-04 TIL: T-SQL doesn't have constants and variables aren't a good idea
2022-03-21 SQL Server Index recommendations: Just listen to them
2022-03-07 TIL: How to optimize Group by queries in SQL Server
2022-02-21 TIL: How to do a case-sensitive search in SQL Server
2022-02-07 What are implicit conversions and why you should care
2022-01-24 Don't use functions around columns in your WHEREs: The worst T-SQL mistake

2021

2021-03-08 How not to write Dynamic SQL
2021-01-04 TIL: Three differences between TRUNCATE and DELETE

2020

2020-12-03 TIL: Three Tricks to Debug Your Dynamic SQL Queries
2020-11-13 TIL: SQL Server uses all available memory
2020-10-20 TIL: NULL isn't LIKE anything else in SQL Server
2020-10-14 BugOfTheDay: How I tuned a procedure to find reservations
2020-10-08 TIL: EXISTS SELECT 1 vs EXISTS SELECT * in SQL Server
2020-10-05 TIL: How to compare DateTime without the time part in SQL Server
2020-09-30 Two free tools to format SQL queries
2020-09-28 Six SQL Server performance tuning tips from Pinal Dave