Category Archives: T-SQL
-
Connect suggestion to add included columns to sp_helpindex
1January 10, 2017 by Kenneth Fisher
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the …
Continue reading -
sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Leave a commentDecember 28, 2016 by Kenneth Fisher
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
Continue reading -
sp_helptext vs object_definition()
4December 21, 2016 by Kenneth Fisher
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I …
Continue reading -
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 -
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 -
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 -
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 -
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 