OK, I like the new house you've built.  Let's move the front door to the front of the building.

And we're going to need a basement.

I find PowerQuery handy. It's an Excel add-in from Microsoft. It can read SQL Server, SharePoint, flat files, web services, even FaceBook.

I go to this thread more than any other. There is not only good information on posting to forums, but I find the techniques in here useful in my...

Excellent article, Chuck. I went from zero knowledge in this to being confident I can apply boolean logic without a long list of case statements. Very well written.

Well written article. Thanks.:hehe:

Amazing you can accomplish that much with so few SQL statements.;-)

It's also easier to put invalid data in a denormalized database or one that lacks proper declarative referential integrity.

Lynn,

Thanks for that post. It made me realize how I can improve some of my own queries.

The light came on.

This is a fantastic thread.

Also two where clauses. Fixed the two duplicates, but still have a page of error messages.

Thordog, very nice addition. I added holiday_name to it.

In SQL 2008 I right click the database name in Object Explorer, select Reports / Standard Report / Disk Usage by Table.

Good article. I've learned a lot of useful tricks in this series.

One question: You said, "– download the updated project using the link at the end of this...

This could be handy. It'll freak some folks out, too. :w00t:

Excellent.

I agree with the suggestions on picking up the First Day of Week from the SQL Server settings. It's got everything except phases of the moons and high-tide /...

I created my FIRST Cursor yesterday. I had to read up on how to do it. It was obvious this was creating a RBAR process as I...