Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,931 through 12,945 (of 59,095 total)

RE: Need Recommendations for Document Database

aureolin - Wednesday, February 14, 2018 10:04 AM
Jeff Moden - Wednesday, February 14, 2018 6:43 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 14, 2018 at 5:19 pm

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

Steve Jones - SSC Editor - Wednesday, February 14, 2018 11:13 AM
Jeff Moden - Tuesday, February 13,...
--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:06 pm

#1979857
RE: Need Recommendations for Document Database

aureolin - Friday, February 9, 2018 10:37 AM
We're in the process of a data migration from one LOB tool to another over...
--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 6:43 am

#1979719
RE: Help me with the SELECT statement please ?

The biggest problem with this whole thing is the notion of storing the year and month in separate columns instead of as whole dates that represent the first of 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)

February 14, 2018 at 6:31 am

#1979717
RE: db slow ?

christophe.bernard 47659 - Wednesday, February 14, 2018 2:45 AM
Hello all,
thanks for your reply and sorry for this delay ..
@eirikur => sorry but...
--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 6:25 am

#1979716
RE: db slow ?

christophe.bernard 47659 - Monday, February 12, 2018 8:29 AM
Hello all,
we have a database under sql server 2008.
This db contains some tables 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 14, 2018 at 6:23 am

#1979715
RE: Valentines Day for Data Professionals

I took a computer course in high school way back in 1968. Have been hooked on data and the machines/software that handles it ever since. Looking back to where I'm at...
--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 6:21 am

#1979713
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, February 13, 2018 3:40 PM
If someone isn't good at programming and dislikes it, why are they in this...
--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 6:11 am

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

Viewing 15 posts - 12,931 through 12,945 (of 59,095 total)