Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,931 through 12,945 (of 59,102 total)

RE: Using Hex values

IQ1 - Thursday, February 15, 2018 10:47 AM
Hello
I have a scenario where in I am using a Hex value, to...
--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 16, 2018 at 4:39 am

#1980027
RE: Issue with using Ola Hallengren Backup script

quackhandle1975 - Friday, February 16, 2018 3:45 AM
Hi, I am using OH's excellent scripts, however I have found and issue when it...
--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 16, 2018 at 4:36 am

#1980026
RE: Formatting a datetime in UK format - Mmm dd YYYY

Use the CONVERT function:
This will do exactly what you asked for...
SELECT CONVERT(CHAR(
--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 16, 2018 at 4:29 am

#1980023

RE: Need Recommendations for Document Database

BU69 - Thursday, February 15, 2018 2:36 AM
Jeff, can you let me know what issues you have had with the striped 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)

February 15, 2018 at 5:59 pm

#1980015

RE: Compression estimates

Mike Stuart-386150 - Thursday, February 15, 2018 3:58 PM
Jeff Moden - funny, I was thinking about how you'd react if you saw...
--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 15, 2018 at 4:22 pm

#1980010

RE: Memory Optimized FileGroups

Grant Fritchey - Friday, February 9, 2018 8:07 AM
Jeff Moden - Friday, February 9, 2018 6:39 AM
--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 15, 2018 at 8:21 am

#1979921

RE: Today's Random Word!

ManicStar - Wednesday, February 14, 2018 12:59 PM
ZZartin - Wednesday, February 14, 2018 12:54 PM
--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 14, 2018 at 5:25 pm

#1979859

RE: Need Recommendations for Document Database

aureolin - Wednesday, February 14, 2018 10:04 AM
Jeff Moden - Wednesday, February 14, 2018 6:43 AM
--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 14, 2018 at 5:19 pm

#1979858

RE: Why can't I paste SQL code into a post???

Steve Jones - SSC Editor - Wednesday, February 14, 2018 11:13 AM
Jeff Moden - Tuesday, February 13,...
--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 14, 2018 at 5:06 pm

#1979857

RE: Need Recommendations for Document Database

aureolin - Friday, February 9, 2018 10:37 AM
We're in the process of a data migration from one LOB tool to another over...
--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 14, 2018 at 6:43 am

#1979719

RE: Help me with the SELECT statement please ?

The biggest problem with this whole thing is the notion of storing the year and month in separate columns instead of as whole dates that represent the first of 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)

February 14, 2018 at 6:31 am

#1979717

RE: db slow ?

christophe.bernard 47659 - Wednesday, February 14, 2018 2:45 AM
Hello all,
thanks for your reply and sorry for this delay ..
@eirikur => sorry but...
--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 14, 2018 at 6:25 am

#1979716

RE: db slow ?

christophe.bernard 47659 - Monday, February 12, 2018 8:29 AM
Hello all,
we have a database under sql server 2008.
This db contains some tables and...
--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 14, 2018 at 6:23 am

#1979715

RE: Valentines Day for Data Professionals

I took a computer course in high school way back in 1968. Have been hooked on data and the machines/software that handles it ever since. Looking back to where I'm 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)

February 14, 2018 at 6:21 am

#1979713

RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, February 13, 2018 3:40 PM
If someone isn't good at programming and dislikes it, why are they in this...
--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 14, 2018 at 6:11 am

#1979710

Viewing 15 posts - 12,931 through 12,945 (of 59,102 total)
Prev
1
2
3
…
862
863
864
…
3,939
3,940
3,941
Next