Jeff Moden

Forum Replies Created

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

RE: Memory Optimized FileGroups

Grant Fritchey - Thursday, February 8, 2018 4:01 PM
One HUGE point, you can't delete a memory optimized filegroup after you add it...
--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 9, 2018 at 6:39 am

#1979230
RE: Calendar table

And, yeah... agreed. Very difficult to post good looking code directly.
--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:31 pm

#1979165
RE: Calendar table

patrickmcginnis59 10839 - Thursday, February 8, 2018 3:56 PM
Jeff Moden - Wednesday, January 31, 2018 7:35 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 8, 2018 at 9:21 pm

#1979164
RE: View VS Select from Table

subramaniam.chandrasekar - Wednesday, February 7, 2018 10:10 PM
Grant Fritchey - Wednesday, February 7, 2018 7:40 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 8, 2018 at 10:35 am

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

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