CROSS APPLY v InLine Functions
While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which...
2016-02-10
2,160 reads
How Bad Are Your Indexes?
In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had...
2016-02-10
3,119 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,808 reads
Changing to simple recovery to clear the log.
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
576 reads
View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...
2016-02-09
919 reads
VMware vExpert 2016 Announcement
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
462 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
153 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,929 reads
How Much Hospitals Charge For The Same Type Of Cases?
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...
2016-02-16 (first published: 2016-02-09)
2,216 reads
Spring Training: Developing SQL Queries for SQL Server
Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries...
2016-02-09
479 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
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