Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,291 through 13,305 (of 59,095 total)

RE: Shrink all user database files

I appreciate you sharing but, be advised, shrinking databases every day is a form of "Death by SQL".
1. It can and usually will cause a type of fragmentation...
--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)

December 27, 2017 at 7:07 pm

#1973658
RE: avoiding distinct operator ?

vsamantha35 - Wednesday, December 27, 2017 11:44 AM
Jeff Moden - Wednesday, December 27, 2017 8:49 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)

December 27, 2017 at 11:56 am

#1973619
RE: Is the old stuff worth learning?

HighPlainsDBA - Wednesday, December 27, 2017 11:19 AM
Jeff Moden - Wednesday, December 27, 2017 10:46 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)

December 27, 2017 at 11:46 am

#1973616
RE: Using hardcoded database names in query when database names are different on development and production server

You should use synonyms for all references outside of the current database even if your database names are identical between Prod and Dev and you should ALWAYS (there's a term I don't...
--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)

December 27, 2017 at 11:02 am

#1973612
RE: Is the old stuff worth learning?

HighPlainsDBA - Wednesday, December 27, 2017 9:32 AM
If you are a 'one trick pony' when it comes to tools and tech 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)

December 27, 2017 at 10:46 am

#1973611
RE: The Slow Week

It's never slow for me. I always work between the holidays so that the "kids that have kids" can spend time with their kids. It's also the week the everyone...
--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)

December 27, 2017 at 8:54 am

#1973598
RE: avoiding distinct operator ?

drew.allen - Wednesday, December 27, 2017 7:13 AM
vsamantha35 - Tuesday, December 26, 2017 9:23 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)

December 27, 2017 at 8:49 am

#1973595
RE: Help with SQL memory pressure investigation

Especially because this has symptoms in the form of recompiles, check sp_Who2 during the problem and see how many SPIDs are in a KILLED/ROLLBACK state compared to normal (there usually...
--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)

December 27, 2017 at 8:34 am

#1973592
RE: Tempdb growth

haichells - Tuesday, December 26, 2017 9:52 PM
Dear All,
Thanks a lot for your ideas! I will try to refine the sql statements...
--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)

December 27, 2017 at 7:25 am

#1973577
RE: OPENROWSET when Excel worksheet name is unknown

Eirikur Eiriksson - Saturday, December 23, 2017 8:35 AM
Jeff, are you working up a huge back-log?
😎
Can we take the Excel thing...
--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)

December 26, 2017 at 9:44 pm

#1973536
RE: Why Haven’t You Upgraded SQL Server?

I can give you some very good reasons to NOT upgrade to the latest and greatest... look at 2012 and the problems they had there. They didn't actually fix some of...
--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)

December 26, 2017 at 6:09 pm

#1973534
RE: Reduce records in a slowly changing dimension table

Chrissy321 - Tuesday, December 26, 2017 5:00 PM
I neglected to provide sample data that would illustrate a particular scenario and naturally the...
--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)

December 26, 2017 at 5:36 pm

#1973533
RE: How to do Parallel Query Execution in SQL Server

ZZartin - Tuesday, December 26, 2017 11:10 AM
anujkumar.mca - Tuesday, December 26, 2017 9: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)

December 26, 2017 at 11:15 am

#1973499
RE: Server Not Responding

Before that, have you tried accessing any of the drives that have been reported as a problem? I'm not an expert here but it sounds like a disk failure.
--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)

December 26, 2017 at 11:04 am

#1973494
RE: How to do Parallel Query Execution in SQL Server

anujkumar.mca - Tuesday, December 26, 2017 9:13 AM
enable the XP_CMDShell at prod shall not be recommended
Heh... I suppose you think that 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)

December 26, 2017 at 11:02 am

#1973493

Viewing 15 posts - 13,291 through 13,305 (of 59,095 total)