Category Archives: SQL Server

SQL Server

When To Use NVARCHAR

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

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

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