Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,606 through 10,620 (of 59,099 total)

RE: How to study the layout of a database?

primitivefuture2006 - Tuesday, September 18, 2018 6:14 PM
Please. I am a noob but I really want to learn. Sorry if my question...
--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)

November 13, 2018 at 7:24 pm

#2013392
RE: Advice for Newcomers

primitivefuture2006 - Friday, November 2, 2018 1:48 PM
Steve Jones - SSC Editor - Friday, November 2, 2018...
--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)

November 13, 2018 at 7:15 pm

#2013391
RE: Fundamentals

primitivefuture2006 - Tuesday, November 13, 2018 6:46 AM
We still expect anyone working in those areas knows how to backup a database,...
--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)

November 13, 2018 at 7:07 pm

#2013390
RE: how to find the lowest usage of a database

Wondering why data type is your biggest concern ?
Couple of reasons...
1. You've underestimated the size the index will be. Each row 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)

November 13, 2018 at 6:35 pm

#2013389
RE: character data type selection in table design

ChrisM@Work - Tuesday, November 13, 2018 9:52 AM
What's wrong with 'Y' and 'N' as CHAR(1)? Unlike 0 and 1, there's no chance...
--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)

November 13, 2018 at 5:56 pm

#2013386
RE: character data type selection in table design

Jonathan AC Roberts - Tuesday, November 13, 2018 9:36 AM
Jeff Moden - Tuesday, November 13, 2018 9:14 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)

November 13, 2018 at 5:51 pm

#2013385
RE: how to find the lowest usage of a database

WhiteLotus - Tuesday, November 13, 2018 3:23 PM
Thanks All 🙂
There might be better advice if we knew more so, with that thought...
--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)

November 13, 2018 at 4:29 pm

#2013383
RE: how to find the lowest usage of a database

Jonathan AC Roberts - Tuesday, November 13, 2018 7:43 AM
I've had problems creating a large index even if ONLINE=ON is set....
--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)

November 13, 2018 at 4:23 pm

#2013382
RE: character data type selection in table design

Jonathan AC Roberts - Tuesday, November 13, 2018 8:07 AM
Jeff Moden - Tuesday, November 13, 2018 7:56...
--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)

November 13, 2018 at 9:14 am

#2013345
RE: Replacing string in text file with another string

Phil Parkin - Tuesday, November 13, 2018 8:12 AM
Jeff Moden - Tuesday, November 13, 2018 7:37 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)

November 13, 2018 at 9:11 am

#2013344
RE: character data type selection in table design

DinoRS - Tuesday, November 13, 2018 8:36 AM
snomadj - Tuesday, November 13, 2018 3:55 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)

November 13, 2018 at 8:58 am

#2013339
RE: character data type selection in table design

snomadj - Tuesday, November 13, 2018 3:55 AM
Let's say I have a field that will have a max value of 'yes'.
What difference...
--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)

November 13, 2018 at 7:56 am

#2013324
RE: how to find the lowest usage of a database

WhiteLotus - Tuesday, November 13, 2018 2:42 AM
Hi Guys
How do we find the lowest usage of a database ?
I need ...
--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)

November 13, 2018 at 7:40 am

#2013321
RE: Replacing string in text file with another string

VoldemarG - Monday, November 12, 2018 2:59 PM
I finally got it working THIS WAY:
   public void Main()
        {
    string fileText;
    try
    {
      fileText = System.IO.File.ReadAllText(Dts.Variables["FullFilePath"].Value.ToString());
      fileText =...
--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)

November 13, 2018 at 7:37 am

#2013320
RE: Are the posted questions getting worse?

Lynn Pettis - Monday, November 12, 2018 10:01 PM
Yes, that would be nice but the darling that did this in a...
--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)

November 13, 2018 at 6:39 am

#2013310

Viewing 15 posts - 10,606 through 10,620 (of 59,099 total)