Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)
Category:
tsql-programming
, sql-server
Last week, I presented on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit.
Category: sql-server
ORDER BY, OFFSET, and Fetch in TSQL
Category:
tsql-programming
, sql-server
My most recent Quizletter featured a quiz on ORDER BY in TSQL, complete with questions on the OFFSET and FETCH clauses which we got in SQL Server 2012.
One great thing about teaching TSQL School is that it reminds me of these cool options that can be easy to forget.
AVG() in TSQL: Watch Your Data Types
Category:
tsql-programming
, sql-server
This week’s Quizletter featured a quiz on using the AVG() function in SQL Server.
I was inspired to write this quiz because I’ve been teaching “TSQL School” each week. When we covered aggregate functions, I remembered how tricksy AVG() can be.
Query Store Cleanup Can be Part of a Blocking Chain
Category:
query-store
, sql-server
Forgetfulness can lead to learning something new. This is a bit of a nightmare when it happens in production, but a treat when it happens in an isolated test system– and that’s how I learned this.
I left a bit of blocking open on my test VM, and forgot about it.
Adaptive Queries in Standard Edition: Interleaved Exec for Multi-Statement TVFs
It’s tough to keep track of which features work in each version of SQL Server, and which Editions support them.
My memory told me that the new Adaptive Joins feature in SQL Server 2017 was Enterprise Edition only… and that’s correct, but I didn’t realize that the fancy new feature to make Multi-Statement TVFs smarter has much wider licensing.
Auto-Tuning: Automatic Plan Correction is Cleared on Restart
The new Enterprise Automatic Tuning feature in SQL Server 2017 may sound intimidating at first – one question I get a lot lately is whether or not there’s a future for DBAs. Will Auto-Tune mean we don’t need any more human tuning?
Well, not anytime super soon.
Why Is My Function Missing From sys.dm_exec_query_stats and Query Store?
I just spent 90 minutes of my life figuring out a detail about sys.dm_exec_query_stats which I’m pretty sure I figured out five years ago, but didn’t write a blog post about.
Time to write a blog post, so I can save time when I go searching for this in a couple years.