Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 59,086 total)

Reply To: How to Append Character to Field Values

I can also tell you for sure that the "community member"s name was not Jeff Morden. 😀
--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)

October 17, 2022 at 12:14 am

#4100274
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

Totally understood and, I never thought I'd say this, but this is for a "one-off". I'll invest some time in a better one later. And, I totally agree with 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)

October 16, 2022 at 9:07 pm

#4100251
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

sgmunson wrote:
Haven't been able to quickly find something online that solves it...
30 second search https://duckduckgo.com/?q=find+column+name+in+all+databases+sql+server led to the following:
https://sqlserverplanet.com/dba/find-column-in-all-databases
Hope it helps.
--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)

October 15, 2022 at 10:47 pm

#4100067
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

Heh... ya kinda missed my point.
--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)

October 15, 2022 at 1:37 am

#4099829
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

p.s. You could do a "quickie" with sys.sp_MSforeachdb . It's not something that I'd use for production code but it works for a "one off".
https://www.kodyaz.com/articles/sql-server-exec-sp_msforeachdb-sp_msforeachtable-example-tsql-code.aspx

--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)

October 14, 2022 at 3:50 pm

#4099684
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

sgmunson wrote:
Thanks for the reply, Jeff... I'll just have to do this manually then, as I don't really have the time right now to write the code...
As to my...
--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)

October 14, 2022 at 3:45 pm

#4099683
Reply To: Backup Schedule

PJ_SQL wrote:
Hi!
I need to schedule backup on each Friday and need to keep 4 backups.
We are using ola hallengren script, what should be the retention for this requirement?
Thanks in advance.
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)

October 14, 2022 at 3:15 pm

#4099660
Reply To: I need a T-SQL script to find, for a given view across all databases, which ...

Your signature line is starting to look more and more like SPAM, Steve. If I didn't know you, I'd mark your post as SPAM.
As to your question, the information you...
--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)

October 14, 2022 at 3:06 pm

#4099659
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

I did answer that. Like I said...
...it doesn't even make sense for tables as small as just 1,000 rows
... so my answer stands. Any size Tally table to do...
--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)

October 13, 2022 at 10:20 pm

#4099356
Reply To: Cons vs Pros of using SSISDB deployment vs File Sytem deployment of SSIS pkgs?

Do you have some links to the documentation that compares the old v.s. the new methods? I'm not a SSIS user but I'd like to see what they're saying.
--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)

October 13, 2022 at 10:13 pm

#4099355
Reply To: Cons vs Pros of using SSISDB deployment vs File Sytem deployment of SSIS pkgs?

With the understanding that I don't use either, the real question is, what are you trying to accomplish through all of this? Why is the change necessary for you?
--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)

October 13, 2022 at 9:34 pm

#4099342
Reply To: Where did all of the SQL Server DBAs go?

Ed B wrote:
I had not see that before. Very good, but I think the lines need to be in the cloud.
😀
--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)

October 13, 2022 at 3:59 am

#4098948
Reply To: Reset varchar length to 19 from 4000 in a concatenated date

Consider, perhaps, the utility of thing like BULK INSERT and BCP and even the ACE Drivers (which actually pale in comparison to the old JET drivers).
--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)

October 12, 2022 at 2:22 am

#4098206
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

IIRC, you'll find no place where I've suggested doing such a thing in the article because there are much more effective methods to find gaps in a sequence of values. ...
--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)

October 11, 2022 at 10:41 pm

#4098162
Reply To: Reset varchar length to 19 from 4000 in a concatenated date

@Carroll,
You said...
I import a table from a comma delimited file...
I'm curious as to what you're using to do the import of the file.
--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)

October 11, 2022 at 8:27 pm

#4098128

Viewing 15 posts - 2,626 through 2,640 (of 59,086 total)