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)
1,996 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
372 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
15 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,332 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,435 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
722 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
10 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
964 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,273 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
259 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers