Visual Studio 2010 Download Interruptus
Microsoft has made the RTM bits for the various versions and components of Visual Studio 2010 available on MSDN Subscribers...
2010-04-12
334 reads
Glenn Berry
A DMV a Day – Day 12
The DMV for Day 12 is sys.dm_db_partition_stats, which is described by BOL as:
Returns page and row-count information for every partition...
2010-04-12
843 reads
2010-04-11
1,576 reads
A DMV a Day – Day 10
Just in case you’ve just joined me, I decided on April 1 to post a different DMV query every day...
2010-04-10
1,826 reads
A DMV a Day – Day 9
The DMV for Day 9 is sys.dm_os_schedulers, which is described by BOL as:
Returns one row per scheduler in SQL Server...
2010-04-09
960 reads
A DMV a Day – Day 8
We have two related DMVs for Day 8. The first one is sys.dm_fts_active_catalogs, which is described by BOL as:
Returns information...
2010-04-08
1,249 reads
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,220 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
275 reads
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
572 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
853 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers