Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,595 reads
Kenneth Fisher
Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,522 reads
The amazing never shrinking heap
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
615 reads
Two years!
Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...
2014-08-20
946 reads
More than sp_help
If you have worked with SQL Server for very long you have probably run across the extremely useful system function...
2014-08-14
1,499 reads
Deny vs Revoke
Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE
Well lets start with some definitions
GRANT – Grants permissions on...
2014-08-12 (first published: 2014-08-04)
8,525 reads
T-SQL Tuesday #57: SQL Family
This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing...
2014-08-12
590 reads
The clustered index columns are in all of the non clustered indexes.
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...
2014-08-07 (first published: 2014-07-30)
9,430 reads
SchemaBinding – What & Why
What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...
2014-08-06
1,123 reads
What is ANSI_NULLS and why will I be glad when it finally goes away?
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,364 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