At http://www.sqlbi.com/%5B/url%5D you can download a TableDifference component for free. It is essentially a MERGE JOIN and a Conditional Split in a single component. It will allow you...

Not that I would go through the work, but you could make the sub-totals an actual sub report. The excel export will not export the sub report (although it...

I have written small web application to do just this. It is worth creating an application that you can control a bit better than giving someone access to the...

A lot of factors will determine if it will help, hurt, or do nothing.

However, it is not going to wander far into the better or worse category, so I would...

Table partitioning would move partitioned records onto different pages, so if you are getting deadlocks because of page locks, it is possible that partitioning may help, but it is pretty...

Are the services there and running?

My first guess would be you installed the server components and did not install the client components.

I guess I would like to see some relatively simple, expandable tools included.

For example, a good Service Broker example is needed. So, a small windows application that displays jobs...

It is part of the ANSI standard to ignore these trailing spaces. It is done automatically in joins as well. If you find yourself in a situation in...

A view is just a stored query. They are cached and perform the same as if you just ran the query itself unless you have schema-bound and indexed it.

So,...

So you have type-2 SCD attributes on your snowflaked dimension, but you want the snowflake attribute to basically be a type-1 SCD.

Since your Product dimension has a CustomerKey, if you...

It is generally used for dealing with concurrency. It is not a date, but it is automatically changed each time a record is updated. So, a method of...

Ok, I have to ask, what possible method of tracking changes could you be using that would be impacted by when a checkpoint happens?

Simple recovery does not just checkpoint when a backup is taken. Simple recovery mode really moves the pointer in the log file to the beginning of the file (effectively...

Subtract the day of the week from the current date and then add the number of days from the beginning of the week to the day you want. Assuming...

As I look more carefully at Grant's solution, it is determining that the field changed in one of the application layers (setting the value to NULL if it has not...