Forum Replies Created

Viewing 15 posts - 8,956 through 8,970 (of 49,552 total)

  • RE: Full Backup Failure

    Hmmm... guessing.... The log file and the backup files are on the same drive?

    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 22, 2014 at 6:26 am

    #1715667

  • RE: help with query

    Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    The view definitions will also be of great 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

    May 22, 2014 at 6:21 am

    #1715665

  • RE: pro's and cons of shrinking database

    Disadvantage: Expensive, time consuming operation

    Disadvantage: Done excessively will just force the database to re-grow, wasting more resources

    Disadvantage: Massively fragments all 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

    May 22, 2014 at 6:10 am

    #1715661

  • RE: Replication question

    Yup.

    Doesn't matter whether there is a subscriber. Doesn't matter if there are ten suppliers and half of them are offline. The log reader agent reads the publisher's transaction log 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

    May 22, 2014 at 6:01 am

    #1715659

  • RE: Database in Suspect Mode

    Please note: 4 year old thread, and repair allow data loss should never be the first suggestion and should never be suggested without an explanation of the effects.

    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 22, 2014 at 5:01 am

    #1715638

  • RE: How to recover Database from Suspect mode

    Please note: 4 year old thread, and repair allow data loss should never be the first suggestion and should never be suggested without an explanation of the effects.

    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 22, 2014 at 5:00 am

    #1715637

  • RE: Replication question

    DentalDBA (5/21/2014)

    We are wondering what will be the fallout. I assume the distribution database will grow while the DB is offline.

    Probably not even that. Replication has 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

    May 22, 2014 at 4:18 am

    #1715620

  • RE: Replication question

    NickBalaam (5/22/2014)

    If you're using transactional replication, the log file for the publishing database will probably grow too as the VLFs inside that log file won't be marked as inactive (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

    May 22, 2014 at 4:16 am

    #1715618

  • RE: Creating an index, why is it insert into itself?

    Read from the table, insert into the index. It's just how an index creation shows up.

    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 22, 2014 at 4:13 am

    #1715616

  • RE: SQL Profiler - Server side Trace

    Yeah, it's a plug-in, but all it does it provide a GUI, it's not required to use Extended Events. The underlying feature is there without that, just has to be...

    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 22, 2014 at 3:12 am

    #1715602

  • RE: Ghost records still exits

    Until the ghost cleanup runs (which will be almost immediately, in the background)

    If you're impatient, rebuild the clustered 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

    May 22, 2014 at 2:47 am

    #1715597

  • RE: How to insert or update primary key (int) ?!

    Is the column defined as an identity 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

    May 22, 2014 at 2:45 am

    #1715595

  • RE: What is the fastest way to manage date filtering within a query?

    isuckatsql (5/21/2014)

    In my original post, i said:

    "I have a dynamic SQL query"

    I also gave datatypes:

    "@date is an integer."

    "begindate is datetime format."

    Neither of which suggests that there's any conversions...

    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 22, 2014 at 2:43 am

    #1715593

  • RE: What is the fastest way to manage date filtering within a query?

    isuckatsql (5/21/2014)

    "The data types varchar(max) and date are incompatible in the add operator."

    Since it is within a dynamic sql query, i get the above error msg.

    Shouldn't be if you properly...

    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 22, 2014 at 2:34 am

    #1715590

  • RE: sparse file gets deleted from management studio but not from disk

    Was the snapshot online when they dropped it?

    What's the exact command(s) they used?

    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 22, 2014 at 2:21 am

    #1715589

Viewing 15 posts - 8,956 through 8,970 (of 49,552 total)