Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,806 through 11,820 (of 59,099 total)

RE: Loading more than 1 billion records from CSV File

I'm not saying
xsevensinzx - Wednesday, July 18, 2018 5:54 AM
Sounds like there may be some bottlenecks when the data lands such...
--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 7:04 am

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

See the following article. Even though it's a slightly bastardized version (missing some information and some very helpful graphics, which is another proof that change isn't always for the better)...
--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 17, 2018 at 10:00 pm

#1997938
RE: Storage that Expires

Sounds like a great place to store audit data.
--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 17, 2018 at 9:31 pm

#1997937
RE: Database query performance is very poor

saptek9 - Tuesday, July 17, 2018 5:52 PM
database performance is getting better after restart the server and slowing down after a while...
--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 17, 2018 at 9:23 pm

#1997936
RE: Who Likes NULL?

Matt Miller (4) - Tuesday, July 17, 2018 6:42 PM
mark.edwards-1115881 - Tuesday, July 17, 2018 12:04 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 17, 2018 at 9:10 pm

#1997935
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

Thanks for the great feedback, Sue. And thank you for all the great posts you've made. You're definitely a heavy hitter and would love to see you start writing articles. ...
--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 17, 2018 at 4:37 pm

#1997923
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

sqldriver - Thursday, August 21, 2014 9:46 AM
This article helped me big time having to load the 18Gb text file here[/url]. All...
--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 17, 2018 at 3:27 pm

#1997920
RE: Flat File csv with double quotes

gothaimviii - Tuesday, July 17, 2018 1:55 PM
well in theory the SSIS import of the file and using the " as a...
--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 17, 2018 at 3:20 pm

#1997918
RE: The GDPR is Coming to the US

Eric M Russell - Tuesday, July 17, 2018 1:27 PM
What you've described above is the specification for a really useful chat...
--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 17, 2018 at 1:31 pm

#1997902
RE: Flat File csv with double quotes

Chris Hurlbut - Tuesday, July 17, 2018 1:18 PM
Jeff Moden - Monday, July 16, 2018 3:49 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 17, 2018 at 1:26 pm

#1997900
RE: How to improve Delete Performance

quinn.jay - Tuesday, July 17, 2018 12:43 PM
I ended up going with a tweak on the DELETE statement coupled with clustered and...
--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 17, 2018 at 12:50 pm

#1997895
RE: dm_db_index_usage_stats not accurately reflecting index usage

Grant Fritchey - Tuesday, July 17, 2018 11:54 AM
Jeff Moden - Tuesday, July 17, 2018 11:47 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 17, 2018 at 12:49 pm

#1997894
RE: The GDPR is Coming to the US

David.Poole - Tuesday, July 17, 2018 11:57 AM
Jeff Moden - Tuesday, July 17, 2018 6:44 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 17, 2018 at 12:46 pm

#1997893
RE: The GDPR is Coming to the US

Jason A. Long - Tuesday, July 17, 2018 12:20 PM
I like to have some fun with them...
#1... I give them the...
--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 17, 2018 at 12:39 pm

#1997890
RE: How to improve Delete Performance

Better yet.... stop doing the deletes and learn how to do a proper "UPSERT" on a properly clustered/index table! Do you really think that many rows from the previous month...
--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 17, 2018 at 12:32 pm

#1997888

Viewing 15 posts - 11,806 through 11,820 (of 59,099 total)