I would manually update the file from a folder, and this list of tables won't change. The alert will run daily maybe every x hours..

We had an issue where...

I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX) column.  However, it is stripping the carriage returns and line feeds out, so when I...

Heh... all of this reminds me of the great "Toilet Paper" debate... Unroll from the top or the bottom?  Of course, there are people like me that prefer a vertical...

I STRONGLY second the notion that index maintenance on rowstore indexes is pretty useless if based on logical fragmentation.  I'll also tell you that it can cause major blocking on...

Thanks, Steve.  I've been doing that same thing for years to create "character usage histograms" using either a Tally Table or fnTally.  So has Itzik with his "GetNums"...

If you do a shrink, make sure that you do a check on fragmentation both...

@hmbacon

I apologize... that last post slipped right past me.  I know it's been a couple of months but thank you for the feedback on the ISO algorithm.  Also, I thought...

It's always a pain.  Have you considered investing in something like "SQL Clone" from RedGate?

Redgate also has tools to help you modify PII so that it's no longer PII... it'll...

Tom Uellner ,

If you're still around, do you have any links on the subject at hand?

Thanks, Grant.  I remember you speaking of Brad's input on the subject before.  I've not found it, yet, either.

I realize this thread is a couple of years old now but, I have to ask the question, can either of you share some links to articles where someone states...

Wholesale table change or only things that have changed?

Either way, I'd explore the possibility of a BCP OUT...

Heh... another "metric" that I'm really sick and tired of is "index fragmentation", especially when it comes to 3rd party vendors, both good and bad.  You call them and ask...

Hello Jeff ,

thanks but i suggested to consider not to create directly. as i don't see the plan, I suggested based on the data column he pulled.

I never created...

I strongly recommend against the use of Reorganize.  It simply doesn't do...