People have been writing about how evil scalar functions are in SQL Server for ten years. But people still use scalar functions in their code all the time. And...
2020-03-24
28 reads
We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking...
2020-03-23
19 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-23
22 reads
It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to ... Continue reading
2020-03-23
288 reads
Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...
2020-03-23
97 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-03-23 (first published: 2020-03-16)
330 reads
We have all done it, get some sort of cryptic error and the first place we go to search is Google hoping the sea of message boards and blog...
2020-03-23 (first published: 2020-03-14)
685 reads
Travel is limited, or banned, in many cases these days. Events are cancelled or postponed, and there is a limit to how much contact we should have with each...
2020-03-23
10 reads
Cross-posted from the ISACA Now Blog: “This is the song that doesn’t end. Yes it goes on and on, my friends.” – Lewis, S., “The Song That Never Ends,” Lamb-chop’s...
2020-03-20 (first published: 2020-03-11)
208 reads
I’m giving a session on index tuning at the upcoming Redgate Streamed free online conference. The conference will be held April 1-3 2020, register here and join us! I...
2020-03-20
35 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers