Tag Archives: microsoft sql server
-
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 -
:OUT :OUT darn results!
3December 19, 2016 by Kenneth Fisher
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the …
Continue reading -
DBA Myths: You can only restore one differential backup
4December 13, 2016 by Kenneth Fisher
Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share. The …
Continue reading -
Fixing Data Migration Assistant timeouts
2December 8, 2016 by Kenneth Fisher
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the …
Continue reading -
TSQL Tuesday #85 Invite – Backup and Recovery
40December 6, 2016 by Kenneth Fisher
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
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 -
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
SQL Studies 