Forum Replies Created

Viewing 15 posts - 14,791 through 14,805 (of 39,970 total)

  • RE: compression ratio of litespeed

    This lists the default level as 1, out of 11 possible levels. 0 is no compression, which is the same as a native backup.

    https://support.quest.com/search/SolutionDetail.aspx?id=SOL14764

    If you are looking for a percentage...

  • RE: How to control the checkpoint?

    I don't think this is a wide problem, and I have rarely seen anyone complaining about the checkpoint process.

    If you run SP_who, is it there you see the checkpoint process...

  • RE: The HR Sorecard

    jcrawf02 (12/14/2011)


    I think the point that needs to be made here, regardless of viewpoint, is that you shouldn't care whether it's termed revenue or overhead. If you're helping the company,...

  • RE: BuiltInAdmin Login Issue

    You are doing things backwards. Don't manage the admins this way.

    If you don't need or want BuiltIn\Administrators as admins, then remove that group from the logins. However, before you do...

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/13/2011)


    About due for a Pantsectomy :-D:-D:-D:-D

    40F in Denver, no need for pants today.:-P

  • RE: dynamic email report

    Hardly, too many articles to keep track of. :w00t:

    That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't want to give you another...

  • RE: Denali needs Windows 6.0 minimum

    I would not expect that the client tools work on XP, but I'll try to test.

  • RE: VB script to delete old backups is NOT working in SQL Server 2008 R2

    Verify the path, if it's not working, include some MSGBOX lines in there, and see what values are being sent for the files and folders. It's basic debugging here for...

  • RE: REFRESH PRODUCTION DB to DEVELOPMESQNT

    I assume you are backing up your production database, correct? Just copy the latest full backup to the development server.

    If you are replacing the databases on the Dev server with...

  • RE: Problem securing a view

    database permissions do not cross database boundaries by default. You can enable this, but be aware of the security implications.

  • RE: DATA FILES -AUTOGROWTH

    The filegroups matter. If you have other files in the filegroups that contain the full files, then the other files will be receive data. SQL Server sends data to filegroups....

  • RE: Developer tools

    There is a free SQL Search tool from Red Gate that will integrate into SSMS and let you quickly search for objects.

    Disclosure: I work for Red Gate

  • RE: Developer tools

    Red Gate has the dependency tool that will allow you to find out what is linked to what.

    However if you are expecting to right click on an piece of code...

  • RE: Affinity mask VS Resource Governor

    I don't know a lot of people using Resource Governor, but they have been successful. It is a little more complicated to setup and understand, but it does do a...

  • RE: dynamic email report

    Run the query for the top 20 and then loop through it, running additional queries.

    In T-SQL, I'm not sure how easy this is. In SSIS, you can create a new...

Viewing 15 posts - 14,791 through 14,805 (of 39,970 total)