Forum Replies Created

Viewing 15 posts - 42,136 through 42,150 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Michael Earl (12/24/2008)

    "Padded" resumes really get me. I interviewed more than 30 candidates for a position at my last company. It was amazing how many people would put...

    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

    December 24, 2008 at 5:46 am

    #917326

  • RE: how to check bit field value?

    Where CancelFlag = 0

    A bit holds values of 1 or 0. By convention, 0 is false and 1 is true, though there's nothing in SQL that enforces that.

    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

    December 24, 2008 at 3:04 am

    #917284

  • RE: SQL 2005 write performance

    Doesn't look like memory bottleneck either.

    If the app's inserting a lot of new data, then the PLE will be low because new data's constantly coming in.

    Do you have SQL profiler...

    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

    December 24, 2008 at 1:44 am

    #917265

  • RE: view with constantly update base tables

    jasmineywchen (12/23/2008)

    My questions and concerns are:

    1. When the base tables are being written, is it going to lock the tables causing the view to timeout??

    Probably not the entire 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

    December 24, 2008 at 1:25 am

    #917262

  • RE: Are the posted questions getting worse?

    SQLBill (12/23/2008)

    I think in the economy some people are getting into jobs that are 'over their heads'. I remember seeing on one of my tech sites a person posted...

    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

    December 24, 2008 at 1:14 am

    #917260

  • RE: DB Currupted

    Lee From Bangalore (12/23/2008)

    While taking the backup if the database is currupted what will we do?

    Depending on the severity, fix the corruption, or restore a clean backup.

    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

    December 24, 2008 at 1:11 am

    #917257

  • RE: query timeout

    Save as a .sqlplan file, zip and attach to the post.

    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

    December 23, 2008 at 11:43 pm

    #917240

  • RE: Alertnatives to DBCC INPUTBUFFER(@@spid)

    Check in Books Online, under sys,dm_exec_sql_text. There are examples there.

    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

    December 23, 2008 at 11:41 pm

    #917238

  • RE: Multi-column primary keys

    Grant Fritchey (12/22/2008)

    Gail Shaw had some interesting sample code around COUNT methods in her SQL Pass Presentation. It might be on her blog.

    Or it might not. At least right at...

    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

    December 23, 2008 at 10:57 am

    #916926

  • RE: Trying to speed up a loop; there's just too much data?

    What is this supposed to do?

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    December 23, 2008 at 10:35 am

    #916912

  • RE: Prerequisites for 2k5

    None. The TS exam is a prerequisite for the two ITPs, but that's it.

    This site should answer all of your certification questions - http://www.microsoft.com/learning/mcp/certifications.mspx

    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

    December 23, 2008 at 10:30 am

    #916906

  • RE: Latest SQL Server vunerability sp_replwritetovarbin

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic624663-359-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

    December 23, 2008 at 10:30 am

    #916904

  • RE: Figured a few DBA' & Developers would get a laugh

    Just a heads-up. This is a copy of Tony's editorial for this week from Simple Talk - http://www.simple-talk.com/community/blogs/tony_davis/archive/2008/12/19/70941.aspx

    Scott, is this reposted with permission?

    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

    December 23, 2008 at 10:23 am

    #916901

  • RE: COPY_ONLY(BACK UP & RESOTRE)

    beerampradeep (12/23/2008)

    Msg 3102, Level 16, State 1, Line 1

    RESTORE cannot process database 'DATA_SAMPLE' because it is in use by this session. It is recommended that the master database be 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

    December 23, 2008 at 10:18 am

    #916896

  • RE: copy a database from one server to another server

    From management studio, object explorer. Right click on the database, select Tasks, then Generate Scripts.

    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

    December 23, 2008 at 10:16 am

    #916895

Viewing 15 posts - 42,136 through 42,150 (of 49,552 total)