A DMV a Day – Day 7
I have three different DMVs for Day 7. The first one is sys.dm_db_missing_index_group_stats, which is described by BOL as:
Returns summary...
2010-04-07
1,212 reads
Glenn Berry
24 Hours of PASS: Celebrating SQL Server 2008 R2
Well, we finally got the ok to start talking about the second 24 Hours of PASS event, called 24 Hours...
2010-04-06
569 reads
A DMV a Day – Day 6
The DMV for Day 6 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-06
850 reads
Big Iron on Windows 2008 R2, Earning its Keep!
This screenshot goes in the category of “geek porn”… It shows an IA64 system with 256 logical processors and 512GB...
2010-04-06
273 reads
A DMV a Day – Day 5
The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...
2010-04-05
1,017 reads
Microsoft Drops Support For Itanium after SQL Server 2008 R2
Microsoft’s Dan Reger has announced that Microsoft will not be supporting the Itanium architecture after Windows Server 2008 R2, SQL...
2010-04-05
2,332 reads
A DMV a Day – Day 4
The DMV for Day 4 is sys.dm_os_sys_memory, which is described by BOL as:
Returns memory information from the operating system. SQL...
2010-04-04
1,344 reads
A DMV a Day – Day 3
The DMV for Day 3 is sys.dm_os_sys_info, which is described by BOL as:
Returns a miscellaneous set of useful information about...
2010-04-03
1,052 reads
A DMV a Day – Day 2
The DMV for Day 2 is sys.dm_exec_sessions, which is described by BOL as:
Returns one row per authenticated session on SQL...
2010-04-02
401 reads
A DMV a Day – Day 1
Just as an experiment, I am going to post a different DMV query every day for the next 30 days. ...
2010-04-01
881 reads
Blogs
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
repeat results without loops, MSSQL2005 Express
hello everybody, new here and this is my first question I have a table...
how to write this query?
Hi everyone I am a bit stuck on how to write this query. Below...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers