Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,161 through 11,175 (of 59,102 total)

RE: Fitting Into RAM

David.Poole - Sunday, September 23, 2018 5:40 AM
The ridiculous thing is that the cost of peoples time arguing why you shouldn't 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)

September 23, 2018 at 8:39 am

#2006664
RE: Line and Columns combination

drew.allen - Monday, September 17, 2018 8:49 AM
I don't consider this a CROSS JOIN. It's an INNER JOIN on GPID and Name. ...
--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)

September 23, 2018 at 8:28 am

#2006663
RE: Fitting Into RAM

jarick 15608 - Saturday, September 22, 2018 2:54 PM
Is it me or does anyone else get a lot of consultants who...
--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)

September 22, 2018 at 4:16 pm

#2006656
RE: How to get output of SP_HELP_JOB into a script?

prakashanand2223 - Saturday, September 22, 2018 1:13 AM
Jen-169507 - Thursday, February 16, 2006 8:58 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)

September 22, 2018 at 7:48 am

#2006647
RE: Convert Date

Lynn Pettis - Friday, September 21, 2018 9:42 AM
craig.jenkins - Friday, September 21, 2018 8:18 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)

September 21, 2018 at 10:06 pm

#2006643
RE: Which data to baseline before and after adding an index

webrunner - Friday, September 21, 2018 8:20 AM
Hello experts,
While troubleshooting a poorly performing query, I was able to have some success in...
--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)

September 21, 2018 at 9:59 pm

#2006642
RE: Convert Date

Jonathan AC Roberts - Friday, September 21, 2018 9:04 AM
Jeff Moden - Friday, September 21, 2018 8:41...
--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)

September 21, 2018 at 9:22 am

#2006589
RE: Obfuscating values (via T-SQL) in several Varchar, Char, and Datetime columns ?

VoldemarG - Wednesday, September 19, 2018 1:26 PM
Is there any good T-SQL solution that you can recommend for obfuscating a dozen 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)

September 21, 2018 at 8:52 am

#2006585
RE: Fitting Into RAM

Summer90 - Friday, September 21, 2018 8:12 AM
Reminds me of a previous boss of mine in the 1990s when talking about...
--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)

September 21, 2018 at 8:48 am

#2006583
RE: Convert Date

below86 - Friday, September 21, 2018 7:50 AM
You could try this:
CONVERT(CHAR(11), DateIn, 107) AS DateIn
107 is going to have a comma in...
--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)

September 21, 2018 at 8:47 am

#2006582
RE: Convert Date

Jonathan AC Roberts - Friday, September 21, 2018 7:06 AM
craig.jenkins - Friday, September 21, 2018 6:53 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)

September 21, 2018 at 8:41 am

#2006581
RE: Creating Strings with Replicate

roger.plowman - Friday, September 21, 2018 8:14 AM
See, this is proof T/SQL is insane and full of gotchas. There is no reason replicate()...
--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)

September 21, 2018 at 8:30 am

#2006579
RE: Loading CSV Files Using Dynamic SQL

i_love_data - Wednesday, September 19, 2018 7:59 AM
Has anyone managed to load a large file like that? I tried with a file...
--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)

September 21, 2018 at 8:18 am

#2006575
RE: Loading CSV Files Using Dynamic SQL

sgtidwell - Thursday, September 20, 2018 6:43 AM
Bruin - Tuesday, September 18, 2018 5:31 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)

September 21, 2018 at 8:15 am

#2006572
RE: Loading CSV Files Using Dynamic SQL

Bruin - Friday, September 21, 2018 3:23 AM
sgtidwell - Thursday, September 20, 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)

September 21, 2018 at 8:14 am

#2006571

Viewing 15 posts - 11,161 through 11,175 (of 59,102 total)