Tag Archives: sql

Analyzing SQL Tables for Defragmented Issues

Every once in a while it is a good idea to re-index / re-organize your SQL server tables, but if you are having a problem with a particular table then …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment

Simple Way to Backup SQL Server 2012

Although there is many ways to backup a SQL Server Database the script below is one that I use quite a lot. If you do not put a drive letter …

Tags: , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Finding all SQL Table References in a Database

Managing SQL server objects can sometimes be quite challenging. With tables references used in over 40 different object types, locating and isolating one particular table can be time consuming. The …

Tags: , , , , , , , | Posted under Programming/Coding | Leave a comment