Performance Tuning Using Free Tools
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2021-12-17
6,079 reads
database performance
A simple use case for Columnstore Indexes in SQL Server
In this article we look at different use cases for columnstore indexes like when performing SQL Server count * queries.
2020-01-17
2019-10-28
6,339 reads
Blogs
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Forums
SQL help with partition
With the following data, I need to create a column that will display a...
How can I show the last opening period for each project in my project dimension
I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...
Upgrading from 2016 to 2019 with Encryption
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
Ask SSC