SQLStudies

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...

2012-09-02

4,115 reads

At Startup SSMS setting

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

659 reads

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,341 reads

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

I had an idea for an animated view of a sales tool, and started...

Hi all, I'm trying to do classic scenario for loading multiple Excel files into...

Hi So the case statement is slowing this down - but for the life...

I need to delete rows from both the temporal main and history tables. The...

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')

Assume preview features are enabled.