2009-09-24 (first published: 2009-09-15)
705 reads
Scripts
Shrink Log File to Target Percentage
Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,550 reads
Generate Data Script for a Table
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,271 reads
Script all the jobs on a SQL server 2005 and apply them in SQL 2008
The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually.
The output script will also have schedules scripted out
2009-09-18 (first published: 2009-09-08)
7,300 reads
List columns data type and size for every table in a database
This script will list columns data type and size for every table in a database.
2009-09-15 (first published: 2009-09-02)
2,015 reads
Dynamic Select Generator
Query to generate a dynamic Select statement from any table for moving data between servers.
2009-09-11 (first published: 2009-09-01)
1,620 reads
Encrypt All Stored procedures at once
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
2009-09-10 (first published: 2008-11-21)
3,331 reads
2009-09-09 (first published: 2009-08-31)
1,313 reads
2009-09-08 (first published: 2009-08-31)
481 reads
Nth occurrence of a weekday in a month and year
To find date at nth occurrence of a weekday in a month and year
2009-09-07 (first published: 2009-09-01)
755 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers