Jeff Moden

Forum Replies Created

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

RE: How to overcome missing 0x for varbinary?

patrickmcginnis59 10839 - Thursday, November 8, 2018 11:59 AM
Jeff Moden - Thursday, November 8, 2018 7:48 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)

November 8, 2018 at 9:09 pm

#2012924
RE: Composite indexes; performance

Jonathan AC Roberts - Thursday, November 8, 2018 10:36 AM
Jeff Moden - Thursday, November 8, 2018 10:25...
--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 10:43 am

#2012877
RE: Composite indexes; performance

Jonathan AC Roberts - Thursday, November 8, 2018 10:15 AM
Jeff Moden - Thursday, November 8, 2018 10:12...
--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 10:25 am

#2012872
RE: Composite indexes; performance

AER - Thursday, November 8, 2018 10:05 AM
Thanks for all your replies.
I know that is not the simple question; that's why 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)

November 8, 2018 at 10:12 am

#2012867
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

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