Monday Monitor Tips: Searching Procedures
A customer was asking about how to track all the stored procedures that execute on their system. We have a section in Redgate Monitor that’s set to look at...
2025-08-18
22 reads
A customer was asking about how to track all the stored procedures that execute on their system. We have a section in Redgate Monitor that’s set to look at...
2025-08-18
22 reads
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.
2025-08-18 (first published: 2025-05-27)
1,913 reads
Is AI going to kill off a lot of data professional jobs? Steve doesn't think so, but judge for yourself.
2025-08-18
137 reads
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living I don’t like naps. In fact, I try to avoid them and keep...
2025-08-15
29 reads
2025-08-15
445 reads
I’m back. My last day of work was Jun 27 and I came back a few days ago, on Aug 13. Just over six weeks away and I am...
2025-08-15
21 reads
Today Steve is asking if any of you use Standard Edition with the coming of a developer edition that matches it.
2025-08-15
122 reads
2025-08-13
108 reads
2025-08-13
1,794 reads
I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly...
2025-08-13
58 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers