Monthly Archives: March 2018
-
What’s the difference between Files and Filegroups?
2March 28, 2018 by Kenneth Fisher
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
Continue reading -
Introducing The Blame Game
4March 26, 2018 by Kenneth Fisher
Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing …
Continue reading -
Moving a table using BCP and native format
8March 21, 2018 by Kenneth Fisher
You need to move a table from one instance to another with the following requirements: The instances are on separate …
Continue reading -
GDPR – After the restore
1March 19, 2018 by Kenneth Fisher
I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
Continue reading -
DB_NAME() vs ORIGINAL_DB_NAME()
1March 15, 2018 by Kenneth Fisher
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
Continue reading -
A look back from the future. – TSQL Tuesday #100
3March 13, 2018 by Kenneth Fisher
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact …
Continue reading -
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading -
SQL Homework – March 2018 – Recovery Objectives
1March 5, 2018 by Kenneth Fisher
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
Continue reading
SQL Studies 