Jeff Moden

Forum Replies Created

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

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

inshah2297 - Wednesday, December 26, 2018 4:17 AM
RBAR is articulated ree-bar and is a Modenism for Line By-Anguishing Column. Initial move towards...
--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:10 am

#2017335
RE: Changing Datatype from Int to TinyInt - How much space can be recovered?

Mahesh Bote - Wednesday, December 26, 2018 12:48 AM
Jeff Moden - Tuesday, December 25, 2018 4:07 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:05 am

#2017334
RE: Christmas DevOps

Eric M Russell - Wednesday, December 26, 2018 7:33 AM
Hey, the days leading up to Christmas is the perfect time for team...
--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 7:47 am

#2017323
RE: Changing Datatype from Int to TinyInt - How much space can be recovered?

Lynn Pettis - Tuesday, December 25, 2018 12:10 PM
Mahesh Bote - Tuesday, December 25, 2018 8:09 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)

December 25, 2018 at 4:07 pm

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

jcelko212 32090 - Tuesday, December 25, 2018 3:29 PM
It got strange at times. The kids could not conceptually separate a number, a...
--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 25, 2018 at 3:49 pm

#2017303
RE: Christmas DevOps

'Twas the night before Christmas and all through "The Room",
The servers were humming and no apps have gone "Boom'
This is all possible because we worked as a Team,
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 24, 2018 at 8:57 pm

#2017295

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