I have a database with no compression on the tables(source).  I want to create a blank database(destination) where I can create the tables with "data_compression = Page" and then...

Thom is mostly right in that "It Depends" on the company but let...

Could it be something in the firewall between the zones? Maybe a max connection time? Or perhaps, for some reason, it's seeing the connection as idle and dropping it?

Sorry...

Awesome Jeff Moden...but not enough ....I did not know I could post here and also expect an answer and then give it back to the interviewer all at...

p.s.  Also, remember that the answer is always "No" unless you ask.  If you don't have an "IN" with the infrastructure team or the people holding the purse, also remember...

The best thing we ever invested in is Our DR test server - regular automated restore tests and also re-usable as a data playpen - i'm hoping to get...

Table triggers will kill your performance and are generally frowned upon. If your database is small and your users are few it won't matter, but this isn't a scalable...

Awesome Jeff Moden...but not enough ....I did not know I could post here and also expect an answer and then give it back to the interviewer all at the...

My apologies.  I normally don't associate the term "ETL" with moving data between databases even when one may be a source and another is a data warehouse.  I normally associate...

Thank you for the response. So basically I can create a .NET application to provide additional functionality, but reading headers and splitting as you’ve suggested . Then I can...

Let's do the math here... you say "100's of servers".  If each server only had 4 core, and "100's of servers" meant at least 200, that would be 800 core. ...

So read the header row from your data, split it, and compare it to your table columns.  If they're not named the same, then you'll need a mapping table to...

The cool part about threads like this is that no one is actually incorrect.  There are pros and cons on both sides and it might even be appropriate to use...

Absolutely and all fair points, but until SQL Server finally supports the "occurence" argument as Oracle has for a while in its INSTR function, I'll use this as a...

I agree with Grant and Mike.  I would especially agree with Grant about troubleshooting code being part of the tasks of the DBA of the future but that is and...