Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,976 through 12,990 (of 59,102 total)

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
RE: View VS Select from Table

subramaniam.chandrasekar - Wednesday, February 7, 2018 12:53 AM
VastSQL - Wednesday, February 7, 2018 12: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 6:34 am

#1978850
RE: Calculating sum of days/weeks

To be able to answer this question correctly, you need to tell us what a week, month, and quarter is.
What day of the week does a week start...
--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:02 am

#1978845
RE: SQL Server best practice....

bwelch42 - Tuesday, February 6, 2018 6:44 PM
While our VMs were using the same disk, we found significant benefits from placing 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)

February 6, 2018 at 7:11 pm

#1978807
RE: Sort comma separated value in SQL Table

Jason A. Long - Tuesday, February 6, 2018 1:54 PM
Jeff Moden - Tuesday, February 6, 2018 1:39...
--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 6, 2018 at 3:11 pm

#1978795
RE: Delete from very large multiple tables

Arsh - Tuesday, February 6, 2018 1:21 PM
Lynn Pettis - Monday, February 5, 2018 12:37 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 6, 2018 at 1:47 pm

#1978782
RE: Today's Random Word!

Jason A. Long - Tuesday, February 6, 2018 1:35 PM
Kaye Cahs - Tuesday, February 6, 2018 1:33...
--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 6, 2018 at 1:40 pm

#1978779
RE: Sort comma separated value in SQL Table

The extra space was in your IF before the DROP, not in the actual DROP itself.
Agreed on the rest.
--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 6, 2018 at 1:39 pm

#1978778
RE: Sort comma separated value in SQL Table

Jason A. Long - Tuesday, February 6, 2018 8:55 AM
Looks like the OP has bailed on this thread but it's still an...
--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 6, 2018 at 9:57 am

#1978735

Viewing 15 posts - 12,976 through 12,990 (of 59,102 total)