For one thing indexes on SQL server do not get 'degenerated'. They can suffer from excessive fragmentation or even just plain worthlessness.

Since indexes in SQl server are implemented as...

The fastest way without using bulk insert is to drop any indexes/foreign keys in the destination tables then use insert select from source tables directly. Re create the indexes anf...

Consider that the posters who ask these "homework" or exam questions on here desire to be the DBA experts of tomorrow. Having someone else do you homework is not going...

I would tend to think so. The only other way I can think of off hand is to do two JOINS to the table to check for each case like:

SELECT

T.cat,

T.subcat,

isnull(X.code,...

See if this works for you:

SELECT

T.cat,

T.subcat,

isnull(X.code, case when X.cat is NULL then NULL else DEFAULT end) as code

FROM @test-2 AS T

LEFT JOIN @conversion AS X

ON T.cat = X.cat

AND T.subcat =...

I am not 100% sure what you are trying to do but I'll take a stab as saying I think you mean to do this:

JOIN InventTrans ...

One other piece of advice: Columns that should always contain data should not be NULLable. Reseve NULL columns only for those that may legitimately have no value.

You will learn to...

When importing, a new line sequence means a new row. Try stripping the new lines out of any individual columns in your file.

Any foreign keys referencing the table will result in extra reads before the delete.

2008 does away with the built in local administrators group. Being a domain admin no longer gives you automatic access to SQl Server as in earlier versions.

The query is joining tables from different servers. Somehow the context between the different threads of the query is not available when executed as a function (remember that some of...

Anything is possible.

I think that if you changed this:

SELECT [CP Code],

SUM(CASE WHEN StartDate = '2010-06-27' THEN TotalPageviews ELSE 0 END) AS [2010-06-27],

SUM(CASE WHEN StartDate = '2010-07-04' THEN TotalPageviews ELSE 0 END) AS...

The only way you could come up with precise numbers is to do some simulations and/or benchmarking. Having said that, the methodology will produce results better than a guess,...

If you are asking for a specific reference I don't have one off the top of my head head, I'm sure they are out there.

What I do is gather the...