Forum Replies Created

Viewing 15 posts - 4,096 through 4,110 (of 8,761 total)

  • RE: table

    PJ_SQL (1/4/2016)

    What does this mean?

    CREATE TABLE [dbo].[A](

    [TimestampCreate] [dbo].[TimestampCreate] NOT NULL

    )

    dbo.timestampcreate mean?

    Are you using MySQL/MariaDB? This is an enumeration/identity column on those rdbms

    😎

    January 4, 2016 at 4:35 pm

    #1849410

  • RE: It's the end of the year

    For fun and completion, comparison of the previously posted "short" methods

    😎

    Test harness

    USE tempdb;

    GO

    SET NOCOUNT ON;

    DECLARE @SAMPLE_SIZE INT = 2000000;

    --/*

    IF OBJECT_ID(N'dbo.TBL_METHOD_TEST' ) IS NOT...

    January 4, 2016 at 4:31 pm

    #1849409

  • RE: It's the end of the year

    Alvin Ramard (1/4/2016)

    Eirikur Eiriksson (1/4/2016)

    Alvin Ramard (1/4/2016)

    Eirikur Eiriksson (1/4/2016)

    Jeff Moden (1/4/2016)

    Lynn Pettis (1/4/2016)

    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY,...

    January 4, 2016 at 4:05 pm

    #1849405

  • RE: Replicating data from 2014 to 2005 - temporarily

    That makes things somewhat easier, how complex are the schemas and what is the cardinality?

    😎

    January 4, 2016 at 3:57 pm

    #1849402

  • RE: It's the end of the year

    Alvin Ramard (1/4/2016)

    Eirikur Eiriksson (1/4/2016)

    Jeff Moden (1/4/2016)

    Lynn Pettis (1/4/2016)

    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0,...

    January 4, 2016 at 3:54 pm

    #1849401

  • RE: It's the end of the year

    Jeff Moden (1/4/2016)

    Lynn Pettis (1/4/2016)

    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0));

    With...

    January 4, 2016 at 3:30 pm

    #1849392

  • RE: It's the end of the year

    Lynn Pettis (1/4/2016)

    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0));

    Slow / lazy...

    January 4, 2016 at 3:21 pm

    #1849387

  • RE: Replicating data from 2014 to 2005 - temporarily

    Quick question, what is the recovery window's size, that is how much time can you spend on reverting?

    😎

    January 4, 2016 at 2:57 pm

    #1849379

  • RE: Why Scalar Functions Can Be Costly

    Alan.B (1/4/2016)

    I been banging my head trying to beat that mTVF for several months :hehe:

    Anything to ease the pain cause that got to hurt:-D

    😎

    January 4, 2016 at 2:27 pm

    #1849371

  • RE: Why Scalar Functions Can Be Costly

    Alan.B (1/4/2016)

    Eirikur Eiriksson (1/4/2016)

    Worse still are the multi-statement table-valued functions, in fact there is no excuse or justification for using those.

    I agree with this 99.9999% of the time but I...

    January 4, 2016 at 2:02 pm

    #1849355

  • RE: Today's Random Word!

    crookj (1/4/2016)

    TomThomson (1/4/2016)

    HappyGeek (1/4/2016)

    Ed Wagner (1/4/2016)

    DonlSimpson (1/4/2016)

    whereisSQL? (1/4/2016)

    Eirikur Eiriksson (1/4/2016)

    Ed Wagner (1/4/2016)

    Grumpy DBA (1/4/2016)

    Ed Wagner (12/31/2015)

    Luis Cazares (12/31/2015)

    Ed Wagner (12/31/2015)

    DonlSimpson (12/31/2015)

    Yoda

    Qui-Gon

    Obi-Wan

    Anakin

    Whiner

    Users

    Function

    Dysfunction

    Staind

    Paint

    Red

    Flag

    Banner

    Slogan

    January 4, 2016 at 11:42 am

    #1849302

  • RE: Why Scalar Functions Can Be Costly

    bjh1977 (1/4/2016)

    Small correction required - UDFs came in as part of 2000 didn't they?

    That's correct.

    😎

    January 4, 2016 at 10:41 am

    #1849279

  • RE: Why Scalar Functions Can Be Costly

    Phil Parkin (1/4/2016)

    TheSQLGuru (1/4/2016)

    lucien.jacquet (1/4/2016)

    My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it...

    January 4, 2016 at 10:39 am

    #1849277

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/4/2016)

    A bit late, but best wishes for everyone!

    BLTN:-D

    😎

    January 4, 2016 at 7:44 am

    #1849224

  • RE: Today's Random Word!

    Ed Wagner (1/4/2016)

    Grumpy DBA (1/4/2016)

    Ed Wagner (12/31/2015)

    Luis Cazares (12/31/2015)

    Ed Wagner (12/31/2015)

    DonlSimpson (12/31/2015)

    Yoda

    Qui-Gon

    Obi-Wan

    Anakin

    Whiner

    Users

    Function

    January 4, 2016 at 6:19 am

    #1849193

Viewing 15 posts - 4,096 through 4,110 (of 8,761 total)