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

[...Read More]

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

[...Read More]

Monitoring SQL Server TRUNCATE TABLE operations has always been a challenge. But I think I've found a workable solution with Extended Events.

[...Read More]

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?

[...Read More]

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

[...Read More]

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

[...Read More]

My SQL Server Agent WMI Alert stopped working. But why?

[...Read More]

Differences between your development workstation and a SQL Server host can make SSIS packages challenging. Here's how I overcame one of those obstacles.

[...Read More]

Thanks to everyone that made it to SQL Saturday Jacksonville 2023. If you attended my "Getting Started with R" session, [...Read More]

A "compact" query showing DDL trigger event group hierarchies.

[...Read More]