Compare Patch levels across all installed sql instances
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
1,363 reads
Maintenance
Maintenance Windows
Is it better to ask forgiveness than permission? Some people take that approach to maintenance windows, but that isn't permissible in the cloud.
2021-04-05
163 reads
A General Way to Maintain History Tables
You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.
2017-07-03 (first published: 2015-09-28)
12,942 reads
2015-10-19 (first published: 2013-08-30)
4,386 reads
Developing Low-Maintenance Databases
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
2012-07-23
3,977 reads
Total Space Used for all databases per disk
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
2014-01-08 (first published: 2012-05-04)
3,978 reads
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
928 reads
Next grow for all databases per disk
This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.
2012-05-08 (first published: 2011-09-13)
1,016 reads
Automatic Statistics Update Slows Down SQL Server 2005
I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.
2011-02-25
5,231 reads
2009-11-04
3,468 reads
Blogs
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers