And, NO... don't create the Non-Clustered Indexes before hand.  I've never seen it work like MS says it "could" work.  Having Non-Clustered indexes will make it so that the transfer...

Hello Johan,

Thanks for your help.

I tried again to create a new column with VARCHAR(max) and to copy the data from the old column to the new column via a...

if insert is done in one...

Hi All,

Imagine a scenario where a datawarehouse database is working and, at the same time, limited disk space in our tempdb system database.

When any process runs that loads data...

You'd have better luck with the following search in your favorite search engine.  I didn't look at the specific articles themselves but I replaced the XXXXXXXXX with "mortgage", "automotive", and...

To Homebrew01:

I thought so too. And it does. But it releases the used space during restore. I need the mimic of the original database. You would think that restore...

Look up the DECIMAL DATATYPE IN SQL SERVER on your favorite search engine so that you'll understand that all you need to do is change the "scale" and maybe the...

Thanks Phils! But i really forgot to add an important point here what if the same emp for month 1 and month 3. Here 210 in M1 and M3.

That'll...

Hi,

Can someone please suggest, how this can be done?

I have a data region and date and Quantity. I want to display column(Region) and rows(Months) values as Quantity.

But when i...

I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by...

Do all of the files have a similar issue?  Perhaps you need to tweak the code to handle the anomalies.  Frederico offered a hint about that above.

And, no... they're...

Ah... there IS one major drawback.  If you have very wide tables with only a row or two per page and a lot of different columns get updated but only...

There's not much wrong with it at all.  It works the same way that I wrote such auditing in the past with it being "point-in-time" enabled.  It's nasty fast and...

My priorities have never changed... it's all based on the 3 "L's"...  I've not numbered them and their in no particular order because they each equally important to the others ...