At SQL Server Geeks 2015 - Pre Conference Session - Benjamin Nevarez
Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at...
2015-08-31
1,277 reads
SQL and SQL Only
Query cost and Query Execution time - Difference
This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....
2015-08-25
1,477 reads
Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table
Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...
2015-08-18 (first published: 2015-08-14)
2,932 reads
Hekaton Part 3: Table Creation and Parameters
Part of a Series on "Hekaton". Refer below for previous posts
Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...
2015-08-13
598 reads
Hekaton - Creating a Database :- 2
With a Gentle intro done on Hekaton - In Memory tables, let us continue exploring further. Today, we will quickly create a database...
2015-08-06
546 reads
Hekaton - In Memory OLTP - Getting Started / FAQ :- 1
SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...
2015-08-04
1,080 reads
Detach and Attach All User Databases
Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...
2015-05-29
1,077 reads
DDL Auditing - Article on SQL Server Central
My article on SQL Server Auditing has been published on www.SQLServerCentral.Com. Article discusses how default trace can be used effectively...
2015-05-22
598 reads
How to Size the SQL Server Memory & Why is it important?
The following blog post has 2 objectives.
 1) How to size the memory correctly ( or atleast being close to correctly )
 2)...
2013-05-27
2,905 reads
Xp_readerrorlog in SQL Server 2012
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,492 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Missing the Jaro Winkler Distance
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me
Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...
Doing Good at SQL Server Central
Comments posted to this topic are about the item Doing Good at SQL Server...
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