Tag Archives: 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

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