Forum Replies Created

Viewing 15 posts - 8,881 through 8,895 (of 49,552 total)

  • RE: Drop table not working

    Eirikur Eiriksson (5/28/2014)

    Quick thought, as the table is in tempdb, change the statement to

    DROP TABLE tempdb..#NewEmployees

    Unnecessary. The # designates it as a temp table, temp tables are always in...

    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

    May 29, 2014 at 2:23 am

    #1717255

  • RE: Need to convert PK to clustered but it is referenced by a FK

    SQL Guy 1 (5/28/2014)

    1. Drop FK.

    2. Drop PK.

    3. Recreate PK (as clustered)

    4. Recreate FK

    Yup. Assuming there's only one foreign key that 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

    May 28, 2014 at 2:38 pm

    #1717166

  • RE: SQLServerCentral content restrictions

    I suspect that's there to 'prevent' someone from copying the entire scripts collection, sticking it on a DVD and selling it, or collecting the articles into an ebook and selling...

    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

    May 28, 2014 at 1:38 pm

    #1717144

  • RE: Corrupt?? Or what is going on

    Ok... Take a read through this when you get a chance, and if you have questions please ask: http://www.sqlservercentral.com/stairway/73776/ (Yes, I know it's long)

    Also, if your backups start to grow...

    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

    May 28, 2014 at 1:35 pm

    #1717143

  • RE: using select Max with insert

    Depends. Is anything changing the value of MAX(sectionnumber) in dbo.BNYWorkingSecTable?

    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

    May 28, 2014 at 11:36 am

    #1717102

  • RE: Corrupt?? Or what is going on

    lawson2305 (5/28/2014)

    ok sorry for my misunderstanding but I thought that is why you do Log backups to commit the data to the DB and clear the transaction data from 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

    May 28, 2014 at 9:38 am

    #1717073

  • RE: Corrupt?? Or what is going on

    Backups don't commit transactions, so not sure what you want there.

    I don't know what was done when the DB ran out of space, so can't comment on whether it's strange...

    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

    May 28, 2014 at 7:43 am

    #1717013

  • RE: Deleting default indexes in CRM 2011 database - 2008 R2 Standard Edition SP1-x64

    If it's Microsoft's CRM (the vendor is Microsoft), then making any schema changes is a violation of the support agreements afaik, will probably result in you losing any support from...

    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

    May 28, 2014 at 2:24 am

    #1716921

  • RE: Corrupt?? Or what is going on

    lawson2305 (5/27/2014)

    Now if I got in Shrink by file I get some strange data saying currently allocated space of 1300 MB and 82.81 MB free.

    Ok if I go into Shrink...

    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

    May 27, 2014 at 3:13 pm

    #1716869

  • RE: Corrupt?? Or what is going on

    Can you run DBCC UpdateUsage and then check free space again?

    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

    May 27, 2014 at 1:07 pm

    #1716827

  • RE: Indexes

    If you have exact duplicate indexes, it doesn't matter which you drop, they're identical.

    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

    May 27, 2014 at 1:02 pm

    #1716823

  • RE: Is it good to pass 70-433 now or should go for SQL 2012 developer certification?

    Koen Verbeeck (5/27/2014)

    Is it me, but all links to microsoft learning lead to dead ends?

    It's you. That link works find for me.

    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

    May 27, 2014 at 12:32 pm

    #1716799

  • RE: Indexes

    ramana3327 (5/27/2014)

    So I have to find a strong supporting point why I choose to drop that indexes over the other..

    And you're considering dropping one that is being used, as shown...

    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

    May 27, 2014 at 12:27 pm

    #1716796

  • RE: SQL Server Max Memory Verus Actual Usage

    Clint-525719 (5/27/2014)

    Can you clarify for me a bit? Why is using task manager/resource monitor bad for SQL memory monitoring?

    Because it doesn't always show the correct values. Specifically it will...

    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

    May 27, 2014 at 10:50 am

    #1716768

  • RE: Indexes

    ramana3327 (5/27/2014)

    In that case, shall we drop the index?

    Why?

    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

    May 27, 2014 at 10:41 am

    #1716766

Viewing 15 posts - 8,881 through 8,895 (of 49,552 total)