Jeff Moden

Forum Replies Created

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

RE: Please delete this post

ffarouqi - Tuesday, February 13, 2018 3:37 PM
GilaMonster - Tuesday, February 13, 2018 3:30 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 14, 2018 at 5:55 am

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

Steve Jones - SSC Editor - Friday, February 9, 2018 5:38 PM
Either way should work. I sometimes put the tags in, then...
--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 13, 2018 at 9:52 pm

#1979678
RE: SSD server with 1 logical drive

Alexander Zhang - Tuesday, February 13, 2018 3:07 PM
Although we can find reasons to do or not to do it, I suggest...
--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 13, 2018 at 9:43 pm

#1979677
RE: Data Files (mdf)

Alexander Zhang - Tuesday, February 13, 2018 3:31 PM
For same DB and same filegroup, you can DBCC SHRINKFILE with EMPTYFILE option, then...
--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 13, 2018 at 9:40 pm

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

pcd_au - Monday, February 12, 2018 7:51 PM
Jeff Moden - Monday, February 12, 2018 5:54 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 13, 2018 at 8:41 pm

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

mig28mx - Tuesday, February 13, 2018 1:42 PM
Hi,
The most common factor for slow querys are:
1.- Low space on tmbdb. This is solved...
--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 13, 2018 at 8:39 pm

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

pcd_au - Monday, February 12, 2018 3:02 PM
GilaMonster - Monday, February 12, 2018 2:13 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 12, 2018 at 5:54 pm

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

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