2021-11-19
425 reads
Administration
2021-11-10
476 reads
2021-11-03
412 reads
2021-10-20
368 reads
Estimating Data Compression Savings in SQL Server
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
2021-10-08
SQL Server Diagnostic Memory Queries
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.
2021-10-04
2021-09-22
425 reads
2021-08-30
385 reads
2021-08-20
454 reads
The Slow Upgrade of SQL Server Versions
It seems that instances are being upgraded about every ten years, according to Steve's interpretation of some reports. Do you agree? Let us know how often you upgrade.
2021-08-16
285 reads
Blogs
SQL Homework – July 2022 – Update your resume.
Resumes have been on my mind a lot recently. I’ve been thinking that I...
A Blogging Break
By Steve Jones
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...
Daily Coping 5 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
(1) Sort rows with year column and month column == Jan, Feb, Mar, etc....
Designing a table
Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...
Multiple Fact Tables
Please assist? I would like to do a data model of the tables here:...
Ask SSC