A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,090 reads
Glenn Berry
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
975 reads
A DMV a Day – Day 19
The DMV for Day 19 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-19
2,051 reads
Goggle PowerMeter Update
As I have mentioned before, I have a TED 5000 electric power monitor installed in my house that monitors and...
2010-04-19
573 reads
Spring Planting 2010
Spring fever is running hot here in Parker, Colorado, after a long winter. Last year, I put in a Square...
2010-04-19
795 reads
SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)
Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this...
2010-04-19
1,079 reads
A DMV a Day – Day 18
The DMV for Day 18 is sys.dm_clr_tasks, which is described by BOL as:
Returns a row for all common language runtime...
2010-04-18
1,714 reads
A DMV a Day – Day 17
The DMV for Day 17 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-17
903 reads
A DMV a Day – Day 16
We have two DMVs for Day 16. The first one is sys.dm_exec_cached_plans, which is described by BOL as:
Returns a row...
2010-04-16
664 reads
A DMV a Day – Day 15
The DMV for Day 15 is sys.dm_os_performance_counters, which is described by BOL as:
Returns a row per performance counter maintained by...
2010-04-15
1,475 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers