Is there a specific reason SQL Server has to have the same bitness as MS Office?

You should be able to install multiple instances of Express.

I don't see how you would...

My general opinion on the SO moderators is that they are a bunch of twats.

It's probably just a few rotten apples with a big ego, but they ruin it for...

Always funny to see what you categorize as a "short" article Jeff 😀

It's a great one though and I'm sure I'll refer to it soon in the future when I...

In some aspects an OLTP database and a data warehouse are much alike: indexes and statistics need to be maintained, queries must be fast et cetera.

There are important differences though:...

Grant Fritchey (1/23/2014)

rodjkidd (1/23/2014)

He He - I know - can we turn the internet...

WHAT HAVE YOU DONE?!?

Why...

You could add a row number (using a script component) to both flows and then use the MERGE JOIN component.

SQL 2008R2 supports backup compression:

Log Shipping Transaction Log Backup Settings

I guess this is an Oracle query?

In SQL Server you need to use the ROW_NUMBER function and sort in the OVER clause.

In an outer query you can select the row...

Noooooooooo.

You have two settings: the incremental steps at...

Minimize log file growth? Do less stuff on your database. (you...

By giving (GRANT/DENY or adding them to roles) the appropriate permissions to people?

For example, you can add people to the DDL_ADMIN role if you want them to execute DDL.

If you...

Probablly the way how those browsers interprete the HTML/CSS code.

You can either use try/catch or check with a CASE statement if @datediff1 is 0. If it is, don't do the division and return 0, if it isn't do the...