2008-12-17 (first published: 2008-11-10)
2,691 reads
Scripts
2008-12-17
112 reads
Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
2008-12-16 (first published: 2008-11-17)
2,704 reads
Get Data, Log, Backup, and Binn Directory (SQL Server 2005)
Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005
2008-12-15 (first published: 2008-11-18)
1,662 reads
Change Ownership of a Maintenance Plan
Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.
2008-12-12
3,191 reads
2008-12-12 (first published: 2008-11-19)
857 reads
2008-12-08 (first published: 2008-11-07)
468 reads
Finding all data types in user tables
A quick way to get a snapshot of what data types are being used in all user tables.
2008-12-04 (first published: 2008-10-02)
1,105 reads
2008-12-03 (first published: 2008-10-29)
1,121 reads
MSSQL Job Monitoring Simplified using Simple Query
This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.
2008-12-02
1,030 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers