Viewing 15 posts - 136 through 150 (of 1,988 total)
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...
December 30, 2021 at 3:59 pm
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...
December 29, 2021 at 4:50 pm
Just drop the AS 'Comp' from the subquery 🙂
December 29, 2021 at 3:14 pm
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. ...
December 20, 2021 at 7:51 pm
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...
December 17, 2021 at 7:54 pm
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...
December 10, 2021 at 9:00 pm
How much luck do you have actually getting people to fill it out? Some places respect process more than others.
December 8, 2021 at 8:00 pm
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...
December 8, 2021 at 3:32 pm
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...
December 2, 2021 at 8:21 pm
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.
November 4, 2021 at 1:14 pm
While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀
Don't worry I'm sure it's just for...
October 25, 2021 at 6:13 pm
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...
October 22, 2021 at 5:20 pm
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 🙂
October 22, 2021 at 4:04 pm
Thanks Jeff. Will those connections have any negative performance on SQL Server or is it normal? What is the benefit that application would get?
The application may be assuming that...
October 12, 2021 at 3:12 pm
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...
October 8, 2021 at 2:33 pm
Viewing 15 posts - 136 through 150 (of 1,988 total)