Category Archives: SQLServerPedia Syndication
-
Using OUTPUT with a field list.
2November 30, 2016 by Kenneth Fisher
I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a …
Continue reading -
Easy to read CHECKDB
9November 28, 2016 by Kenneth Fisher
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC …
Continue reading -
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 -
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 -
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 -
Installing SQLCMD
2October 19, 2016 by Kenneth Fisher
For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says …
Continue reading
SQL Studies 