Jeff Moden

Forum Replies Created

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

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

You also 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)

March 4, 2018 at 12:09 pm

#1981888

RE: updates are not happening through ssms

SSMS and the related "Edit" GUI is nothing more than an application. In this case, it's like many other applications where it displays some data, allows you to make...

--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 4, 2018 at 12:03 pm

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

DesNorton - Saturday, March 3, 2018 1:00 PM

I would also consider separating Directories and Files into their own tables.

I'll suggest against putting...

--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 3, 2018 at 5:52 pm

#1981864
RE: Breaking into SQL Development job with irrelevant degree

evaslash - Friday, March 2, 2018 8:05 PM

I am looking to getting into a career as a database developer....

--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 3, 2018 at 8:35 am

#1981848
RE: updates are not happening through ssms

dastagiri16 - Saturday, March 3, 2018 6:40 AM

Phil Parkin - Saturday, March 3, 2018 6:26 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)

March 3, 2018 at 8:13 am

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

coolchaitu - Saturday, March 3, 2018 6:52 AM

GilaMonster - Saturday, March 3, 2018 6:30 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)

March 3, 2018 at 7:56 am

#1981844

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