Jeff Moden

Forum Replies Created

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

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
RE: How to implement taking action based in column value?

Student031 - Monday, February 19, 2018 3:13 PM
Jeff Moden - Monday, February 19, 2018 2:23 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 9:37 am

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

My recommendation is to stop doing paging the old way. You've posted in a 2012 forum. Learn how to use the OFFSET/FETCH methodology of the ORDER BY clause. Please see...
--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 9:25 am

#2017339
RE: Best Practice for batch processing In SQL Server

Miru Seshadri - Wednesday, December 26, 2018 5:50 AM
Thank you Jeff. I will try that.
What is the difference between Xact Abort 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 26, 2018 at 9:13 am

#2017336

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