Jeff Moden

Forum Replies Created

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

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
RE: Need counts of orders per week grouped by week

meichmann - Tuesday, February 6, 2018 5:23 AM
Jeff Moden - Monday, February 5, 2018 2:40 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 7:01 am

#1978695
RE: Sort comma separated value in SQL Table

@PSB,
Where you able to solve your problem from what has been posted so far? Even if you have, you might want to post what you've come up with...
--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:01 am

#1978694
RE: Sort comma separated value in SQL Table

subramaniam.chandrasekar - Tuesday, February 6, 2018 12:34 AM
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 6, 2018 at 6:58 am

#1978693
RE: Need counts of orders per week grouped by week

meichmann - Monday, February 5, 2018 6:06 AM
Yes it is. If the month, or even year rolls over during the business...
--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 5, 2018 at 2:40 pm

#1978640
RE: Huge Latency in TempDB

TheSQLGuru - Monday, February 5, 2018 8:09 AM
Jeff Moden - Sunday, February 4, 2018 12:22 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 5, 2018 at 2:36 pm

#1978639
RE: We Do Need To Upgrade

Summer90 - Monday, February 5, 2018 9:14 AM
Steve Jones - SSC Editor - Monday, February 5, 2018...
--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 5, 2018 at 2:27 pm

#1978638
RE: How to use dynamic pivot on this data

Jeff Moden - Monday, February 5, 2018 2:16 PM
Got it. I'll revisit tonight.
Hmmm... I might not have to. Have you seen...
--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 5, 2018 at 2:20 pm

#1978635

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