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,511 reads
2009-06-11 (first published: 2009-05-25)
751 reads
The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.
2013-05-16 (first published: 2009-05-07)
4,250 reads
Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments
2009-08-03 (first published: 2008-09-05)
1,098 reads
2008-08-01
834 reads
2008-08-13 (first published: 2008-06-17)
1,083 reads
2012-03-30 (first published: 2008-04-21)
3,207 reads
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
3,464 reads
2012-07-13 (first published: 2008-03-20)
2,196 reads
As per Threshold value DBA will get notified about the Disk Drive usage.
2007-11-23 (first published: 2007-10-08)
1,807 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Comments posted to this topic are about the item 50 Years of Microsoft
Comments posted to this topic are about the item Multiple Collations
Comments posted to this topic are about the item Retrieving Data Using the REST...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers