Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 59,067 total)

Reply To: blocking issue

Grant Fritchey wrote:
Ha! I may have overly played up the "scary" part of the scarydba occasionally.
I apologize. I didn't intend to embarrass, my dear ol' friend.
--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)

February 9, 2023 at 4:01 am

#4147341
Reply To: how to make a col in a table after checking its existence, in one stmt
Using your code as a model, you can make it a bit shorter...
```
    IF COL_LENGTH('dbo.abc', 'r1') IS NULL
  EXEC ('ALTER TABLE abc ADD...
```
--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)
February 9, 2023 at 1:16 am

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

Michael L John wrote:
Jeff Moden wrote:
Michael L John wrote:
frederico_fonseca wrote:
Jeff Moden wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
David Burrows wrote:
Jeff Moden wrote:
David Burrows wrote:
That’s why I like you Jeff, you’re such a smart guy 😍🥳
Heh... if I were really smart, I'd just up...
--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)

February 8, 2023 at 6:40 pm

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

Michael L John wrote:
frederico_fonseca wrote:
Jeff Moden wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
David Burrows wrote:
Jeff Moden wrote:
David Burrows wrote:
That’s why I like you Jeff, you’re such a smart guy 😍🥳
Heh... if I were really smart, I'd just up and retire. ...
--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)

February 8, 2023 at 6:30 pm

#4147236
Reply To: blocking issue

Post deleted.
--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)

February 8, 2023 at 4:46 pm

#4147202
Reply To: Backing up a damaged database

Steve Jones - SSC Editor wrote:
typing while not thinking. This is fixed. The no_truncate option is needed
None of us has ever done that before, right? 😀 😀 😀 Thanks, Steve.
--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)

February 8, 2023 at 4:30 pm

#4147193
Reply To: Are the posted questions getting worse?
Phil Parkin wrote:
Brandie Tarvin wrote:
Forget leading commas. Let's debate leading semi-colons. @=)
This could start a flame war! I've seen instances of otherwise-seasoned coders on here using the dreaded
```
;WITH CTE...
```
--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)
February 8, 2023 at 4:20 pm

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

Grant Fritchey wrote:
Jeff Moden wrote:
David Burrows wrote:
Jeff Moden wrote:
David Burrows wrote:
That’s why I like you Jeff, you’re such a smart guy 😍🥳
Heh... if I were really smart, I'd just up and retire. That would probably...
--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)

February 8, 2023 at 4:13 pm

#4147178
Reply To: bcp is giving SQL State = 1000 Native error =0 SQL Server

surafeb7 wrote:
Thanks, Jeff, for your reply and I am happy that you are paying more attention in security matters. Yes, this command is being embedded in a toll, contains security...
--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)

February 8, 2023 at 4:06 am

#4146838
Reply To: Backing up a damaged database

I'm going to venture out and say that what you have as the correct answer isn't the correct answer. It doesn't even appear on the page you referenced.
--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)

February 8, 2023 at 3:57 am

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

David Burrows wrote:
Jeff Moden wrote:
I think most folks would say your confused, David. They rather think I should be IN an institution. 😀 😀 😀
LOL. Maybe we could be in the same...
--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)

February 8, 2023 at 3:10 am

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

David Burrows wrote:
Jeff Moden wrote:
David Burrows wrote:
That’s why I like you Jeff, you’re such a smart guy 😍🥳
Heh... if I were really smart, I'd just up and retire. That would probably kill me...
--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)

February 8, 2023 at 1:45 am

#4146815
Reply To: A Version Control Strategy for Branch-based Database Development

I have admittedly not studied the entire article (yet). One of the things that caught my eye was your "movie" about the "Release Flow in Action". Watching that, it would...
--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)

February 8, 2023 at 1:43 am

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

David Burrows wrote:
That’s why I like you Jeff, you’re such a smart guy 😍🥳
Heh... if I were really smart, I'd just up and retire. That would probably kill me though.
--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)

February 8, 2023 at 1:27 am

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

kaj wrote:
Jeff Moden wrote:
kaj wrote:
Jeff Moden wrote:
It apparently cannot make the distinction between "temp tables" and "temporary tables". It's seriously incorrect for what most of us refer to as "temp tables"...
--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)

February 8, 2023 at 1:11 am

#4146805

Viewing 15 posts - 1,966 through 1,980 (of 59,067 total)