Forum Replies Created

Viewing 15 posts - 30,991 through 31,005 (of 49,552 total)

  • RE: Affects of several VarChar fields in a table

    paul.knibbs (8/31/2010)

    One problem you might have is that the total possible row length you've got there is well in excess of 32k--way higher than the little-bit-less-than-8k SQL server provides! 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

    August 31, 2010 at 5:12 am

    #1214153

  • RE: How to track the user,hostname to get the info about who has truncated the table

    If the hostname is not in the log, the 3rd party tools won't be able to extract it. Remember the log is not an audit trail, it's for database consistency...

    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 31, 2010 at 5:09 am

    #1214151

  • RE: How to get datafiles back in sql server 2005

    Restore from backup. That's pretty much the only real option you have.

    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 31, 2010 at 4:54 am

    #1214140

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/31/2010)

    GilaMonster (8/31/2010)

    Not a DBA, never been a DBA. Should I leave now?

    ACK! No! I can't live without my GilaMonster!

    All these people whose advice has saved my neck aren't...

    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 31, 2010 at 4:47 am

    #1214138

  • RE: I Love the SQL Community

    Alvin Ramard (8/30/2010)

    Also consider starting a user group in the area. Starting a user group is not that hard. Keeping it going is not that hard either, 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

    August 31, 2010 at 2:55 am

    #1214101

  • RE: I Love the SQL Community

    Manie Verster (8/30/2010)

    I have been looking out for SQL events in South Africa but have not seen any. Gail had arranged something a while back and I don't know what...

    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 31, 2010 at 2:52 am

    #1214100

  • RE: Trigger to a View

    That trigger will only fire when a row is inserted into the view in SQL. A SQL trigger cannot be fired by a change in Oracle. To catch changes made...

    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 31, 2010 at 2:44 am

    #1214097

  • RE: DMV's

    Depends on the DMV. Different ones have different rules. Check the entries for the DMVs in Books Online for details.

    Some hold limited data, some don't. Some reflect only current 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

    August 31, 2010 at 2:09 am

    #1214084

  • RE: Topics for masters thesis/dissertation

    I'd suggest that you first speak with the lecturers and/or your thesis advisor. They'll likely have their own ideas and requirements. The thesis will likely need to be original research...

    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 31, 2010 at 2:06 am

    #1214083

  • RE: DMV's

    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/Topic977164-391-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 31, 2010 at 2:01 am

    #1214082

  • RE: Clustered index degrades the performance

    onurcivi (8/30/2010)

    In the first query, the optimizer didn't use the clustered index, instead it used an index that was created on two integer columns (ItemCount and ItemReceivedCount). I don't understand...

    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 31, 2010 at 1:58 am

    #1214080

  • RE: Error for shrinking database

    Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in 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 31, 2010 at 1:55 am

    #1214078

  • RE: Clustered index degrades the performance

    Leo.Miller (8/30/2010)

    Three issues:

    1) Never use SELECT COUNT(*)...

    Besides being lazy coding, SQL assumes you actually want to count all the columns. Since you only actually need DepositEntryId rather use SELECT...

    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 31, 2010 at 1:53 am

    #1214077

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/27/2010)

    Alvin Ramard (8/27/2010)

    Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀

    ACK! We've been invaded! There's one of those non-DBA...

    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 31, 2010 at 1:39 am

    #1214073

  • RE: sp_who2 results show one spid 24 times

    Please note, original thread is a year old.

    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 31, 2010 at 1:33 am

    #1214070

Viewing 15 posts - 30,991 through 31,005 (of 49,552 total)