SQL Server : Index Part 3 :Explaining the Clustered Table Structure
In SQL server, there are two types of table based on the storage.A table with clustered index is called Clustered...
2013-03-12
2,856 reads
PracticalSQLDba
SQL Server : Understanding the IAM Page
In my earlier post, we have discussed about Data,GAM,SGAMand PFS pages. In this post, let us try to understand about...
2013-03-07
7,841 reads
SSRS: Report Server Usage Report
While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand...
2013-03-06
2,529 reads
SQL Server : Index Part 2 : Structure of Heap Tables
In the earlier post we tried to understand the difference between a table having clustered index and does not have a clustered...
2013-03-06
2,194 reads
Windows Server 2008 Cluster: Understanding the Cluster Log Behavior
In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...
2012-10-17
1,029 reads
SQL Server : Index Part 1 : Basics of index
While conducting interviews , I have noticed that, many people does not have clear picture about index.Many of them does not...
2012-10-11
1,370 reads
SQL Server:Understanding The Page Free Space (PFS) Page
In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...
2012-10-10
6,384 reads
SQL Server: Sending Email in HTML Table Format Using TSQL
As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about...
2012-10-04
1,505 reads
SQL Server : Setting up Server Side Trace
For a DBA, SQL profiler is a great tool to trouble shoot performance issues. It is a pain to configure...
2012-10-02
1,282 reads
SQL SERVER : How to List All Email Subscription configured in SSRS ?
Often I used to get request from my business managers to get a list of all subscriptions configured in SSRS...
2012-09-27
14,685 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
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