This is one of those areas where there is no 100% right answer.  On the one hand you can't be pushing every random change someone wants through asap like it's...

Mike,

Ahh yes I see what you're saying about all the rows being returned. When I included multiple print orders it's including detail for all of print orders and not...

Just drop the AS 'Comp' from the subquery 🙂

And then there are the systems that REQUIRE specific versions of additional tools.  We had a warehousing tool that required Java 6 when Java 8 was the latest and greatest. ...

Not quite as ancient as some of the things mentioned but when i started getting into computers CRT's were the standard, USB wasn't a thing yet and floppy drives were...

You shouldn't need to declare any variables if you're pulling it out of a table, you'll just need to do some dateadds/string manipulation.

DECLARE @timestamp varchar(30) = '2021-11-01...

How much luck do you have actually getting people to fill it out?  Some places respect process more than others.

There's no magic number as how much log space each transaction uses will depend on how much log space each record needs to run the update.  And how much drive...

• This reply was modified 3 years, 10 months ago by ZZartin.

Well if the people you need to mask the data for are only using a view just mask the data in the view and give the people who need access...

Hmm.... i would say there's significantly more that goes into on prem vs cloud than just I don't care about the details of the hardware.

Don't worry I'm sure it's just for...

I would assume this is TDE. That's the native encryption.

If this is a response to regulation (PCI, SOX, etc.) , this really is what your auditor thinks. I would...

Well you could do two sets of replaces, so something like replace all the numbers with a letter first then replace all the letters with the new number 🙂

The application may be assuming that...

Well if it's just a matter of copying data truncate and reload is easier to set up and maintain, volume permitting.  Trying to capture deltas will but down on volume...