Tag Archives: sql

Create Comma Separated List in SQL Server

Assume for a minute that you have a table with records that you want to quickly put into a comma separated file (fig. 1). You don’t want to create a …

Tags: , , , , , , , , | Posted under ASP .NET 4.0, Programming/Coding | Leave a comment

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