Forum Replies Created

Viewing 15 posts - 10,006 through 10,020 (of 49,552 total)

  • RE: cannot bulk load

    Does a file named "Sample" (with no extensions) exist in the folder "D:\BEM_Source\"?

    Does the SQL Server service account have permission to that folder?

    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

    February 17, 2014 at 3:20 am

    #1689425

  • RE: Restore fails - No files ready to roll forward.

    In step 7 you need to run the restore WITH NORECOVERY. That leaves the DB nonoperational and able to restore additional backups (differential or log). If you run the restore...

    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

    February 17, 2014 at 3:17 am

    #1689423

  • RE: Query execution time

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    February 15, 2014 at 11:41 am

    #1689313

  • RE: Am I taking crazy pills? Dispute over inner vs. outer join.

    As quoted from someone's sig:

    "Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms."

    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

    February 14, 2014 at 1:56 pm

    #1689220

  • RE: Question about the transaction log

    Matt Crowley (2/14/2014)

    Due to the importance of the log data (for recovery), the log writes are synchronous, so there should be very little if any delay in the recording of...

    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

    February 14, 2014 at 1:55 pm

    #1689219

  • RE: Question about the transaction log

    pooyan_pdm (2/14/2014)

    The final destination of the dirty pages is the data files but they should be pushed to the log file before or at the same time they are being...

    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

    February 14, 2014 at 1:52 pm

    #1689215

  • RE: Am I taking crazy pills? Dispute over inner vs. outer join.

    TheGreenShepherd (2/14/2014)

    Unfortunately, this is a project still in the design phase, so it's not like we're trying to address an existing performance problem or anything.

    So premature optimisation in other...

    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

    February 14, 2014 at 12:48 pm

    #1689191

  • RE: Question about the transaction log

    Matt Crowley (2/14/2014)

    If you are updating 10 million rows, and the update takes 10 minutes, then the log entries (before and after pages) are written to the transaction log all...

    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

    February 14, 2014 at 12:42 pm

    #1689187

  • RE: Question about the transaction log

    pooyan_pdm (2/14/2014)

    1-Is there any other process writing to the Log file other than

    1-checkpoints

    2-transactions getting committed

    ...

    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

    February 14, 2014 at 12:29 pm

    #1689176

  • RE: Am I taking crazy pills? Dispute over inner vs. outer join.

    Set up a test environment, test both multiple times (run each at least 10 times, more is better), analyse results, conclude.

    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

    February 14, 2014 at 12:25 pm

    #1689172

  • RE: Slow running query

    Can you monitor execution plans (via extended events), get a plan from a fast execution and a plan from a slow execution?

    Can you monitor/record wait stats per query during its...

    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

    February 14, 2014 at 6:25 am

    #1689047

  • RE: Data + log folder structure changes

    Be consistent, be clear, be sensible (my rules for naming standards in general)

    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

    February 14, 2014 at 3:31 am

    #1689008

  • RE: Moving Standby/Readonly DB to New server

    MyDoggieJessie (2/13/2014)

    To answer your question, simple take a full backup on the current server, then restore it to the new server. Done.

    A database in StandBy cannot be backed up. Hence...

    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

    February 14, 2014 at 1:01 am

    #1688988

  • RE: How to avoid subquery here with this query , please...

    Why is the subquery a problem?

    It can be written without it, but probably won't change how the query executes.

    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

    February 14, 2014 at 12:59 am

    #1688987

  • RE: Sql database recovery?

    Compact and repair database is an MS Access feature, not a SQL Server one. It works on Access databases.

    Can you be a little clearer about what you have (SQL Server...

    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

    February 13, 2014 at 12:06 pm

    #1688893

Viewing 15 posts - 10,006 through 10,020 (of 49,552 total)