Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,781 through 12,795 (of 59,102 total)

RE: Create Index Script with Fill Factor Question

Sergiy - Tuesday, March 6, 2018 6:47 PM
Jeff Moden - Tuesday, March 6, 2018 6:28 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)

March 6, 2018 at 7:54 pm

#1982180
RE: Create Index Script with Fill Factor Question

Sergiy - Tuesday, March 6, 2018 5:39 PM
It does not matter at all.
FIll Factor is only taken into consideration when an index...
--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)

March 6, 2018 at 6:28 pm

#1982176
RE: Help me in designing table and its indexes

RonKyle - Tuesday, March 6, 2018 10:11 AM
While there's always an exception, I've not yet seen where separation to multiple tables...
--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)

March 6, 2018 at 5:44 pm

#1982174
RE: Help me in designing table and its indexes

Speaking of the OP...
@ SQLAddict01 , your absence from your own request for help is a bit conspicuous. Any feedback on...
--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)

March 6, 2018 at 9:44 am

#1982102
RE: Help me in designing table and its indexes

RonKyle - Tuesday, March 6, 2018 4:25 AM
RonKyle - Monday, March 5, 2018 5:06 AM
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)

March 6, 2018 at 9:36 am

#1982099
RE: updates are not happening through ssms

dastagiri16 - Sunday, March 4, 2018 9:12 PM
Jeff Moden - Sunday, March 4, 2018 12:09 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)

March 5, 2018 at 8:36 pm

#1982041
RE: How does SQL Server handle concurrent operations?

junk.mail291276 - Monday, March 5, 2018 3:10 PM
Hello everyone,
Thanks for all the replies. Sorry for the late response.
On Friday, I was preparing...
--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)

March 5, 2018 at 8:34 pm

#1982040
RE: Help me in designing table and its indexes

RonKyle - Monday, March 5, 2018 5:06 AM
This might be a case where it depends what you want to do with 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)

March 5, 2018 at 8:27 pm

#1982039
RE: How to bring database just before the delete occurred.

coolchaitu - Sunday, March 4, 2018 10:26 PM
Jeff Moden - Sunday, March 4, 2018 5:17 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)

March 5, 2018 at 6:12 am

#1981929

RE: Help me in designing table and its indexes

SQLAddict01 - Friday, March 2, 2018 3:07 PM