Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,916 through 12,930 (of 59,095 total)

RE: Using Hex values

Jason A. Long - Friday, February 16, 2018 10:23 AM
Jeff Moden - Friday, February 16, 2018 8:56...
--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 11:20 am

#1980108
RE: Using Hex values

jasona.work - Friday, February 16, 2018 8:46 AM
Jeff Moden - Friday, February 16, 2018 8:27 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 16, 2018 at 8:56 am

#1980084
RE: Using Hex values

ManicStar - Friday, February 16, 2018 8:45 AM
Jeff Moden - Friday, February 16, 2018 8:27 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 16, 2018 at 8:49 am

#1980081
RE: Using Hex values

Another possibility...

SELECT Original = hv.HexValue
        ,Final    = CONVERT(BINARY(4),REVERSE(CONVERT(BINARY(4),(hv.HexValue))))
   FROM (--==== This is just test data
        VALUES
         (0xE3C8F405)
        ,(0x6F4001)
        ,(0x10FB)
--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 8:45 am

#1980078
RE: Using Hex values

jasona.work - Friday, February 16, 2018 8:14 AM
If that's the case, it might be better to do that in the front-end (application)...
--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 8:27 am

#1980076
RE: Cloud Safe

Damn... I thought this was going to be a word association response test. My response to the words "Cloud Safe" was going to be "Oxymoron". 😀
--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 8:18 am

#1980073
RE: word for create a dev server

"Clone" would be the term that I would use but, no matter which term is used, it usually requires some clarification as to what you want 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)

February 16, 2018 at 5:30 am

#1980038
RE: Compression estimates

mike_the_dba - Thursday, February 15, 2018 4:48 PM
Probably not a 'god' thing - lol.
Any thoughts on how to make this code behave...
--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 5:24 am

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

Viewing 15 posts - 12,916 through 12,930 (of 59,095 total)
Prev
1
2
3
…
861
862
863
…
3,938
3,939
3,940
Next