Viewing 15 posts - 1,156 through 1,170 (of 59,071 total)
How to enable dynamic data masking for blob data?
I guess my question is, what have you tried? I see no limitations in the documentation for the likes of VARCHAR(MAX)...
September 6, 2023 at 7:09 pm
Now that's super interesting. Thanks for taking the time to explain all that, Frederico. I really appreciate it.
September 5, 2023 at 5:27 pm
To be honest, I've never needed the 32 bit version and so I've never tried to install it in parallel with the 64 bit version. That being said, you've piqued...
September 5, 2023 at 4:40 pm
Grmbl, the /quiet installationswitch workaround for installing Access Ace drivers 32 and 64-bit side-by-side seems to have stopped working.
That's not the intent of the "quiet" switch. The intent is...
September 5, 2023 at 4:00 pm
Also, for child tables in particular, the typical usage would be a seek and then a scan of contiguous rows. In those situations, any significant logical fragmentation COULD cause...
September 5, 2023 at 3:53 pm
With the exception of random but evenly distributed indexes, I wouldn't use logical fragmentation to determine if an index needs to be rebuilt. In the case mentioned,...
September 5, 2023 at 3:34 pm
I believe you'll find the following article quite interesting. To summarize, Paul White proves that the 5000 row thing is a bit of a myth that, according to him, no...
September 5, 2023 at 3:27 pm
Ah... almost forgot about another scenario that I ran into. Are the connections to the server setup to explicitly turn off/disable M.A.R.S. It they're not, they need to be. The...
September 5, 2023 at 3:11 pm
Thank you.
Not after the Index maintenance job. I check the queries that are consuming for years. They are not new o nes. I tried updating the stats & cleared...
September 5, 2023 at 2:58 pm
Logical fragmentation is seriously overrated as a concern. As Grant said, unless you can seriously prove that it's causing an issue, don't worry about it. I'm working on some articles...
September 5, 2023 at 2:49 pm
And don't forget the veterans that missed so many holidays nor the folks that are on active duty.
September 4, 2023 at 3:46 am
And, if the update is rolled back instead of being committed because the error was realized, then the second query has just returned incorrect information. 😛
September 4, 2023 at 3:43 am
My problem with Query Store and some of the people that use it is that, quite frequently, many of the plans (there's just 2 or there's more) are terrible. A...
September 4, 2023 at 3:35 am
Show me where in Table "A" that you have the value "DEF0002".
I think your example data for Table "A" is incorrect.
September 1, 2023 at 11:41 pm
There's a push to use NOLOCK on everything unless the users absolutely cannot deal with dirty reads because "it improves performance." ACK!
Sounds like it's time to...
September 1, 2023 at 11:05 pm
Viewing 15 posts - 1,156 through 1,170 (of 59,071 total)