Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,776 through 11,790 (of 59,095 total)

RE: Loading more than 1 billion records from CSV File

frederico_fonseca - Thursday, July 19, 2018 7:32 AM
Jeff Moden - Wednesday, July 18, 2018 8:00 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)

July 19, 2018 at 8:44 am

#1998215
RE: Are the posted questions getting worse?

Heh... inline with the first interview question about how to get the current date and time, perhaps this should be the second question...
https://www.sqlservercentral.com/Forums/FindPost1977357.aspx
I have 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)

July 19, 2018 at 8:35 am

#1998212
RE: Are the posted questions getting worse?

jasona.work - Thursday, July 19, 2018 6:04 AM
Argh...
So today I was all set to happily telework when it all went sideways 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)

July 19, 2018 at 8:05 am

#1998198
RE: Need Help to convert DATETIME result into DATE on SQL Server

Nexana - Wednesday, July 18, 2018 8:23 PM
Jeff Moden - Monday, July 16, 2018 3: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)

July 19, 2018 at 8:03 am

#1998195
RE: Finding a particular date in all tables

Thanks, Ben. I appreciate the time on that.
I guess I'm a bit spoiled... we have a couple centralized audit tables (different functionality groups for each one) for the important...
--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)

July 19, 2018 at 6:58 am

#1998179
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, July 18, 2018 4:04 PM
This is really getting ridiculous. Why is it so hard for people to actual...
--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)

July 19, 2018 at 6:51 am

#1998177
RE: Loading more than 1 billion records from CSV File

xsevensinzx - Thursday, July 19, 2018 2:45 AM
Yep, BULK INSERT is a great option. I used it as the sole way 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)

July 19, 2018 at 6:48 am

#1998174
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Tuesday, July 17, 2018 7:15 AM
Jeff Moden - Tuesday, July 17, 2018 6:14...
--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)

July 18, 2018 at 8:20 pm

#1998142
RE: Need Help to convert DATETIME result into DATE on SQL Server

jcelko212 32090 - Wednesday, July 18, 2018 7:56 PM
Jeff Moden - Wednesday, July 18, 2018 3:24 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)

July 18, 2018 at 8:10 pm

#1998140
RE: Loading more than 1 billion records from CSV File

xsevensinzx - Wednesday, July 18, 2018 5:47 PM
Jeff Moden - Wednesday, July 18, 2018 7:04 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)

July 18, 2018 at 8:00 pm

#1998139
RE: Need Help to convert DATETIME result into DATE on SQL Server

jcelko212 32090 - Wednesday, July 18, 2018 2:17 PM
meichmann - Wednesday, July 18, 2018 10: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)

July 18, 2018 at 3:24 pm

#1998112
RE: How to GROUP BY XML column

lexcerm - Wednesday, July 18, 2018 6:47 AM
I have added all the columns in the select one-by-one, but it keeps bombing out...
--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)

July 18, 2018 at 1:26 pm

#1998093
RE: Seeking advice to determine a good option for table row comparisons

vsamantha35 - Wednesday, July 18, 2018 12:04 AM
Hi All,
We have a requirement where we need to compare table rows and merge...
--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)

July 18, 2018 at 1:20 pm

#1998091
RE: sproc question

mjohnson 71479 - Wednesday, July 18, 2018 1:03 PM
Thank you! I have rewritten it and it is working as intended.
Very cool. Thanks...
--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)

July 18, 2018 at 1:16 pm

#1998090
RE: Need Help to convert DATETIME result into DATE on SQL Server

meichmann - Wednesday, July 18, 2018 10:39 AM
Jeff Moden - Monday, July 16, 2018 3: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)

July 18, 2018 at 12:12 pm

#1998080

Viewing 15 posts - 11,776 through 11,790 (of 59,095 total)