Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,386 through 2,400 (of 59,086 total)

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
Reply To: mdf space balance

Bruin wrote:
Just so I understand I just need to rebuild Index with:
CREATE UNIQUE CLUSTERED INDEX PK__UserLog__7F8B815172CE9EAE ON UserLog (UserLogID) WITH (DROP_EXISTING = ON) ON HISTORY
Thx.
That's it. No need to drop...
--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:39 pm

#4119197
Reply To: mdf space balance

Adding another post just to make the forum software actually see 2 pages of posts.
--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 8:18 pm

#4119139
Reply To: mdf space balance

Just to be sure, an index "rebuild" won't do a move. It must be a CREATE INDEX that matches the currently existing index in all ways and it must 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)

November 28, 2022 at 8:16 pm

#4119138
Reply To: mdf space balance

Bruin wrote:
I have 10-15 tables I would like to move to help balance the drive usage on that server. The tables I'm moving are just for reporting by the front-end...
--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 4:46 pm

#4119069
Reply To: The Scariest Data Type

Just to add to this... I've found that the absolute scariest datatype is when people use the wrong datatype to store data, no matter what it is.
My recent favorite examples...
--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 4:38 pm

#4119065
Reply To: Copy backup to not destroy backupchain

The real risk is you forgetting to use the "Copy Only" functionality. 😀 You can tell I've "never had that problem before", right? 😀 I've made that mistake a couple...
--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 3:38 pm

#4119032

Viewing 15 posts - 2,386 through 2,400 (of 59,086 total)