Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,231 through 10,245 (of 59,102 total)

RE: Suggestions on How to Improve Delete

RGP - Thursday, December 27, 2018 4:33 PM
Thanks for the quick response, Iâ€™ll post the code soon
Also post how many "records" there...
--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)

December 27, 2018 at 4:50 pm

#2017472
RE: SQL Query to Calculate Monthly Budget

madanvenkat535 3293 - Thursday, December 27, 2018 12:56 PM
Mike01 - Thursday, December 27, 2018 12:03 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)

December 27, 2018 at 3:39 pm

#2017465
RE: Parent/Child - where I am standing

Lynn Pettis - Thursday, December 27, 2018 2:46 PM
You and your ISO Standards. I am still waiting for you to provide...
--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)

December 27, 2018 at 3:26 pm

#2017464
RE: Convert string MMDDYYYY to a date

below86 - Thursday, December 27, 2018 8:28 AM
Jeff Moden - Friday, December 21, 2018 2:06 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)

December 27, 2018 at 2:25 pm

#2017460
RE: Primary keys for an OLTP database

Carlo Romagnano - Thursday, December 27, 2018 9:28 AM
You may have differerent results if you insert rows in separated batch 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)

December 27, 2018 at 9:38 am

#2017429
RE: Primary keys for an OLTP database

RonKyle - Thursday, December 27, 2018 9:18 AM
Please...
--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)

December 27, 2018 at 9:31 am

#2017427
RE: Primary keys for an OLTP database

Evgeny Garaev - Wednesday, December 26, 2018 11:46 PM
Comments posted to this topic are about the item Primary keys for...
--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)

December 27, 2018 at 9:18 am

#2017424
RE: Primary keys for an OLTP database

Thom A - Thursday, December 27, 2018 3:05 AM
Thanks Evgeny. I didn't actually know there was a NEWSEQUENTIALID() function. I...
--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)

December 27, 2018 at 9:05 am

#2017417
RE: Primary keys for an OLTP database

RonKyle - Thursday, December 27, 2018 8:04 AM
With...
--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)

December 27, 2018 at 9:01 am

#2017414
RE: Primary keys for an OLTP database

mtassin - Thursday, December 27, 2018 7:15 AM
IDENTITY / SEQUENCE will always be the fastest because the keys are smallest and in...
--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)

December 27, 2018 at 8:50 am

#2017410
RE: Types of DBA's ???

To be honest, I don't believe that most people actually knew or currently know what a DBA actually does. I think the job description of DBA started out with accurate...
--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)

December 27, 2018 at 8:12 am

#2017407
RE: Total count in Paging Query taking more time

jkramprakash - Thursday, December 27, 2018 3:38 AM
CREATE PROCEDURE [dbo].[PAGING_NEW]
@parameter1 NVARCHAR(200),
@parameter2 NVARCHAR(200),
@PAGE INT,
AS
...
--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)

December 27, 2018 at 7:44 am

#2017402
RE: Parent/Child - where I am standing

Lynn Pettis - Wednesday, December 26, 2018 2:06 PM
A good explanation of Common Core Math but a complete straw man argument...
--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)

December 26, 2018 at 2:08 pm

#2017365
RE: Parent/Child - where I am standing

jcelko212 32090 - Wednesday, December 26, 2018 1:50 PM
Jeff Moden - Tuesday, December 25, 2018 3:49 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)

December 26, 2018 at 2:06 pm

#2017364
RE: Validate date stored as a string as a complete, valid date

Now all I have to do is get the OP to confirm and/or clarify the requirements according to the questions I asked.
--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)

December 26, 2018 at 11:00 am

#2017346

Viewing 15 posts - 10,231 through 10,245 (of 59,102 total)