Category Archives: SQL Server

SQL Server

When To Use NVARCHAR

Posted on September 9, 2011 by Melinda Cole

The Short Answer Only when you need to store multi-lingual (unicode) data.  The Nitty Gritty The fundamental unit of storage in a SQL Server database is an 8 KB page.  To paraphrase the MSDN, SQL Server reads and writes whole … Continue reading →

Posted in SQL Server | Tagged , , , , , , | Comments Off on When To Use NVARCHAR

How to Generate Insert Scripts for Existing Data

Posted on April 4, 2011 by Melinda Cole

Let’s say you have a bunch of data stored in a table and you need to generate an insert script for each record. Maybe you need to save the scripts in source control or maybe you need the scripts to … Continue reading →

Posted in SQL Server, SSMS | Tagged , , | Comments Off on How to Generate Insert Scripts for Existing Data

SQL Server 2005 Installation Failures

Posted on June 24, 2010 by Melinda Cole

Recently I was trying to install SQL Server 2005 on a workstation running Windows XP Professional SP3 and for some reason the installation kept failing. The first item in the list that failed was MSXML 6.0. After combing through the … Continue reading →

Posted in SQL Server | Tagged , , , | Comments Off on SQL Server 2005 Installation Failures