Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 59,067 total)

Reply To: should atemp table be used from looping even when single table is used in a loop

rajemessage 14195 wrote:
hi,
We have a master table, single table which I loop thought, to do some task, the master table is very rarely changed.
So while looping through , I put some...
--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)

November 29, 2022 at 10:43 pm

#4119706
Reply To: Find Guest user access level in all databases
Daniel Adeniji-180202 wrote:
Manny:-
I do not think example 2 actually works.
Here is your SQL Statement for Example 2:-
```
Declare @holdname sysname
Declare getdbname cursor for
Select name from master.sys.databases order by name
Open...
```
--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)
November 29, 2022 at 10:33 pm

#4119705
Reply To: Copy backup to not destroy backupchain

K. I was just checking. To paraphrase "Red Green", "We're all in this together and I'm pullin' for ya."
--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)

November 29, 2022 at 10:13 pm

#4119698
Reply To: DateTime Format Conversion AM/PM

HeftSteady wrote:
Your solution did not convert to 12 hour or include AM PM designation.
Ha, I know you suggested against using FORMAT but that is what I ended up doing .
FORMAT(CAST(field_here...
--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)

November 29, 2022 at 10:09 pm

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

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update 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)

November 29, 2022 at 4:14 am

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

Ok... they've fixed the notifications issue and it appears have been doing things correctly for a while now. Does anyone have any more problems with that issue?
--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)

November 29, 2022 at 4:10 am

#4119265
Reply To: Investing in Another's Career

I'm with Rick and ZZArtin on this one. But, I WILL put a positive spin on things...
It's a funny thing... I didn't realize, when I first started, how much investing...
--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)

November 29, 2022 at 4:04 am

#4119264
Reply To: mdf space balance

Bruin wrote:
Thanks Jeff .. by default, will all sorting be done in tempdb during Index creation?
It took you longer to post the question than it would for you to look...
--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)

November 29, 2022 at 3:20 am

#4119255
Reply To: DateTime Format Conversion AM/PM
Replace GETDATE() in the following with your datetime valued.
```
 SELECT CONVERT(CHAR(10),GETDATE(),110)+STUFF(RIGHT(CONVERT(CHAR(19),GETDATE(),100),8),7,0,' ')
```
Some will suggest using the FORMAT function... I strongly recommend against that. See the article at...
--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)
November 29, 2022 at 3:07 am

#4119250
Reply To: Get Date Monday Show results for weekend and then else 24 hours

I try to avoid the use of things like the Week and WeekDay date parts for multiple reasons that would take too long to go into here.
Based on what 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)

November 29, 2022 at 12:08 am

#4119216
Reply To: Copy backup to not destroy backupchain

On that note, do you actually have permission to do that from the company and is there any PII in that database where it shouldn't be sent even if 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)

November 28, 2022 at 11:34 pm

#4119209
Reply To: Get Date Monday Show results for weekend and then else 24 hours

DMcMorris@welcom.co.uk wrote:
Monday and 48 hours prior (the weekend) and then else - just 24 hours (for the rest of the week).
Do you really mean 48 and 24 hours in your...
--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)

November 28, 2022 at 11:02 pm

#4119207
Reply To: Copy backup to not destroy backupchain

The only time I use the COPY ONLY option is if I need to send the actual file someone. I don't want a file listed in MSDB for my backups...
--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)

November 28, 2022 at 10:58 pm

#4119202
Reply To: mdf space balance

As a bit of a future-planning sidebar...
If that table ever becomes fragmented, you may want to someday defragment it. To keep the file group from having a whole bunch of...
--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)

November 28, 2022 at 10:53 pm

#4119201
Reply To: mdf space balance

BTW... it's a really good habit to add brackets to the name of the file group. It'll let you live for HISTORY without them but it's absolutely required if 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)

November 28, 2022 at 10:47 pm

#4119198

Viewing 15 posts - 2,356 through 2,370 (of 59,067 total)