Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...
2014-01-21
848 reads
Blog Posts
Thaw, Rinse, Repeat – #SQLPlunge
Three years ago in March of 2011, on a whim, I jumped into a hole in a frozen lake into...
2014-01-21
601 reads
Three Hundred!
Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that...
2014-01-21
485 reads
Understanding CXPACKET wait stats in SQL Server
Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying...
2014-01-21
1,256 reads
Using Outlook.com
I looked at Outlook.com when it launched and recently revisited. I connected a couple of my personal email accounts to...
2014-01-21
539 reads
Why no discussion of MarkLogic / NoSQL security in light of Obamacare security fiasco?
We are awaiting Polar Vortex 2 in New England and are set to have more snow dumped on us starting...
2014-01-21
1,078 reads
Win a Free Conference Pass to SQL Server Live in Las Vegas
Taking responsibility for your professional development and making it a priority is essential to being a successful Data Professional. It’s...
2014-01-21
970 reads
Assumptions and clusters – the double whammy
I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through...
2014-01-20
841 reads
Best advice I ever got on negotiating consulting rates and salary negotiations
Back when I was getting ready to take the plunge and begin consulting I sought advice from a friend who...
2014-01-20
795 reads
Counting the Existing, and Missing, Rows
I saw this as a problem recently from someone and thought it would make a good post. As I was...
2014-01-20
731 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