Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 5,843 total)

  • RE: The Dynamic Tally or Numbers Table

    Is there a way on this forum to increase the number of posts shown per page?

  • RE: Stored Procedure SQL 2000 to SQL 2005

    Jeff Moden (10/1/2009)


    Kevin,

    I'll admit to being a bit lazy here... do you have a link about that change? Thanks.

    No I do not - I just assumed there was a...

  • RE: Stored Procedure SQL 2000 to SQL 2005

    You relied on using a feature that you are not supposed to use. RETURN is not for output parameters or values, which is what you used it for. ...

  • RE: Merge replication without network

    Actually read my post carefully - it is ApexSQL DataDiff, a data comparison and synchronization application from ApexSQL. As Steve pointed out RedGate makes a competing product, and there...

  • RE: Load balancing

    bmw110001 (9/29/2009)


    it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea

    I restate my first idea:

    1) Hire a...

  • RE: Running out of space on E drive

    Silverfox (9/29/2009)


    TheSQLGuru (9/29/2009)


    Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because developers...

  • RE: Running out of space on E drive

    Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because developers would make...

  • RE: Hacked - what's the best way to restore?

    You need to put a filter in place IMMEDIATELY to reject any query that has the following in it. Note this is NOT a bullet-proof mechanism or list, but...

  • RE: VERY POOR PERFORMANCE AFTER RUNNING SP_UPDATESTATS & URGENTLY NEED HELP

    do NOT simply implement what DTA might advise. It has SIGNIFICANT limitations and will create MANY indexes with large percentages of the columns in a table INCLUDED just to...

  • RE: Indexes and execution plan

    >> but wish to know how this may affect my system

    Then you should run a production workload against your production-mirrored test environment. You DO have one of those,...

  • RE: view performance deteriorated significantly

    Unfortunately the true solution here maybe be to simply 'tune' the view(s), which given their complexity could take many days or even weeks of effort and carry significant risk of...

  • RE: Load balancing

    I can think of 3 solutions:

    1) Hire a professional to help you tune the poorly performing database. It seems that you are not a SQL Server guru so I...

  • RE: Merge replication without network

    Here's a possible solution. Make a complete backup of the remote database and store that on USB key. Restore that to the main server when the guy gets...

  • RE: Running out of space on E drive

    Buy FolderInfo and use it to quickly spot space consumers on the drive of concern. Very useful utility I have been using for a LONG time.

    Also, instead of going...

  • RE: Disk, Raid Groups, File Group & Cluster config

    My reply is that you should hire an expert to assist you with this matter. There are MANY things you need to do right to get optimal and reliable...

Viewing 15 posts - 4,516 through 4,530 (of 5,843 total)