-
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101
1April 10, 2018 by Kenneth Fisher
Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
Continue reading -
SSMS’s Dark Theme
5April 4, 2018 by Kenneth Fisher
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
Continue reading -
SQL Homework – April 2018 – Indexes
Leave a commentApril 2, 2018 by Kenneth Fisher
This month we are going to look at a topic near and dear to both database developers and database administrators …
Continue reading -
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
SQL Studies
Live, Learn, Share
SQL Studies 