Forum Replies Created

Viewing 15 posts - 43,231 through 43,245 (of 49,571 total)

  • RE: Database Shrink

    A shrink will never lose data. Why do you want to shrink your database?

    November 11, 2008 at 9:45 am

    #897029

  • RE: Stored Procedure speed versus Select Statement

    Sue (11/11/2008)

    thanks for your hint, Jeff.

    but isn't this better than to give users permissions on tables and generate the whole select statement dynamically as mentioned before?

    But that's pretty much...

    November 11, 2008 at 9:39 am

    #897027

  • RE: execution plan not using correct index

    tvantonder (11/11/2008)

    So I now came to the conclusion that the SQL engin is not that smart and will not create the best execution plan.

    The optimiser is quite smart...

    November 11, 2008 at 9:33 am

    #897020

  • RE: Stored Procedure speed versus Select Statement

    Patrick Russell (11/11/2008)

    It seems that the dynamicSQL is the way to go, the question is how little. What would be the best way to validate the incoming values to make...

    November 11, 2008 at 9:21 am

    #897012

  • 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...

    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...

    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....

    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...

    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...

    November 11, 2008 at 1:25 am

    #896777

  • RE: log file size is increasing

    Please explain your problem in detail.

    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.... ...

    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...

    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 %...

    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...

    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...

    November 10, 2008 at 12:08 pm

    #896485

Viewing 15 posts - 43,231 through 43,245 (of 49,571 total)