Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,199 reads
Learn an easy, rough, and ready way to manage log files in this piece.
2016-12-16 (first published: 2015-03-09)
9,767 reads
The table names are in the dtproperties table, but they're hard to get at.This is a crude attempt. I tried to filter out the table names, but sometimes they have an extra garbage character as a prefix. This code assumes that all table names are made up of regular ASCII characters, and that all dtproperties tables in […]
2004-09-02
Here's something I got from the Microsoft site -- Works pretty well(Sorry all the indenting goes out of it with this post. Get the original off the MS site if you want -- see note): /*========================================================================= Title: Shrink SQL Server Transaction Log Script SQL_Server_Trx_Log_Shrink.sql Purpose: INF: How to Shrink the SQL Server 7.0 Transaction Log […]
2004-06-22
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers