Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,981 through 1,995 (of 59,082 total)

Reply To: Select values from second table that are not linked to first table
As a bit of a sidebar, this uses 31% fewer reads, which will come in handy for when the cross joined tables are larger...
```
 WITH 
 cteProduct...
```
--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 6:22 am

#4147386
Reply To: Select values from second table that are not linked to first table

Never mind... post deleted because it wasn't necessary. The OP figured it out.
--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 5:43 am

#4147366
Reply To: how to make a col in a table after checking its existence, in one stmt

rajemessage 14195 wrote:
i think information schema is better because col_length is a function call and finally it would go to sys.objects or all_objects or information schema it self.
This is what I...
--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:55 am

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

Got the first post on a page again... and again, it's not showing up until another post (this one) is made.
--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:14 am

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

According to Paul White (and what I heard early on when they first started meta-caching of Temp Tables), dropping the tables does NOT prevent caching of Temp Table meta-data.
https://sqlperformance.com/2017/05/sql-performance/sql-server-temporary-object-caching
--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:13 am

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

Viewing 15 posts - 1,981 through 1,995 (of 59,082 total)