Jeff Moden

Forum Replies Created

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

Reply To: Are the posted questions getting worse?

below86 wrote:
Jeff Moden wrote:
It's not the "last post" that doesn't show up. It's the first post on a new page. It's been a problem for a very long time just like...
--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 8, 2023 at 7:20 pm

#4282666
Reply To: when execute multi query on same time on sql serv using threading get error 40 ?

Heh... you were right, Phil.
--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 11:28 pm

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

It's not the "last post" that doesn't show up. It's the first post on a new page. It's been a problem for a very long time just like the spam...
--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 11:24 pm

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

On a personal note, I just don't understand companies that post a webinar and, to register, they REQUIRE you have to provide your phone number and, frequently, a lot more...
--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 6:17 pm

#4281808
Reply To: when execute multi query on same time on sql serv using threading get error 40 ?

Maybe it's something wrong with FireFox but I see no "stack trace" in the original post.
--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 4:17 pm

#4281757
Reply To: Downlevel CE

Please check the trace flags in the server startup. There is a trace flag that can be set to force the old CE to be used and someone may have...
--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 4:07 pm

#4281754
Reply To: Trying to understand lock escalation behavior

vsamantha35 wrote:
Thank you Sir. will go through Paul White's blogs.
You bet, Sam... let us know how it turns out, please.
--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:40 am

#4281185
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

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