Partitioning on a nullable column
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,061 reads
SQLStudies
Simple Security Report
Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...
2017-05-12 (first published: 2017-05-01)
2,274 reads
Why is a Windows authenticated login more secure than a SQL authenticated one?
I had this question come up at work the other day and while I knew it was true I wasn’t...
2017-05-08 (first published: 2017-04-26)
3,761 reads
SSMS Tips: Copy Full Path
When you right click on a tab you’ll see a number of different options. You can set up new horizontal...
2017-04-24
382 reads
When should I add an index?
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...
2017-04-21 (first published: 2017-04-19)
2,860 reads
What is the “cost” in Cost Threshold for Parallelism?
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
508 reads
No space queries
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...
2017-04-13
383 reads
The more things change, the more they stay the same
Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other...
2017-04-11
480 reads
How do I change the increment of an identity column?
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
486 reads
Hiding tables in SSMS Object Explorer
Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...
2017-04-03
503 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