Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,946 through 12,960 (of 59,095 total)

RE: Today's Random Word!

ZZartin - Monday, February 12, 2018 2:21 PM
Jason A. Long - Monday, February 12, 2018 2:06 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 12, 2018 at 2:40 pm

#1979528
RE: A Simple Introduction to Dynamic SQL

Peter Heller - Monday, February 12, 2018 5:42 AM
I would have used the concat function SQL Server 2012 or better,...
--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 12, 2018 at 8:17 am

#1979429
RE: Performance improvement following a disable indexes, shrink, enable indexes - but why?

pcd_au - Sunday, February 11, 2018 10:15 PM
Jeff Moden - Sunday, February 11, 2018 9:25 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 12, 2018 at 6:55 am

#1979409
RE: Performance improvement following a disable indexes, shrink, enable indexes - but why?

pcd_au - Sunday, February 11, 2018 8:40 PM
I'm stumped and need the assistance of the wider community to understand what is going...
--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 11, 2018 at 9:25 pm

#1979377
RE: GROUP BY TO appear IN one row THEN Calculate total and AVG

There's no need for the second GROUP BY and you can simplify the average calculation. Also, consider adopting and capitalization and indention standard for readability. You should also start using...
--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 11, 2018 at 8:56 pm

#1979375
RE: GROUP BY TO appear IN one row THEN Calculate total and AVG

What you're looking for is called a "Crosstab". The following is your code modified to do a "Crosstab".

SELECT Year = DATEPART(yy,SignalDATE)
,Weeks = DATEPART(wk,Signaldate)
--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 11, 2018 at 12:23 pm

#1979366
RE: Why can't I paste SQL code into a post???

Steve Jones - SSC Editor - Friday, February 9, 2018 2:57 PM
The formatting from SSMS is problematic. It has various forms, and...
--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 3:35 pm

#1979322
RE: Calendar table

patrickmcginnis59 10839 - Friday, February 9, 2018 8:40 AM
I strongly disagree... Darko's code is a problem... several problems, actually. But we're...
--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 9:24 am

#1979266
RE: Calendar table

{Edit} Took a post on Easter dates down because I found differences between a couple and I don't actually know which one is correct.
--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 8:37 am

#1979252
RE: Calendar table

I strongly disagree... Darko's code is a problem... several problems, actually. But we're wasting time on that disagreement because neither of us will change our opinion there.
As for...
--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 8:24 am

#1979246
RE: Calendar table

patrickmcginnis59 10839 - Friday, February 9, 2018 6:30 AM
Heck I'm not saying it doesn't happen either, but bad moves should have...
--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:56 am

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

Viewing 15 posts - 12,946 through 12,960 (of 59,095 total)