Reblog: December 28 to January 3

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

Row of nonclustered index page

Below is the formula of calculating the row size of non-clustered index page

so unique non-clustered index created on unique clustered index use smallest...

Speaking at SQL Saturday #183 – Albuquerque

I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first...

SQL Server Contracting and Business Network Wales - LinkedIn Groups Updates

I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...

SSRS #73 – Use Calculated Field to Dynamically Set Default for Parameters

Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface...

T-SQL Tuesday #38 – Standing Firm

Introduction
Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community.  This is the...

What happen, If SQL Server new instance try to use exitsing named instance name?

We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...

When is a whitespace not a whitespace ?

As I'm sure I must have mentioned in the past, I’m presently involved in a large ALM project at a...

A Rickety Stairway to SQL Server Data Mining, Part 0.2: How to Dig Out of a Data Mining Cave-In

         This third part in my series of self-tutorials in SQL Server Data Mining (SSDM) was delayed for several weeks due...

Checking the Instance Fill Factor

I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill...