Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
2012-10-18 (first published: 2009-11-18)
12,424 reads
Automated index defragmentation script
Blogs
Accessing the Kubernetes API from SQL Server 2025
The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit...
Empowering Technical Teams: Leading with Vision, Not Micromanagement
By Chris Yates
Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a...
Azure DMS Tutorial: Migrate Databases to Azure with Minimal Downtime
By Rohit Garg
Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the...
Forums
Trouble Sending Email from Scheduled Job
I'm a little rusty with SQL, been away a while. I have SQL Mail...
Low Level design for Error Logging for Data Pipeline
Hello, May someone please help me how to design Error Logging for the Data...
Best Way to Repair SQL Database: How to Restore SQL Server?
Comments posted to this topic are about the item Best Way to Repair SQL...
Question of the Day
Capacity Planning for an Existing SQL Server Workload?
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers