-
It greatly pleases me to announce, HAL0003!
27November 23, 2016 by Kenneth Fisher
I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal …
Continue reading -
Reload a table quickly.
6November 21, 2016 by Kenneth Fisher
Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. …
Continue reading -
SQLSkills waits and latches library
2November 16, 2016 by Kenneth Fisher
SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails …
Continue reading -
When was my index created or at least last updated?
1November 14, 2016 by Kenneth Fisher
SQL Server stores a create date and a change date for each object in the sys.objects system view. Unfortunately while …
Continue reading -
Is it safe to grant Administer Bulk Operations?
4November 10, 2016 by Kenneth Fisher
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are …
Continue reading -
TSQL Tuesday #84: Zip to Speaker
1November 8, 2016 by Kenneth Fisher
Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t) …
Continue reading -
New indexes, hypothetically
1November 2, 2016 by Kenneth Fisher
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought …
Continue reading -
The Halloween Problem
8October 31, 2016 by Kenneth Fisher
DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me! Ok, so that’s …
Continue reading -
It’s a small world
2October 26, 2016 by Kenneth Fisher
As I write this we are packing to leave for Disney World, where my family and I will spend close …
Continue reading -
Synchronous vs Asynchronous
4October 24, 2016 by Kenneth Fisher
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 