I thought my database was collation agnostic
My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?
2018-06-08 (first published: 2016-01-14)
4,373 reads
Thomas Romeo
- Interests: Love being a dad and husband. Love to cook. Love to taste.
GUIDs GUIDs everywhere, but how is my data unique?
After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.
2014-12-18
8,659 reads
Blogs
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Daily Coping 3 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Forums
Installing missed items in SQL Server
Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...
Need to do it
Hi everyone! The inner world is very difficult, but you need to step over...
Redesign of old Table
Hi, I am working on an old database table which stores emails, including From,...
Ask SSC