Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 59,065 total)

Reply To: DDM for blob

@Everyone...
Any help here on this question? I've not used DDM and so I'm only able to shoot from the hip based on what the documentation says.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 7, 2023 at 3:39 am

#4281184
Reply To: DDM for blob

Again, I've not used DDM but, according to the documentation, it looks like the only function that will work with the IMAGE datatype is the DEFAULT function.
As for backups and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 7, 2023 at 3:38 am

#4281183
Reply To: High CPU & blocking

The only thing that I can guess is either connection leaks or memory leaks cause by the application(s).
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 7, 2023 at 3:25 am

#4281166
Reply To: DDM for blob

ramana3327 wrote:
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)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 6, 2023 at 7:09 pm

#4280936
Reply To: Are the posted questions getting worse?

Now that's super interesting. Thanks for taking the time to explain all that, Frederico. I really appreciate it.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 5:27 pm

#4279994
Reply To: Are the posted questions getting worse?

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 4:40 pm

#4279969
Reply To: Are the posted questions getting worse?

Jo Pattyn wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 4:00 pm

#4279940
Reply To: Multicolumn indexes and fragmentation

ScottPletcher wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 3:53 pm

#4279939
Reply To: Multicolumn indexes and fragmentation

ScottPletcher wrote:
Jeff Moden wrote:
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,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 3:34 pm

#4279937
Reply To: Trying to understand lock escalation behavior

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 3:27 pm

#4279928
Reply To: High CPU & blocking

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 3:11 pm

#4279925
Reply To: High CPU & blocking

ramana3327 wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 2:58 pm

#4279921
Reply To: Multicolumn indexes and fragmentation

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 5, 2023 at 2:49 pm

#4279920
Reply To: Labor Day 2023

And don't forget the veterans that missed so many holidays nor the folks that are on active duty.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 4, 2023 at 3:46 am

#4278949
Reply To: The Isolation Level Across Databases

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. 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 4, 2023 at 3:43 am

#4278948

Viewing 15 posts - 1,156 through 1,170 (of 59,065 total)