Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,651 through 10,665 (of 59,065 total)

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

November 6, 2018 at 5:43 pm

#2012640
RE: How can I get a set Date and Time Range between Yesterday and Today?

drew.allen - Tuesday, November 6, 2018 12:25 PM
ScottPletcher - Tuesday, November 6, 2018 7:46 AM

November 6, 2018 at 5:38 pm

#2012638

Viewing 15 posts - 10,651 through 10,665 (of 59,065 total)