Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
2009-06-19 (first published: 2009-06-08)
599 reads
We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.
2009-06-18 (first published: 2009-06-05)
2,521 reads
Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.
2009-06-15 (first published: 2009-05-30)
1,262 reads
2009-06-11 (first published: 2009-05-25)
768 reads
This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.
2009-06-10 (first published: 2009-05-22)
2,400 reads
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
2,003 reads
Here is a stored procedure that start a job, and then waits until the jobs is finished
2009-06-02 (first published: 2009-05-14)
1,041 reads
Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
930 reads
2009-05-27 (first published: 2009-04-30)
2,613 reads
2009-05-22 (first published: 2009-04-28)
3,835 reads
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
WA:08218154393 Jl. Majapahit No.112, Pandean Lamper, Kec. Gayamsari, Kota Semarang, Jawa Tengah 50161
WA:08218154393 Ungaran Square, Jl. Gatot Subroto Blok A3-A4, Banaran Barat, Bandarjo, Kec. Ungaran Bar.,...
Comments posted to this topic are about the item The SQL Server 2016 Plan
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers