Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,991 through 13,005 (of 59,102 total)

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
RE: How to use dynamic pivot on this data

NineIron - Monday, February 5, 2018 4:00 AM
Jeff Moden - Sunday, February 4, 2018 3:41 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:16 pm

#1978634
RE: Does denormalizing the data enhance performance?

RonKyle - Friday, February 2, 2018 8:34 AM
The answer to your question is yes, denormalization can definitely help performance. Unfortunately it can...
--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 4, 2018 at 4:34 pm

#1978482
RE: We Do Need To Upgrade

Each new release of Windows is almost as bad as a new product instead of an upgrade. While I appreciate new functionality, upgrades are frequently expensive because of the removal...
--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 4, 2018 at 4:18 pm

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

NineIron - Friday, February 2, 2018 8:38 AM
I've tried to understand dynamic sql but, to no avail. Could you tell me how...
--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 4, 2018 at 3:41 pm

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

John Mitchell-245523 - Friday, February 2, 2018 8:52 AM
Step by step dynamic pivot script? Your wish is my command. It's...
--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 4, 2018 at 3:23 pm

#1978478
RE: SQL Server 3rd party Backup tool

ALIF-662928 - Thursday, February 1, 2018 12:42 PM
hi,
we have a DB of 20 TB in 2 files, got lot of unused space...
--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 4, 2018 at 1:47 pm

#1978476
RE: Assign incrementing letters to same value

Talvin Singh - Sunday, February 4, 2018 12:15 PM
to be honest, it could be a numberCode rather than letterCode, i just need...
--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 4, 2018 at 1:17 pm

#1978474
RE: Huge Latency in TempDB

RandomStream - Sunday, February 4, 2018 11:36 AM
Jeff Moden - Sunday, February 4, 2018 9:53 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 4, 2018 at 12:22 pm

#1978472

Viewing 15 posts - 12,991 through 13,005 (of 59,102 total)