Forum Replies Created

Viewing 15 posts - 39,586 through 39,600 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Are you paying or is your company paying?

    All the conference hotels are within walking distance of the conference centre. The closest is right across the road and the furthest 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

    April 21, 2009 at 2:01 pm

    #981767

  • RE: Best way to set 'READ UNCOMMITTED'

    krypto69 (4/21/2009)

    If I put it at the top of statement, it says 'completed' but when I go back in and look at the proc, the isolation level part I just...

    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

    April 21, 2009 at 1:57 pm

    #981764

  • RE: Newbie question for small query

    Please post table definitions, your test 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

    April 21, 2009 at 1:49 pm

    #981757

  • RE: MCTS pre-req removed for 2008?

    airparkroad (4/21/2009)

    I'm preparing for the 70-433 SQL SERVER 2008 Database Development.

    I was digging through some of the 2005 material and went across this information.

    http://www.microsoft.com/learning/mcp/mcitp/dbdev/default.mspx

    The above site states that in order...

    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

    April 21, 2009 at 1:45 pm

    #981756

  • RE: CLR and multi-threading

    Cowboy DBA (4/21/2009)

    They monitor performance so I need to get an at-the-time snapshot. I already use UNSAFE as they grab perfmon stats so I definitely take your point r. over...

    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

    April 21, 2009 at 1:34 pm

    #981746

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/21/2009)

    You will receive notification. I'm not sure if you can see that it was accepted on your profile or not. If I remember correctly from last year (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

    April 21, 2009 at 1:33 pm

    #981744

  • RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    sharanurampur (4/21/2009)

    when I checked into the log files i got some message like..

    No errors there. Are there any messages in the log that relate to the database Common?

    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

    April 21, 2009 at 1:31 pm

    #981742

  • RE: CLR and multi-threading

    Do not play with threading in CLR. I believe it requires UNSAFE and, if you're not careful you could crash the entire SQL instance. If you play with threads 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

    April 21, 2009 at 7:34 am

    #981419

  • RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    sharanurampur (4/21/2009)

    please give me the solution so that my application works properly.

    Have a look through the SQL error log. There will be more details there regarding the cause 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

    April 21, 2009 at 7:31 am

    #981414

  • RE: Include a column to a existing Non Cluster Index...

    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/Topic701350-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

    April 21, 2009 at 6:50 am

    #981374

  • RE: Include a column to a already existing Non Cluster Index...

    Indexes created by constraints (like primary key) do not allow include columns.

    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

    April 21, 2009 at 6:50 am

    #981373

  • RE: Regarding Query Optimisation

    mithun.gite (4/21/2009)

    GilaMonster (4/21/2009)

    mithun.gite (4/21/2009)

    Can any one give me a link for Query Optimization, using that i can start optimizing my queries?

    I can suggest some books.

    Inside SQL Server 2005: Query Tuning...

    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

    April 21, 2009 at 6:44 am

    #981369

  • RE: want to know unstricted database of sql server

    DKG (4/21/2009)

    Gail , MANU this scirpt doesn't work for sql 2000

    No, it won't. The question's in the 2005 forums, hence the query posted uses 2005 features.

    If this is for SQL...

    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

    April 21, 2009 at 6:35 am

    #981359

  • RE: Missing data restore

    David O'Reilly (4/21/2009)

    how does SQL know when to create these backups?

    SQL doesn't take automatic backups. A database is backed up when a BACKUP DATABASE statement is run, either manually or...

    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

    April 21, 2009 at 6:31 am

    #981358

  • RE: Regarding Query Optimisation

    r.hensbergen (4/21/2009)

    Avoid using (NOT) IN (SELECT...), use joins or EXISTS instead.

    Not necessarily. As with many things, the best advice here is test and see which, if either, is faster.

    Avoid...

    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

    April 21, 2009 at 5:50 am

    #981339

Viewing 15 posts - 39,586 through 39,600 (of 49,552 total)