SQLServerCentral Article

NULL Column Analysis

NULL values in columns can indicate a few things, the value isn't known, it's not yet been filled in, or perhaps, as Leo Peysakhovich argues, the column isn't being used? How many SQL Server tables do you have with extra tables and columns that are not being used? Or maybe never have been? This article looks at a statistical analysis of columns using NULLs to determine if you might be able to remove certain columns.

SQLServerCentral Article

Win One of 5 XBOXs!!!!

By now everyone should have heard about the PASS 2004 Summit in Orlando this September. Hopefully you are also aware that SQLServerCentral.com is one of the sponsors for this event and to make it a bit special, we're putting on a reception for everyone that registers for PASS with our promotion code. Read on to see what we've got planned!

Technical Article

Into Fantasy Football? Join the SQLServerCentral.com League.

If you're into fantasy football, come waste some time with us and join our free league at Yahoo. Read the below instructions on how to join. Space is limitted in the first league to 12 teams so join quickly and the draft starts Tuesday! If it's popular, we'll create other leagues.


In order to join the league, just go to http://football.fantasysports.yahoo.com/f1,
click the "Sign Up Now" or "Get Another Team" button and
follow the links to "Join a Custom League". When prompted,
enter the League ID# and password below.

League ID#: 525071

Password: ssc

Blogs

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Picking a Starting Table in Test Data Manager

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

SQL Server Migration Using a Distributed Availability Group

By

SQL Server migrations are a headache, ask anyone who’s been through the pain of...

Read the latest Blogs

Forums

Introduction to PostgreSQL for the data professional

By Site Owners

Comments posted to this topic are about the item Introduction to PostgreSQL for the...

what happens to ssis and ssrs whenb we migrate to sql saas

By stan

Hi we know (or believe)  ssas saas gets stood up separately when a company...

"External table is not in the expected format"

By Reh23

Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...

Visit the forum

Question of the Day

CHOOSing an Alias

I have this code:

SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x
FROM ProductSales;
What is a good name for the column alias?

See possible answers