Forum Replies Created

Viewing 15 posts - 121 through 135 (of 819 total)

  • RE: Data Type Precedence

    Rune Bivrin - Thursday, October 5, 2017 1:05 AM

    Nice one. I got it wrong, simply because I figured adding two dates just...

  • RE: Date fun

    Ahahaha, good fun!

  • RE: Logical Query Processing Filters

    Rune Bivrin - Friday, September 29, 2017 12:04 AM

    Bzzzt!

    Tht's true! I agree.

  • RE: Temporary tables SCOPE

    Christian4143 - Tuesday, September 26, 2017 7:54 AM

    Just to add:

    There is different behavior on SQL-Server 2012....

  • RE: Compressing Integers

    Here the script:

    CREATE TABLE dbo.LotsofIntegers1 (ID INT) WITH (DATA_COMPRESSION = PAGE);
    CREATE TABLE dbo.LotsofIntegers2 (ID BIGINT) WITH (DATA_COMPRESSION = ROW);
    CREATE TABLE dbo.LotsofIntegers3 (ID BIGINT) WITH...

  • RE: When sp_HelpText is not so helpful!

    Another "bug" is when you rename a stored procedure and run sp_helptext.
    It returns the create of stored proc with the old name:
    create procedure A
    as
    select 1 as...

  • RE: Temporary tables SCOPE

    ChrisCarsonSQL - Thursday, September 7, 2017 4:35 PM

    I must be missing something because I tried to execute this SQL and all I...

  • RE: Concurrency in System Versioned Temporal Tables

    Good JOB!
    Thanks!

  • RE: Working for Fun

    We work!
    :-))

  • RE: The Offensive Line

    Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    It may be my lack of understanding of American Football positions, but I really...

  • RE: The Missing Price

    n.ryan - Monday, July 17, 2017 3:16 AM

    That was my thought as well - there were two valid answers, and fixing neither...

  • RE: Dynamic SQL

    Sean Lange - Tuesday, July 11, 2017 2:30 PM

    Carlo Romagnano - Friday, July 7, 2017 1:32 AM

  • RE: Dropping PKs

    Confused question!
    If the author intended the primary key is clustered, this apply (from BOL):

    When a constraint that created a clustered index is deleted, the data rows that...

  • RE: Dynamic SQL

    Here a cursor free version:
    DECLARE @TableName SYSNAME = 'MyTable',@Schema SYSNAME = 'dbo', @sql NVARCHAR(MAX) = '', @max-2 INT
    ,@UnionALL NVARCHAR(11)= '';

    SELECT @sql += @UnionALL +...

  • RE: OUTPUT clause with an update

    tom.w.brannon - Wednesday, June 21, 2017 5:45 AM

    I don't understand why deleted only shows the first row from each group.  The join...

Viewing 15 posts - 121 through 135 (of 819 total)