Forum Replies Created

Viewing 15 posts - 31 through 45 (of 49,552 total)

  • RE: Are cl and clst system indexs?

    They do have tables associated with them, but only user tables are in sys.tables.
    Edit: And they're not two indexes. Two index names, yes, but 65 indexes in my SQL...

    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 9, 2019 at 12:38 pm

    #2018451

  • RE: Restore sql server backup

    In this case the step-by-step process is irrelevant, since the backup in question is damaged, possibly in copy.

    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 9, 2019 at 12:27 pm

    #2018448

  • RE: Decode waits on Object resource

    Maybe check the SQLMonitor documentation?

    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

    December 18, 2018 at 2:07 am

    #2016629

  • RE: How to clean buffer cache without using DBCC command?

    SQL Guy 1 - Monday, November 26, 2018 9:10 AM

    I need to find a way to indirectly clean cache on DEV...

    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

    December 17, 2018 at 10:23 am

    #2016544

  • RE: Decode waits on Object resource

    tttcoding - Monday, December 17, 2018 2:38 AM

     OBJECT: 7:480772820:27.

    Database ID 7
    Object ID 480772820
    Index ID 27

    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

    December 17, 2018 at 9:45 am

    #2016534

  • RE: CREATE EXTERNAL DATA SOURCE

    It has both, at least according to the docs. Don't have a SQLDB on hand to try.

    https://azure.microsoft.com/en-us/updates/files-from-azure-blob-storage-to-sql-database/
    https://azure.microsoft.com/en-us/updates/preview-loading-files-from-azure-blob-storage-into-sql-database/

    What it doesn't have is...

    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

    December 17, 2018 at 8:30 am

    #2016519

  • RE: Are the posted questions getting worse?

    Is that damn thread about TOP still going on?

    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

    November 14, 2018 at 1:52 pm

    #2013555

  • RE: SELECT TOP 1 on Primary Key?

    I'm sorry you haven't understood my explanations.

    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

    November 10, 2018 at 3:32 pm

    #2013110

  • RE: SELECT TOP 1 on Primary Key?

    AdrianLParker+sqlservercentral.com - Saturday, November 10, 2018 10:26 AM

    As a developer I'd be a little surprised if the special condition, "if the...

    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

    November 10, 2018 at 12:13 pm

    #2013090

  • RE: SELECT TOP 1 on Primary Key?

    AdrianLParker+sqlservercentral.com - Friday, November 9, 2018 8:26 PM

    I realize what those queries can return. Despite intuitively knowing that the first can only...

    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

    November 10, 2018 at 4:26 am

    #2013057

  • RE: TempDB

    Start with 4 data files, 1 log file. If there's still contention, add another 4 data files. Repeat until there's no more contention.
    And make sure that they're all the...

    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

    November 9, 2018 at 4:44 pm

    #2013041

  • RE: Composite indexes; performance

    https://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    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

    November 9, 2018 at 4:43 pm

    #2013040

  • RE: Column data type - Msg 207 Invalid column name

    No.

    The error says exactly what is wrong. Somewhere, either in the insert itself or maybe in a trigger, you're referencing a column that does not exist.

    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

    November 2, 2018 at 12:58 pm

    #2012265

  • RE: Need help with SQL trace

    Yes, with the database_name column.

    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

    November 2, 2018 at 11:45 am

    #2012248

  • RE: Why we schedule copy_only backup on secondary in always on

    Beatrix Kiddo - Friday, November 2, 2018 10:21 AM

    anujkumar.mca - Friday, November 2, 2018 5:34 AM

    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

    November 2, 2018 at 11:45 am

    #2012247

Viewing 15 posts - 31 through 45 (of 49,552 total)