Jeff Moden

Forum Replies Created

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

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

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