Forum Replies Created

Viewing 15 posts - 27,841 through 27,855 (of 49,552 total)

  • RE: Filegroup backup

    How is your database structured? How many filegroups? What filegroup is that 5MB table in? What else is in that filegroup?

    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 11, 2011 at 3:14 am

    #1285581

  • RE: Can I restore part of the database to a mapped drive due to disk space issue ?

    No. SQL has a number of requirements for drives for data files, the network protocol doesn't meet them.

    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 10, 2011 at 2:57 pm

    #1285492

  • RE: Index Works Fine For Set Of Data - Doesn't Work For other Set of Data?

    sqldba_icon (2/10/2011)

    Gail thanks for reply. I apologize for asking this question, but is there a way i can just email you the details just because it has some confidential data...

    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 10, 2011 at 10:55 am

    #1285347

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/10/2011)

    EDIT: It's official! Gail is a geek like the rest of us. And I don't mean techno-geek. @=)

    Err, there was some doubt about 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

    February 10, 2011 at 10:16 am

    #1285322

  • RE: Are the posted questions getting worse?

    Wow, that was fun. Stressful as hell (couldn't get the conference call to work initially), but great fun.

    Going to be on a high for a few hours at least. Should...

    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 10, 2011 at 10:14 am

    #1285319

  • RE: Inactive database user?

    Charlie.anna (2/10/2011)

    Its just a requirement, i hope by doing this i will not break any law :unsure:

    I'm asking because there are very few good reasons to do this and if...

    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 10, 2011 at 7:11 am

    #1285156

  • RE: “SELECT 1? rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”.

    deepak.a (2/10/2011)

    Thanks for reply,if we use columns or * will it make any performance difference? and also

    Like ex : if exists(Select 1 ... ) or if exists(select Top 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

    February 10, 2011 at 6:58 am

    #1285148

  • RE: How to improve performance of a dumb query?

    Can you post the entire execution plan as a .sqlplan file please? http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 10, 2011 at 6:01 am

    #1285110

  • RE: Inactive database user?

    Charlie.anna (2/10/2011)

    I want to automatically logout the inactive users from sql server 2005/2008 after certain time limit(ie. after 5minute).

    Why?

    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 10, 2011 at 5:58 am

    #1285108

  • RE: No Lock

    carlo 47463 (2/10/2011)

    T

    Then surely there is no chance of dirty data,phantom rows etc? The 2 applications do not select based on the same AppKey and there will also only 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

    February 10, 2011 at 5:50 am

    #1285104

  • RE: No Lock

    crazy4sql (2/10/2011)

    no, I will not suggest for nolock.

    It will affect your performance very badly and you will see lot of blocking and deadlock as well.

    How will nolock (which results...

    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 10, 2011 at 5:46 am

    #1285101

  • RE: “SELECT 1? rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”.

    No difference. No matter what you use, it's removed early in the parsing stage. I use SELECT 1 to make it extremely clear that the exists is not returning any...

    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 10, 2011 at 5:45 am

    #1285100

  • RE: Retrieving column and table names used in a stored procedure

    Just note that sysobject and syscomments are deprecated, should not be used in new development and will be removed from a future version of the product. Replacements are sys.comments 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

    February 10, 2011 at 5:27 am

    #1285094

  • RE: Index Works Fine For Set Of Data - Doesn't Work For other Set of Data?

    Post the table definition, index definition, query and execution plan (both seek and scan).

    There is a recompile hint, but please don't start using hints unless you know what's causing 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

    February 10, 2011 at 1:25 am

    #1284989

  • RE: Database suspect mode

    Fix whatever is still wrong with E drive then restore your last good 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

    February 9, 2011 at 1:35 pm

    #1284807

Viewing 15 posts - 27,841 through 27,855 (of 49,552 total)