SQL RNNR

Blog Post

Blackout

What more can I say.  I disagree with the kind of legislation that is being presented via SOPA and PIPA. In support of the community, my site will be...

2012-01-18

Blog Post

A Trio of Functions

I found myself perusing an execution plan the other day.  I know, big surprise there.  This execution plan showed me some interesting things I had never really paid much...

2012-01-17

1 reads

Blog Post

Meme15 Twitter

Twitter and Your Career With the new blog party on the block, we have Jason Strate (blog | twitter) asking us this month these two questions: Why should average...

2012-01-16

1 reads

Blog Post

Missing Indexes

SQL Server has means built into it to track possible missing indexes.  This used to be found through the use of the Index Tuning Wizard.  The process has improved...

2012-01-12

Blogs

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...

Free Online Sessions – Building the €100 DWH and Indexing for Dummies

By

I’m giving two online sessions soon on virtual events that are free to attend....

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