Jeff Moden

Forum Replies Created

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

RE: Need idea on exporting column data to separate file -ssis

Heh... they won't allow you to use xp_CmdShell because they think it's a security risk (it's patently NOT when used correctly) but they will let you call a C# script...
--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 1:09 pm

#1980177
RE: Show results based on String Search

shyamhr - Friday, February 16, 2018 5:10 PM
Hi Everyone,
I have a complex...
--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:37 pm

#1980176
RE: @@OPTIONS

Heh... although it certainly does return a single integer (which is the answer I chose based on a coin flip between A and C), answer C is actually much more...
--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:26 pm

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

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