Tag Archives: T-SQL
-
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 -
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 -
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 -
Using Snippets
Leave a commentOctober 17, 2016 by Kenneth Fisher
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
Continue reading -
Too many indexes!
6October 13, 2016 by Kenneth Fisher
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work …
Continue reading -
Floor, Round, and Ceiling
5October 5, 2016 by Kenneth Fisher
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that …
Continue reading -
A quick fix for a full identity column.
2September 21, 2016 by Kenneth Fisher
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following: …
Continue reading -
Using an ORDER BY in a view
27September 19, 2016 by Kenneth Fisher
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is …
Continue reading
SQL Studies 