Forum Replies Created

Viewing 15 posts - 43,216 through 43,230 (of 49,552 total)

  • RE: ORDER BY in INSERT INTO, how is it done?

    The order by should guarantee the order of the identity values, not the physical insert order. I don't have a ref for that right now, just a comment by one...

    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

    November 11, 2008 at 2:55 am

    #896823

  • RE: log file size is increasing

    sramesh02 (11/11/2008)

    Our Sql Server database log file size increasing huge and also not able to shirink database.

    What recovery model is the DB in? How often are you doing log...

    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

    November 11, 2008 at 1:55 am

    #896793

  • RE: log file size is increasing

    Kishore.P (11/11/2008)

    run the following DBCC commands:

    DBCC DBREINDEX

    Only if you have several hours of downtime

    DBCC DROPCLEANBUFFERS

    DBCC FREEPROCCACHE

    Not on a production server unless you want IO and CPU load to sharply increase....

    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

    November 11, 2008 at 1:48 am

    #896790

  • RE: ORDER BY in INSERT INTO, how is it done?

    Order by is ignored in an insert, except for it's effect on the identity columns. Order of data in a table is a meaningless concept. Tables are unordered sets. 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

    November 11, 2008 at 1:33 am

    #896784

  • RE: Nested Transactions - Best Practice

    Adam Hardy (11/10/2008)

    Thanks for the input, but I think you may have miss-read my post, I said I was utilising triggers for data integrity tasks, not business rules.

    Same (even...

    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

    November 11, 2008 at 1:25 am

    #896777

  • RE: log file size is increasing

    Please explain your problem in detail.

    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

    November 11, 2008 at 1:22 am

    #896776

  • RE: Creative SPAM

    BN Phillips (11/10/2008)

    I recently visited South Africa. In the wonderful country I did a tour of the SA Brewery in Joburg. I am not destined for heaven.... ...

    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

    November 11, 2008 at 12:34 am

    #896763

  • RE: Re: Interpreting results for SET STATISTICS IO

    jlp3630 (11/10/2008)

    Given 2 semantically equivalent queries, I'm trying to determine which one is better or worst in terms of performance. The reports relying on these queries take a couple days...

    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

    November 11, 2008 at 12:33 am

    #896762

  • RE: Help controlling transaction log growth needed

    Marker (11/10/2008)

    I ran a dbcc sqlperf(LogSpace) on my database and found that the Log Size is currently 30GB. The Log Space Used is only 13%.

    What's 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

    November 11, 2008 at 12:31 am

    #896759

  • RE: execution plan not using correct index

    tvantonder (11/10/2008)

    I can not add this. It takes 3 hours and we are a 24hour company.

    Why not? If you're using enterprise edition, you should be able to build the index...

    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

    November 11, 2008 at 12:29 am

    #896758

  • RE: Help controlling transaction log growth needed

    If the difference between the start time and the current time is small, then no. If it's several hours then you need to worry.

    First thing, change the log backup frequency...

    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

    November 10, 2008 at 12:08 pm

    #896485

  • RE: Tempdb is full due to crappy procedure!!!

    80 MB is not large for TempDB. From the space used, it looks like it's only half used, which is fine. How big can it get?

    If TempDB is sized properly...

    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

    November 10, 2008 at 12:02 pm

    #896472

  • RE: Unable to recover the data to the point in time??

    rsmaloo (11/10/2008)

    I agree with the point.

    And can send me the last script u used to restore.

    with stop at time...

    Lookup Restore Database in Books Online. It will give you all 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

    November 10, 2008 at 11:27 am

    #896454

  • RE: Performance Alert passing values to stored proc?

    I would strongly suggest that you schedule the log backups to run at a regular interval (hourly is good) rather than basing it on the log's file size. The point...

    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

    November 10, 2008 at 11:25 am

    #896453

  • RE: Unable to recover the data to the point in time??

    Karl Klingler (11/7/2008)

    Hi,

    let's say you

    rename the old log file,

    then restore the db, diff and log backups

    stop sql server

    rename the new log file

    rename the old log file to its...

    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

    November 10, 2008 at 11:22 am

    #896451

Viewing 15 posts - 43,216 through 43,230 (of 49,552 total)