Very interesting topic Steve. What I have observed very common is the data type mismatch in LINQ queries which causes the queries to do Table scan instead of seek...

Very interesting topic, Steve. I've been in this field for a long time, so I have encountered this issue more than once. I wasn't prepared for it, so I...

In general, I hate triggers.

I was shocked to find a DB deployment pipeline that was written using the Talend ETL tool.  The tool attempted to be a SQL parser dictating what SQL could...

2024 placeholder: https://www.sqlservercentral.com/forums/topic/ssc-fantasy-football-2024

As usual, DM me the email you want to use for an Amazon GC as a prize.

congrats to the top 3.

Good thoughts, as always....

Steve, thanks for all the blogs. SQLServerCentral is the first email I read in the mornings. I plan to do my first presentation this month, and to start a...

Hey, Ray, I try to post these on the SQL Saturday site at: https://sqlsaturday.com/#reserved

So far, I have no confirmed dates, but I do have NYC looking at May as...

Thanks, and no horse chores for me. A little under the weather yesterday, but luckily my kids stepped up and shouldered the load

Happy Holidays and Merry Christmas, everyone. Enjoy the long weekend.

I've used AI mostly for things outside of SQL development.  Like git and C# and Powershell.  It seems like it saves time (not always tho) and I go to...

It was a weird thing I stumbled on when working with arrays and removing elements as dale_berta noted, the array is still the same size, which is expected. It shouldn't...

Hope you enjoy it. I've gone through 16 days so far, and I have some catching up to do after a busy week. I'll likely dig in this afternoon for...

Your opinion is wrong. The question asks for defaults for this T-SQL code. The defaults are not stored in sys.parameters. They are only in the code definition in sys.sql_modules.definition.