Articles in MS SQL SERVER

Create CLR Stored Procedure with Visual Studio Express Edition

Create CLR Stored Procedure with Visual Studio Express edition

SQL Server Date Format Language

Perform a conversion in a select, view, and Stored Procedure.

Contained Databases in SQL Server 2012

Contained Databases have been an oft requested feature which has finally arrived in SQL Server 2012. In prior SQL Server versions, database were not 100% portable. In case you need to move a database from one server to another using backup and restore, the...

LLBLGen Pro feature highlights: assigning attributes based on rules to properties in generated code.

By FransBouma

(This post is part of a series of posts about features of theLLBLGen Prosystem)One of the things which makes some people hate generated code is that it's effectively 'read-only' code: changing it will make you run the risk that your changes are likely gone...

SQL Server Prefetch and Query Performance

By Fabiano Amorim

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries...

A first look at SQL Server 2012 Availability Group Wait Statistics

By Joe Sack

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize...