Forum Replies Created

Viewing 15 posts - 3,376 through 3,390 (of 5,841 total)

  • RE: Table partition

    azhar.iqbal499 (5/17/2011)

    Thanks for proper Explanation.

    Pl Tell me, Whether table partition improve select query performance or not?

    Thanks

    Partitioning is a VERY complex scenario with MANY ways you can screw it up. ...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 19, 2011 at 6:23 am

    #1326989

  • RE: Looking for a data compare/copy product

    Robert Pepin (5/18/2011)

    We have been working with the Red Gate Data compare product for several weeks now and is the product that we are having issues with. We are...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 19, 2011 at 6:17 am

    #1326985

  • RE: How to release space used by a table?

    sqlapprentice (5/18/2011)

    TheSQLGuru (5/18/2011)

    Extra space is also required for the intermediate sorting during index build unless you specify the SORT_IN_TEMPDB option. IIRC rebuiding an index requires something like 1.3X size...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 18, 2011 at 4:29 pm

    #1326827

  • RE: How to release space used by a table?

    Extra space is also required for the intermediate sorting during index build unless you specify the SORT_IN_TEMPDB option. IIRC rebuiding an index requires something like 1.3X size for the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 18, 2011 at 1:48 pm

    #1326762

  • RE: How to release space used by a table?

    Hope you are aware that when you defrag your indexes the size of your database will expand back out some.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 18, 2011 at 11:26 am

    #1326679

  • RE: SQL mirroring poor performance.

    Robert Davis (5/18/2011)

    Was that a typo? Does your server really have only 4 GB of RAM? Do you have the 3 GB parameter set or using AWE?

    My minimum reccommendation for...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 18, 2011 at 11:09 am

    #1326662

  • RE: How to release space used by a table?

    sqlapprentice (5/17/2011)

    Steve Jones - SSC Editor (5/16/2011)

    This (http://www.sqlservercentral.com/Forums/Topic993883-146-6.aspx#bm1008735) seems to indicate this is by design. I would shrink the file, looking to deallocate the LOB extents.

    I finally solved this issue...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 18, 2011 at 11:04 am

    #1326657

  • RE: Differences between sql server 2008 and 2008 R2

    SQL 2008 R2 release was almost all about either extreme scale stuff or BI stuff. Not much at all for us relational engine types. 🙁

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 17, 2011 at 11:50 am

    #1326020

  • RE: Archive older data

    1) Federated databases, where you have data spread across different physical servers, was NEVER a fully functional and useful thing in SQL Server. If you need to be able...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 17, 2011 at 11:49 am

    #1326018

  • RE: Need right direction to load monthly data

    LutzM (5/15/2011)

    Like I said before: I recommend to get a consultant in for a day or two. It'll be much more efficient than using a forum. Based on the information...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 17, 2011 at 11:45 am

    #1326015

  • RE: Seeing logshipping degradation - any idea why?

    There are a number of causes for what you are seeing. If you need to QUICKLY get this resolved, find a good performance tuning consultant and get them on...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 17, 2011 at 11:20 am

    #1325988

  • RE: Is NTILE OVER (PARTITION BY .. running total..) possible?

    Jeff Moden (5/15/2011)

    TheSQLGuru (5/3/2011)

    That is by far the biggest shortcoming SQL Server has IMNSHO.

    Unless you count the fact that there is no split function, no function to generate sequential numbers...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 16, 2011 at 7:33 am

    #1325032

  • RE: After Update Trigger Only Fired for the first record in the IN close

    That is the third time in a week I have seen this CRITICAL flaw in trigger code. Scary how common this is...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 16, 2011 at 7:18 am

    #1325017

  • RE: Problem please help me ?

    bijarcity (5/15/2011)

    Hello

    Thanks for your website.

    I have a question about distributed system.

    we have a project about distributed systems but the problems that we have is about how we can design this...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 16, 2011 at 7:17 am

    #1325014

  • RE: sql server is not using more than 3gb causing performace issues.

    We have covered the simple things that can be covered on a forum thread. I recommend you get a professional tuner to remote into your system and do a...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    May 16, 2011 at 7:09 am

    #1325008

Viewing 15 posts - 3,376 through 3,390 (of 5,841 total)