How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-06-04 (first published: 2014-05-28)
2,002 reads
John Sansom
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-05-28
375 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one...
2014-05-28
20 reads
Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues
I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby...
2014-02-19
3,480 reads
Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues
I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby the “sa” account kept being locked out. In scenarios...
2014-02-19
2,731 reads
Winner – Conference Pass to #SQLServerLive in Las Vegas
This is a quick post to announce the winner of my blog giveaway for a free conference pass to SQL Server Live! in Las Vegas.
Those...
2014-02-12
726 reads
Winner – Conference Pass to #SQLServerLive in Las Vegas
This is a quick post to announce the winner of my blog giveaway for a free conference pass to SQL Server Live! in Las Vegas. Those rather nice folks at SQL Server Live are also offering...
2014-02-12
17 reads
Win a Free Conference Pass to SQL Server Live in Las Vegas
Taking responsibility for your professional development and making it a priority is essential to being a successful Data Professional. It’s...
2014-01-21
969 reads
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,274 reads
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy...
2014-01-14
308 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Alamat Kantor BCA KCU Sidoarjo Tlp:(08218200203)
Hub Via Wa:628218200203 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo,...
Alamat Kantor BCA KCU Diponegoro Tlp:(08218200233)
Hub Via Wa:628218200233 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat Kantor BCA KCU Indrapura Tlp:08218200174
Hub Via Wa:628218200174 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
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