Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,961 through 12,975 (of 59,095 total)

RE: Insert data in multiple batches for millions of record

RonKyle - Thursday, February 8, 2018 7:49 AM
And, no... there's no way that I'd use SSIS for any of this. ...
--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 8, 2018 at 9:54 am

#1979056
RE: Calculating sum of days/weeks

astrid 69000 - Thursday, February 8, 2018 6:32 AM
Thanks, I solved it already 🙂
and belated happy birthday!!!! 🙂
Two way street here, astrid. ...
--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 8, 2018 at 7:17 am

#1979020
RE: Updating a varbinary field - extra leading zero added

pavel_hant - Wednesday, February 7, 2018 3:39 PM
Hello,
I would like to be able to update a varbinary field (named Varbinary_Data of varbinary(max)...
--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 7, 2018 at 6:29 pm

#1978973
RE: SQL Server 3rd party Backup tool

Evgeny Garaev - Wednesday, February 7, 2018 1:04 PM
ALIF-662928 - Thursday, February 1, 2018 12:42 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 7, 2018 at 2:33 pm

#1978960
RE: Sort comma separated value in SQL Table

jcelko212 32090 - Wednesday, February 7, 2018 1:06 PM
PSB - Thursday, February 1, 2018 9:48 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 7, 2018 at 2:31 pm

#1978959
RE: Sort comma separated value in SQL Table

Conficker - Wednesday, February 7, 2018 8:33 AM
Thom A - Thursday, February 1, 2018 10:02 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 7, 2018 at 8:53 am

#1978912
RE: Insert data in multiple batches for millions of record

I probably wouldn't use an iterative approach here. Since the tables are empty, I'd add the correct Clustered Index to the table, set the database to the BULK LOGGED Recovery...
--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 7, 2018 at 7:40 am

#1978890
RE: View VS Select from Table

subramaniam.chandrasekar - Wednesday, February 7, 2018 6:57 AM
Sue_H - Wednesday, February 7, 2018 6:45 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 7, 2018 at 7:30 am

#1978883
RE: sa account login_time field

Feeg - Wednesday, February 7, 2018 6:23 AM
Thanks Gail, will do 🙂
If you follow the normal recommendation of disabling the SA login,...
--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 7, 2018 at 7:26 am

#1978880
RE: Importing Multiple pipe delimiter files at once

Jim Mackenzie - Wednesday, February 7, 2018 5:06 AM
I don't believe you can bulk insert multiple files at once.
Probably the easiest way...
--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 7, 2018 at 7:23 am

#1978876
RE: I need a opinion

RandomStream - Friday, February 2, 2018 5:48 PM
msimone - Friday, February 2, 2018 12:52 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 7, 2018 at 7:20 am

#1978875
RE: I need a opinion

msimone - Friday, February 2, 2018 12:52 AM
Thanks for all, yours opinions are importants for me.
Please see my and other folks comments...
--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 7, 2018 at 7:18 am

#1978872
RE: I need a opinion

shwetakakran01 - Wednesday, February 7, 2018 3:33 AM
your code is good and there less chance of error.
Not correct. The second snippet doesn't...
--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 7, 2018 at 7:16 am

#1978870
RE: I need a opinion

subramaniam.chandrasekar - Thursday, February 1, 2018 5:48 AM
msimone - Thursday, February 1, 2018 4:42 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 7, 2018 at 7:15 am

#1978869
RE: How to get middle rows data from a set of rows in a table

psmahesh115 - Wednesday, February 7, 2018 4:56 AM
sasil - Monday, March 15, 2010 5:36 AM
Hi...
--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 7, 2018 at 7:04 am

#1978863

Viewing 15 posts - 12,961 through 12,975 (of 59,095 total)