Jeff Moden

Forum Replies Created

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

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

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

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