Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?

A TSQL solution for parsing file names, with a little help from an old DOS trick.

Specifying a collation in WHERE clause predicates can result in scan operations, even when there is an underlying index. Can we coerce SQL into using Index Seeks?

Optimizing a table for analytics and maintenance proved trickier than I expected.

For SQL Server metadata, the information schema views may not be suitable for all of your needs. Here is an example involving table constraints.

There are performance implications when choosing between the Default Schema and an Explicit Schema for SQL Server's OPENJSON rowset function.

Can the performance of PIVOT be beaten with newer T-SQL features?

Return the first value in an ordered set of values with analytic function FIRST_VALUE.

How to add a custom Transact-SQL code snippet to SQL Server Management Studio.