How To Get Table Row Counts Quickly And Painlessly
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
2011-01-28 (first published: 2009-09-02)
57,767 reads
Articles
31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-28
2,863 reads
Internals and Performance class in Dallas
At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...
2011-01-28
2,054 reads
Showplan Operator of the Week - Merge Interval
When Fabiano agreed to undertake the epic task of describing each showplan operator, none of us quite predicted the interesting ways that the series helps to understand how the query optimizer works. With the Merge Interval, Fabiano comes up with some insights about the way that the Query optimizer handles overlapping ranges efficiently.
2011-01-28
3,071 reads
Master Immersion Events from SQLskills.com
A new series of courses is available from SQLskills to help you better learn to manage and tune your SQL Server instances. These classes are designed to help you complete the MCM certification, but are also valuable for anyone that wants to become a better SQL Server DBA.
2011-01-27 (first published: 2011-01-10)
2,059 reads
SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups
The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore
2011-01-27 (first published: 2011-01-18)
1,921 reads
31 Days of SSIS – Data Flow Expressions (22/31)
31 Days of SSIS
Today, we continue on with the 31 Days of SSIS blog series. Yesterday’s post was on the...
2011-01-27
2,042 reads
Connect to a SQL Azure Database Using SSMS or SQLCMD
Learn how you can connect to a SQL Azure database.
2011-01-27
1,945 reads
DBA 101: Why is my log file full?
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-27
3,653 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-26
5,455 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...
Forums
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...
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
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