Wait Time - Query\Client
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,529 reads
Administration
2011-10-04
2,483 reads
2011-09-29
2,553 reads
Database Files Physical Location
Displaying the SQL Database names and its associated files in the System drives in which the files are stored / mapped.
2011-11-11 (first published: 2011-09-27)
1,171 reads
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
2011-09-01
7,932 reads
2011-08-29
2,197 reads
2011-08-25
2,476 reads
2011-08-23
2,781 reads
2011-08-19
2,829 reads
Total Database Information At Your Fingertips Part I
This article will help to get some basic information from your databases that may help you in different situations.
2011-08-16
9,294 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