Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,681 through 10,695 (of 59,095 total)

RE: Composite indexes; performance

AER - Thursday, November 8, 2018 8:29 AM
Hi everybody,
I have couple quick questions for the DBAs.
We have 2 heavy SELECT statements 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)

November 8, 2018 at 9:14 am

#2012850
RE: Backup to Recovery

George Vobr - Thursday, November 8, 2018 8:02 AM
Thanks Steve for this interesting question, but your explanation de facto confirms the correctness...
--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)

November 8, 2018 at 8:47 am

#2012835
RE: how to get rows from two datetime fields with hours on morning time.

If this is something that needs to be accomplished on a regular basis, add a persisted computed column to the table with the TIME datatype so there's a better...
--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)

November 8, 2018 at 8:11 am

#2012823
RE: Backup to Recovery

edwardwill - Thursday, November 8, 2018 3:55 AM
I'm interested to know what real-world scenario this would accommodate (as opposed, for example, to...
--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)

November 8, 2018 at 8:03 am

#2012819
RE: How to overcome missing 0x for varbinary?

BOR15K - Thursday, November 8, 2018 5:26 AM
I have a virbinary(MAX) column which contains an encrypted data. We use standard encryption method...
--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)

November 8, 2018 at 7:48 am

#2012813
RE: Wasted Work

From the article...

To me, this is one of the advantages of working in a DevOps style flow, with small changes being developed and released. If clients...
--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)

November 7, 2018 at 4:28 pm

#2012768
RE: Write Conflict

barry.nielson - Wednesday, November 7, 2018 2:16 PM
Hi Mark. that's Interesting. Thanks for the tip. I'll look into it. For example can...
--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)

November 7, 2018 at 2:34 pm

#2012759
RE: DRI or No DRI?

Steve Jones - SSC Editor - Sunday, July 17, 2011 11:33 AM
I think there are places where DRI isn't needed, but not...
--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)

November 7, 2018 at 8:04 am

#2012697
RE: While Loop Stored Procedure

debasis.yours - Tuesday, November 6, 2018 9:19 AM
Hi,
Can the following approach help?

CREATE PROCEDURE ExecuteBatch
AS
BEGIN
    DECLARE @CurrentMonth INT
    DECLARE @MaxMonth INT
    DECLARE @Year...
--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)

November 7, 2018 at 7:48 am

#2012694
RE: Caution about Restoring via SSMS v17

zNick - Wednesday, November 7, 2018 3:31 AM
So, any interesting *terrible* stories behind this article? Feel free to share.... (Wanna get my...
--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)

November 7, 2018 at 6:12 am

#2012678
RE: Using SUM() In CASE Statement / Best Practices

mitzyturbo - Tuesday, November 6, 2018 10:25 AM
Triangular Join - I knew there was a name for that (wrote my result set...
--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)

November 6, 2018 at 7:46 pm

#2012646
RE: While Loop Stored Procedure

Daniel.Bayliss - Tuesday, November 6, 2018 8:59 AM
Hi,
Can help me with an issue I am facing. I need to create a single...
--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)

November 6, 2018 at 7:35 pm

#2012645
RE: Caution about Restoring via SSMS v17

ScottPletcher - Tuesday, November 6, 2018 12:15 PM
Wow, I'm surprised. That's certainly interesting, and not what I expected.
I agree to both...
--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)

November 6, 2018 at 6:39 pm

#2012643
RE: Explaining Our Professions to Our Parents

skeleton567 - Tuesday, November 6, 2018 6:40 AM
Well, I know that my parents would thoroughly understand my career, even though I lost...
--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)

November 6, 2018 at 5:58 pm

#2012642
RE: Insert Date from integer month and year columns in the same table

Eirikur Eiriksson - Monday, November 5, 2018 10:59 PM
Jeff Moden - Monday, November 5, 2018 8:25 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)

November 6, 2018 at 5:43 pm

#2012640

Viewing 15 posts - 10,681 through 10,695 (of 59,095 total)