Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 49,552 total)

  • RE: Having trouble finding the definition of a foreign key constraint

    I don't think that's what the error's saying. If you tried to create a foreign key constraint that already existed (their names have to be unique, you can have multiple...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 10:46 am

    #1922008

  • RE: What data should be converted/formatted in DB, vs in-app?

    Ideally, formatting for display done where and when the data is displayed, not in the database. The database should care about the data, not it's visual representation.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 7:07 am

    #1921929

  • RE: Not Excited by Linux

    chrisn-585491 (1/11/2017)

    Although it's a good technical achievement, I'm not sure what the business case for SQL Server on Linux is, outside a large customer(s) insisting that it run on Linux....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 7:00 am

    #1921924

  • RE: format number

    ThomasRushton (1/11/2017)

    You could also use

    SELECT FORMAT(10.500,'N1')

    See documentation for the FORMAT function.

    Although FORMAT is extremely slow compared to CONVERT.

    https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 5:45 am

    #1921891

  • RE: included Column & Clustering Key

    Yes, if the clustered index is changed, all nonclustered indexes are rebuilt with the new clustered index key in them.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 4:44 am

    #1921874

  • RE: Are the posted questions getting worse?

    I really would like to attend Bits this year (hint, hint)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 3:29 am

    #1921857

  • RE: Decommissioning SQl 2005 server

    Backup the DB on 2005, copy the backup to the 2012 server, restore it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 3:06 am

    #1921854

  • RE: sql compile error: reference to non-existent column

    Put the part that has the column that may not exist in dynamic SQL

    EXEC ('<sql statement here>')

    That error is indeed a parse-time error, the entire batch gets parsed before anything...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 2:50 am

    #1921852

  • RE: multiple small indexes or large covering

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    Hidden indexes?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 2:19 am

    #1921844

  • RE: Near Real time copy of OLTP for SQL2014

    Andrew..Peterson (1/10/2017)

    I'll look into. No problems with replication, but with lots of tables, it adds more administrative work that is desired.

    Set it up once (selecting all tables is a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 2:16 am

    #1921842

  • RE: Is SQL Server 2008 and 2008 R2 completely separate versions?

    rjjh78 (1/10/2017)

    Thank you for your reply. I have 2008 installed and was trying to apply SQL Server 2008 R2 Service Pack.

    That'll work about as well as trying to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 2:14 am

    #1921841

  • RE: included Column & Clustering Key

    Rechana Rajan (1/11/2017)

    If that is the case the lookup for noncluster index will change to new cluster key right?

    ???

    Also if i explicitly specify the cluster key in a nonclustered index...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 2:10 am

    #1921840

  • RE: From which Microsoft version 32 - bit was stooped?

    bsbabu2008 (1/10/2017)

    that means SQL Server 2008 R2 is the last edition for 32 - bit ?

    No.

    SQL 2012 had a 32-bit version, so did SQL 2014. The only version that doesn't...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 11, 2017 at 2:09 am

    #1921839

  • RE: included Column & Clustering Key

    Rechana Rajan (1/10/2017)

    My doubt is when we create a Non clustered index the clustering key is already a part of it and then why adding PK column as included help...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2017 at 3:39 am

    #1921573

  • RE: Queries over HAG instances, SQL 2012

    4-part naming requires a linked server, the first part being the linked server name.

    Without linked servers, you're not going to be able to directly query another server from this one.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 10, 2017 at 2:25 am

    #1921563

Viewing 15 posts - 1,906 through 1,920 (of 49,552 total)