Forum Replies Created

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

  • RE: dbf import

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic771726-338-1.aspx

    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

    August 17, 2009 at 8:04 am

    #1040195

  • RE: dbf import

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic771726-338-1.aspx

    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

    August 17, 2009 at 8:03 am

    #1040194

  • RE: Cannot attach database that was bieng restored

    Get out your database backup and restore it. You do have a backup, don't you?

    If a database is detached while in the restoring state (not possible on SQL 2008), it...

    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

    August 17, 2009 at 8:03 am

    #1040193

  • RE: Ok, its their first day on the job.

    Silverfox (8/17/2009)

    Sorry to be the exception to the rule 😛

    I have no SQL Books and being freelance, I wouldnt last 5 minutes, If I turned up a a client site...

    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

    August 17, 2009 at 7:59 am

    #1040190

  • RE: SQL SERVER SP2

    Why SP2? Why not SP3?

    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

    August 17, 2009 at 7:52 am

    #1040184

  • RE: Twenty tips to write a good stored procedure

    Paul White (8/16/2009)

    The behaviour of the second statement rather depends on the setting of ANSI_NULLS.

    Considering I never switch it off, anything I post about nulls can be assumed Ansi_nulls...

    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

    August 17, 2009 at 7:42 am

    #1040178

  • RE: SQL Joins

    ta.bu.shi.da.yu (8/16/2009)

    You can't do an outer join from the where clause...

    You can't in a DB with compatibility set 90 or higher (ie SQL 2005 or 2008). It was possible 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

    August 17, 2009 at 7:40 am

    #1040174

  • RE: inside sql server 2005 books, are there 2008 versions of any of these?

    The series kinda got split in 2008. Haven't seen an equivalent to the 4th book, but if you want internals, you want this one.

    http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243/ref=sr_1_1?ie=UTF8&s=books&qid=1250454285&sr=8-1

    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

    August 16, 2009 at 2:25 pm

    #1039979

  • RE: Twenty tips to write a good stored procedure

    I need to correct myself here. Surprised no one picked up on this....

    GilaMonster (8/10/2009)

    Also, try to avoid IN. While checking the existence of some values, then use EXISTS instead 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

    August 16, 2009 at 12:32 pm

    #1039975

  • RE: Checkpoint Duration

    Sarab (8/16/2009)

    Ok, so if i want to commit all the changes at a rapid speed i can request a checkpoint with a small duration & SQL will put 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

    August 16, 2009 at 10:56 am

    #1039969

  • RE: Files and File Groups

    Steve Jones - Editor (8/16/2009)

    There are a few issues with snapshots.

    they don't stay up to date. They are a point in time. To update it, you need to either drop...

    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

    August 16, 2009 at 9:48 am

    #1039962

  • RE: Please point me in the right direction

    Congratulations. 😉

    This is either a wonderful opportunity or pending disaster, which it will be is up to you.

    Here are a few resources to start with.

    http://www.sqlskills.com/BLOGS/PAUL/post/Becoming-an-involuntary-DBA-youre-not-alone.aspx

    http://www.sqlskills.com/BLOGS/PAUL/post/RunAs-Radio-interview-on-being-an-involuntary-DBA.aspx

    http://www.sqlskills.com/BLOGS/PAUL/post/TechNet-Magazine-Effective-Database-Maintenance-article-and-August-SQL-QA-column.aspx

    Some things that you need 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

    August 16, 2009 at 8:48 am

    #1039959

  • RE: Files and File Groups

    ps (8/16/2009)

    In mirroring, you cannot access the mirror database at all unless failover happens.

    You can, providing it's Enterprise edition. Create a database snapshot on the mirror (has to be synchronised)....

    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

    August 16, 2009 at 8:42 am

    #1039956

  • RE: Checkpoint Duration

    There's no default duration or setting that affects a checkpoint's duration. You can change the recovery interval, which affects how often the checkpoint runs, nothing else.

    How long a checkpoint takes...

    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

    August 16, 2009 at 8:39 am

    #1039955

  • RE: Total Multiple Rows for a Unique Item

    Excellent. 🙂

    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

    August 16, 2009 at 8:33 am

    #1039954

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