Here is a very interesting question asked on the blog by Karthik. I really liked the question and I would like to discuss this here about SSMS doe snot Print NULL values.
What Is a Star Schema?
A star schema is one fact table surrounded by dimension tables. What facts and dimensions hold, why grain is the decision you cannot undo, why the data repeats on purpose, and a worked example in AdventureWorksDW.
Subtotals and Grand Totals With ROLLUP and GROUPING SETS
Build region, product, and grand totals with ROLLUP, CUBE, and GROUPING SETS, then label subtotal rows and compare plans.
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT FORMAT Function
Basics of the CONVERT FORMAT Function in SQL 2012: compare FORMAT with the older CONVERT tricks and grab just the part of a date you need for reports.
SQL SERVER – Cycle Clipboard Ring in SSMS – SQL in Sixty Seconds #045 – Video
Copy and paste only gives you the last item you copied. This SQL in Sixty Seconds video shows how the Cycle Clipboard Ring in SSMS pastes earlier items too.
SQL SERVER – Beginning SQL 2012 – Spatial Unions and Collections
Aggregates are not just for sales totals. Much like a jigsaw puzzle, spatial unions assemble land coordinates together. Learn spatial unions and collections in SQL 2012.
SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1
Why we use code comments: SQL Server lets you keep words in a query window off the record, so they are ignored at run time. An abstract from Joes 2 Pros.