Can you post the solution for the code you posted?

I'm learning xml. I'm getting the hang of the nitty gritty, tags, elements, etc. I haven't come across the WHY except that it's "good for sharing across platforms." So...

@scott... the comment about "magic" wasn't meant as a slam to you.  It was meant as a slam to MS because they claim that you can do minimal logging if...

Not sure what you are getting...

Apologies on the mistake about COMPRESS.

I know you think that 2016 is magic after the first insert.  The documentation says that new pages will be minimally logged.  I'll have to...

A lot of that can be resolved by indexes in most cases.  In some cases, the indexes won't actually be...

Hello everyone!

I'm a beginner with databases and I'm getting started with building a front end for my database so that end users can add/edit data. I've been trying to...

Or how does the REBUILD over there interact with action thats happening on the server? from what ive been told its a very active table even at night when...

I'd also suggest using OPENQUERY instead of just EXECUTE.  Or, like you said, EXECUTE AT.

There's gotta be a way to read the manifest of files from a zip file in SSMS.  Almost everything else has that capability.

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...

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...