As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables. This is especially true with logging tables. Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
2024-08-30 (first published: 2021-10-15)
27,721 reads
2021-10-08
2,357 reads
2017-04-25
272 reads
2017-04-12
7,167 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,431 reads
2017-03-21 (first published: 2017-03-15)
495 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,541 reads
2017-03-07 (first published: 2017-03-01)
1,260 reads
2017-02-28
11,537 reads
2014-06-12
677 reads
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Comments posted to this topic are about the item A Challenge of Our Knowledge
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers