Post reply

Keeping huge free spaces in data file can make query slower?

  • November 1, 2018 at 4:26 am

    #367619

    Dear All,

    I need some info for the following 2 questions. Any idea please?
    1. Keeping huge free spaces in the data file can make my query performance slower?
    2. If I stop DB shrink function, how to de-allocate the allocated spaces which is occurred after delete/truncate functions? SQL server DB can remove itself?

    Currently we are planning to add more spaces to our DB data files. According to all the suggestions from SQL server DB experts, I decided to increase my DB file size manually instead of auto growth every time. Now I become confusing with the above 2 questions. Any idea or suggestions please? I couldn't find those 2 answer in any where. My DB is used for OLAP. So query performance is crucial for us.

    Thanks in advance,
    Cool

  • November 1, 2018 at 5:21 am

    #2012017

    Please don't cross post questions. It makes the conversation difficult to keep track of.

    I posted one answer over here. Please, anyone else, continue the conversation there.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • November 1, 2018 at 9:20 am

    #2012062

    Grant Fritchey - Thursday, November 1, 2018 5:21 AM

    Please don't cross post questions. It makes the conversation difficult to keep track of.

    I posted one answer over here. Please, anyone else, continue the conversation there.

    Dear Grant,

    Noted with thanks. I replied to the other group.

    Thank you & Best Regards,
    Cool

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply