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,753 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
381 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
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers