SQL RNNR

Blog Post

On the Sixth Day…

What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras?  No animals have...

2012-12-24 (first published: )

1,704 reads

Blog Post

On the Sixth Day…

What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras?  No animals have been hurt in the making of this post! This...

2012-12-18

Blog Post

On the Fifth Day…

Today we will have a quick change of pace.  This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...

2012-12-17

1 reads

Blog Post

On the Fourth Day…

We have come to the fourth day in this mini-series.  So far I have laid down some under-carriage maintenance for one of our favorite databases.  That database being the...

2012-12-16

Blog Post

On the Third Day…

Mais Oui! But of course, we must have some french hens for today!  Today we have the third day of pre-Christmas.  And as was mentioned we have more undercarriage...

2012-12-15

1 reads

Blogs

A New Word: Anderance

By

anderance – n. the awareness that your partner perceives the relationship from a totally...

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Read the latest Blogs

Forums

The Security of Old Tech

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Security of Old Tech

Revisiting SQL Server Window Functions- A Practical Walkthrough

By Chandan Shukla

Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...

Tables with a SPARSE Column and Consumption

By dbakevlar

Comments posted to this topic are about the item Tables with a SPARSE Column...

Visit the forum

Question of the Day

Tables with a SPARSE Column and Consumption

True or False:  Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.

See possible answers