It’s a great question. Let’s say you want to capture stored procedure completions. But, you only want to capture them between 3AM and 4AM. Can you do it? Output...
2024-07-19 (first published: 2024-07-01)
148 reads
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it...
2024-07-12 (first published: 2024-06-27)
191 reads
There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function...
2024-07-10 (first published: 2024-06-24)
228 reads
A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...
2023-11-24 (first published: 2023-11-13)
235 reads
As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts...
2023-09-18 (first published: 2023-08-23)
215 reads