In our previous lesson we covered WITH ROLLUP and WITH CUBE. During that lesson you may have noticed that when we saw the summary rows, the columns had NULL as the value. Hopefully you wondered to yourself, how do I know programatically which of the rows are summary lines and which are rows that just…
Author: slowder
SQL 301 — WITH CUBE and ROLLUP
Have you been asked to summarize some data into a nice report for management? They want to see subtotals and grand totals you say? You don’t have to drop the results of your GROUP BY statement into a temp table, and summarize the subtotals yourself. The SQL ROLLUP and CUBE commands offer a valuable tool…
Sample Databases for SQL Azure
Ready to head into the clouds and try your hand at a version of SQL quite different from those you know today? Sign up for a SQL Azure account, then grab this sample database to start you off. It appears that Microsoft has finally explained why there is no performance clustering in their SQL product……
Sample Databases for SQL 2008
Now that many of us are upgrading to SQL 2008, we need a new sample database. If you’ve obtained a copy of SQL 2008 Developer Edition, if not, check out Amazon! I got my copy for $45! After you’ve obtained your copy, go to the link below and grab your sample databases! Reference: http://msftdbprodsamples.codeplex.com/releases/view/37109
Sample Databases for R2
..or as I call him, Ar-too. In case you haven’t heard, SQL 2008 R2 has been released as a preview. If you have downloaded it, and are looking for a sample database, codeplex has come to save the day. Hit the link below and you can download their latest sample database. Enjoy! Reference: http://msftdbprodsamples.codeplex.com/releases/view/24854
SQL Session – Execution Extract, Transform, and Load your Data Warehouse
If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
Surprise!!!!
Another year in the books. Time to take a break from the daily grind and go out into the world. I hereby declare this a holiday! On this day you should eat, drink, and be merry! Wait, that’s Christmas. OK, in that case, slack off, and have fun. How’s that? Play some video games, enjoy…
Another Year Older, But Am I Any Wiser?
A review of the past year. Have I learned any lessons…. we’ll see!
SQL Session – Execution Plan Caching and Reuse
If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
And Now For Something Completely Different
I’ve been debating what to do about my weight a lot lately. My doctor’s have always given me the helpful gems: “Eat healthier foods,” and “Go to the gym.” I know I have to do something about it. I’ve always tried diet and exercise, and always failed to become healthy. Sure, I could lose 10…