Forum Replies Created

Viewing 15 posts - 29,881 through 29,895 (of 49,552 total)

  • RE: Non-unique index vs. wider unique index including PK

    No, because SQL will always add the clustering key as an invisible key column to a nonclustered index that's not declared unique. You're just doing explicitly what SQL would do...

    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

    October 18, 2010 at 5:46 am

    #1238339

  • RE: Dropping Clustered Index

    It may take a while, especially if there are nonclustered indexes.

    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

    October 18, 2010 at 4:21 am

    #1238294

  • RE: SQL Server Background Processes

    Have you tried google?

    I'd also suggest that you buy a copy of SQL 2008 Internals as there should be a fair bit in 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

    October 18, 2010 at 4:04 am

    #1238286

  • RE: table's log

    Tables don't have individual logs.

    Are you looking for DDL changes or data changes?

    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

    October 18, 2010 at 2:41 am

    #1238266

  • RE: Log Shipping & Full Backups

    ovonelmonk (10/18/2010)

    I would like to know about the backup procedure. That is, now my only backup is on the secondary server(Log Shipping). My question is..

    1) If I take Weekly Full,...

    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

    October 18, 2010 at 2:40 am

    #1238265

  • RE: Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)

    Recommendations:

    1) Change the data type back to datetime. You're asking for a world of hurt with it a varchar. Validations, date manipulation, etc.

    2) Look up CONVERT in SQL Books Online....

    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

    October 17, 2010 at 11:31 pm

    #1238235

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/17/2010)

    WayneS (10/14/2010)

    "Don't try this at home... we're professionals!"

    Heh... I have the perfect SQL subject for that... Quirky Update. 😀

    Or what I actually labelled as 'Don't try this 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

    October 17, 2010 at 11:09 pm

    #1238232

  • RE: Check DB Error

    Please run the following, post the full and complete output.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    If that's the only error you have, check this out:

    http://sqlinthewild.co.za/index.php/2009/08/26/corruption-in-sysdependencies/

    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

    October 17, 2010 at 11:08 pm

    #1238230

  • RE: UDF Vs Subquery performance

    Test both and see which performs better?

    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

    October 17, 2010 at 11:08 pm

    #1238229

  • RE: How to get 2 or more PK ID From the previous table insertion to the other table insertion in which it is a FK

    Look up the OUTPUT clause in SQL's Books Online

    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

    October 17, 2010 at 11:07 pm

    #1238228

  • RE: Are the posted questions getting worse?

    Tom.Thomson (10/17/2010)

    What's the betting he calls you all sorts of names

    Yes

    and says the idea of having a stored procedure is an unwanted overhead?

    Don't think so. More likely, I think,...

    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

    October 17, 2010 at 3:30 pm

    #1238160

  • RE: Commit open transaction.

    Tom.Thomson (10/17/2010)

    (with some risk that the situation will deteriorate further, so that the transaction can't be rolled back or committed because there isn't space to log that action) or roll...

    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

    October 17, 2010 at 10:54 am

    #1238129

  • RE: Commit open transaction.

    beejug1983 (10/17/2010)

    First : - The query that is being run by user will be stopped or what ?

    No, but if your tran log runs out of space no...

    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

    October 17, 2010 at 10:52 am

    #1238128

  • RE: Commit open transaction.

    You can't commit it from a different connection. Either find where it's coming from and tell the user to commit, or kill it and SQL will roll back all changes...

    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

    October 17, 2010 at 8:04 am

    #1238110

  • RE: Are the posted questions getting worse?

    If I wasn't ignoring him/her, I'd suggest they do some reading on SQL Injection. The odd casts to int will ensure that there's nothing odd in the month or year,...

    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

    October 17, 2010 at 5:00 am

    #1238099

Viewing 15 posts - 29,881 through 29,895 (of 49,552 total)