Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes.
2024-08-16
Database Administration
2024-08-14
384 reads
2024-08-05
354 reads
What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
2024-08-01 (first published: 2024-04-26)
5,063 reads
2024-07-31
347 reads
2024-07-22
404 reads
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
2024-07-22
2024-07-10
368 reads
How much Space can I expect to recover from a rebuild after dropping a column?
Check how much space you may expect to recover from a rebuild after dropping a column!
2024-07-05
1,274 reads
Getting Your DBA Teams Scripts into Git
In this article, you will learn how a team can start to better manage the scripts they use for their daily work.
2024-07-01
8,036 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers