Analyzing Tempdb Spills and Usage Across Recursive Queries
This article examines how tempdb is affected by recursive queries, using a few different methods.
2025-05-23
1,631 reads
Chandan Shukla
How to Safely Remove a SQL Server Data File Without Downtime
Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.
2025-05-16
1,716 reads
Blogs
India-US Tariff War: Is the Indian IT Sector at Risk?
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
Save BIG on Microsoft Azure Certification – Up to 100% Off!
By Rohit Garg
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Forums
What is a Failed Deployment?
Comments posted to this topic are about the item What is a Failed Deployment?
Generating a Series I
Comments posted to this topic are about the item Generating a Series I
Dimensional Modeling Case Study Part 3 - Dynamic Days Dimension
Comments posted to this topic are about the item Dimensional Modeling Case Study Part...
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers