Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 49,552 total)

  • RE: Distinct query with all columns

    Yup, de-dupe the table.

    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

    July 19, 2017 at 11:00 am

    #1951702

  • RE: Distinct query with all columns

    As-is, there's little to nothing you can do. The query has no where clause, so there's no indexes that will help. The distinct forces a sort (or hash table) and...

    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

    July 19, 2017 at 10:22 am

    #1951684

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Wednesday, July 19, 2017 10:09 AM

    We've removed write access for the devs, so this shouldn't happen...

    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

    July 19, 2017 at 10:16 am

    #1951683

  • RE: Are the posted questions getting worse?

    Phil Parkin - Wednesday, July 19, 2017 8:49 AM

    Is this cheating?

    EXEC sys.xp_cmdshell 'date /t';
    EXEC sys.xp_cmdshell 'time /t';

    Now I'm tempted 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

    July 19, 2017 at 9:40 am

    #1951673

  • RE: DBCC

    No user action is required. There's nothing you need to do there, nothing's broken, nothing needs fixing.
    It's an informational message telling you that CheckDB ran and found no errors.

    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

    July 19, 2017 at 9:33 am

    #1951669

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, July 19, 2017 7:03 AM

    GilaMonster - Wednesday, July 19, 2017 6:57 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

    July 19, 2017 at 7:18 am

    #1951615

  • RE: Are the posted questions getting worse?

    jasona.work - Wednesday, July 19, 2017 5:44 AM

    And now, to continue stirring the pot...
    :hehe:
    TBH, I see exactly where Steve was...

    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

    July 19, 2017 at 6:57 am

    #1951606

  • RE: How to remove In-memory optimized fie and file group

    Have you removed all the objects in that filegroup?

    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

    July 19, 2017 at 3:24 am

    #1951549

  • RE: Database not available

    Is it still unavailable?

    If you query sys.database, what's the exact value for State_desc for that database?

    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

    July 19, 2017 at 1:13 am

    #1951536

  • RE: User_update high but no user seek/scan. Is this an effective index?

    So in 4 days, the index has been modified a large number of times as data changed, but never read.
    Does that sound efficient and useful?

    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

    July 19, 2017 at 1:02 am

    #1951534

  • RE: Backup detected log corruption in database

    Good.
    Now size the log file properly, set the recovery to full and take a full backup to start the log chain, then you should be back to normal.

    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

    July 18, 2017 at 10:33 am

    #1951451

  • RE: 70-462 - practicing administrative tasks on my home PC

    You might need more than 2. You need some form of shared storage and a domain controller.

    There are definitely blog posts on setting up this kind of lab,...

    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

    July 18, 2017 at 8:44 am

    #1951426

  • RE: 70-462 - practicing administrative tasks on my home PC

    Try with multiple VMs. I don't think you can cluster two instances on teh same machine, but you can cluster instances in two VMs

    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

    July 18, 2017 at 6:56 am

    #1951380

  • RE: To find the when SQL server was rebooted couple of times earlier?

    Or look in the Windows Event log for the Windows events around shutdown and restart.

    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

    July 18, 2017 at 6:48 am

    #1951378

  • RE: Partitions on SSD drive

    Eliyahu - Saturday, July 15, 2017 3:58 PM

     In my case, is there any point to have ARRAY 1 partitioned into 2 logical...

    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

    July 18, 2017 at 6:39 am

    #1951372

Viewing 15 posts - 1,096 through 1,110 (of 49,552 total)