SQL Server 2012 Diagnostic Information Queries (Feb 2013)
Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-02-01
1,000 reads
Glenn Berry
SQL Server 2008 Service Pack 3 Cumulative Update 9
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 9, which is build 10.00.5829. As you might expect...
2013-01-25
1,565 reads
SQL Server 2008 Diagnostic Information Queries (Jan 2013)
Here is the January 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
882 reads
SQL Server 2012 Diagnostic Information Queries (Jan 2013)
Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
902 reads
2012 Blog Statistics in Review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
About 55,000 tourists visit Liechtenstein every...
2012-12-31
1,480 reads
SQL Server 2012 Standard Edition Licensing Limits
As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be...
2012-12-29
7,462 reads
SQL Server 2012 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-28
986 reads
SQL Server 2008 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-18
1,070 reads
SQL Server 2008 R2 SP2 Cumulative Update 4
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 4, which is Build 10.50.4270. I count 34...
2012-12-18
2,836 reads
SQL Server 2012 Cumulative Update 5
Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public...
2012-12-18
1,840 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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...
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