This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
2010-04-09 (first published: 2010-03-09)
2,177 reads
2010-04-06 (first published: 2010-04-01)
3,938 reads
2010-04-02 (first published: 2010-03-18)
2,132 reads
2010-04-01 (first published: 2010-03-31)
4,381 reads
With this view you can obtain last failed job steps without using visual interface.
2010-03-30 (first published: 2010-03-19)
2,367 reads
2010-03-29 (first published: 2010-03-24)
1,840 reads
Here is a one more very quick way to find row count for a table.
2010-03-26 (first published: 2010-03-23)
5,384 reads
Evaluate credit card numbers based on ISO 2894 algorithm.
2010-03-24 (first published: 2010-03-17)
1,926 reads
This script displays Phonetic Pronunciation of a given password
2010-03-22 (first published: 2010-03-12)
1,391 reads
2010-03-17 (first published: 2010-03-04)
1,531 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...
Hub Cs:08217555651 Jl. Lambung Mangkurat No.11-13, Kertak Baru Ulu, Kec. Banjarmasin Tengah, Kota Banjarmasin,...
Hub Cs:08217555651 Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan...
Hub Cs:08217555651 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan...
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers