Why Scalar Functions Can Be Costly
Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.
2017-06-02 (first published: 2016-01-04)
14,553 reads
Mickey
- Interests: My Family, SQL, LEGOS, Action Movies, and Reading.
Writing Better T-SQL: Top-Down Design May Not be the Best Choice
One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
2016-09-02 (first published: 2015-06-02)
15,872 reads
Writing Better T-SQL: Top-Down Design May Not be the Best Choice
One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.
2016-09-02 (first published: 2015-06-02)
16,261 reads
Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II
A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.
2016-09-02 (first published: 2015-06-23)
10,835 reads
Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II
A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.
2016-09-02 (first published: 2015-06-23)
10,893 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers