Tag Archives: sql

Comparing SQL Databases for Differences in Objects

Like the real world, development practices keep changing so when I find development code that can make my life easier I want to save it for future use. In this …

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

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