Jeff Moden

Forum Replies Created

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

RE: Memory Optimized FileGroups

Grant Fritchey - Saturday, February 17, 2018 8:49 AM
Yeah, you can create the table variables into the In-Memory storage and it really...
--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 17, 2018 at 12:02 pm

#1980174
RE: Are the posted questions getting worse?

jonathan.crawford - Friday, February 16, 2018 5:36 PM
Sean Lange - Friday, February 16, 2018 1:19 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 17, 2018 at 6:56 am

#1980165
RE: Using Hex values

Jason A. Long - Friday, February 16, 2018 1:04 PM
Jeff Moden - Friday, February 16, 2018 12:53...
--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 2:06 pm

#1980138
RE: Using Hex values

Jason A. Long - Friday, February 16, 2018 12:40 PM
Jeff Moden - Friday, February 16, 2018 11:20...
--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 12:53 pm

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

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