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)
11,427 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-08-19 (first published: 2015-06-23)
10,821 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-08-19 (first published: 2015-06-23)
10,827 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-08-12 (first published: 2015-06-02)
15,859 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-08-12 (first published: 2015-06-02)
16,016 reads
Blogs
Friend of Redgate 2020
By Chris Yates
Last week I was excited to receive an email from Redgate notifying me that...
Azure Database for PostgreSQL
By Arun Sirpal
Having worked with Azure SQL Database and its many flavours for couple of years...
Why I Support Code Automation Tools Like ORMs
I know I’m a weirdo. I’ve always been a weirdo. When I was a...
Forums
Index maintenance in availability groups
I have a 4 node always on availability group setup across two datacentres with...
Extract part of string
hi, How can I extract part of this string declare @string varchar(1024) set @string...
Data type conversion error
All, This is my data flow: I'm getting the error: "Error: 0xC02020A1 at Data...
Ask SSC