Forum Replies Created

Viewing 15 posts - 4,816 through 4,830 (of 7,164 total)

  • RE: Memory - Total/Target always using same value?

    For the server now using "AWE on, 3GB on" I never tested "AWE on, 3GB off" but I just found a good dev-server that is a candidate for this treatment....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 3:15 pm

    #1463827

  • RE: Memory - Total/Target always using same value?

    george sibbald (3/23/2012)

    sorry opc.three I am still not convinced on this use of AWE with 4Gb or less of physical memory and 32 bit, I have not seen any evidence...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 2:30 pm

    #1463799

  • RE: 2008 R2 32 bit upgrade to 64 bit - could it be that easy?

    Mhlewis (3/23/2012)

    I was told by our sysadmin that 32 bit SQL on 64 bit OS was not an option, also the small amount of research I did on that indicated...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 2:22 pm

    #1463786

  • RE: Lightspeed - Automating Restore with Dynamic Filname

    Jeffrey Williams 3188 (3/23/2012)

    You can get this information from the backupset and backupmediafamily tables in msdb. You will also need to rename the files using WITH MOVE if you...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 1:12 pm

    #1463726

  • RE: Memory - Total/Target always using same value?

    Jeffrey Williams 3188 (3/23/2012)

    opc.three (3/23/2012)

    Your readings are completely normal. SQL Server will claim as much memory as you allow it provided it thinks its needs it to efficiently serve data...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 1:07 pm

    #1463717

  • RE: 2008 R2 32 bit upgrade to 64 bit - could it be that easy?

    Mhlewis (3/23/2012)

    I am being required to upgrade one of our installations of 32 bit SQL Server 2008 R2 to 64 bit as the server that the instance resides on is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 12:50 pm

    #1463697

  • RE: Memory - Total/Target always using same value?

    Your readings are completely normal. SQL Server will claim as much memory as you allow it provided it thinks its needs it to efficiently serve data to clients. 1.6GB is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 12:36 pm

    #1463682

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Lynn Pettis (3/23/2012)

    As soon as I saw DB Mirroring, it makes sense. With that I would also assume that t-log backups are run periodically or after each load to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 12:25 pm

    #1463677

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    Lynn Pettis (3/23/2012)

    opc.three (3/23/2012)

    What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 12:14 pm

    #1463669

  • RE: Lightspeed - Automating Restore with Dynamic Filname

    Is xp_CmdShell enabled on your instance? If so, then you can issue a DOS DIR command on your backup directory and capture the results to a table, and then pick...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 12:00 pm

    #1463659

  • RE: Separate Staging Tables and Data Warehouse into different Databases.

    What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full recovery mode. Procs...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 11:53 am

    #1463650

  • RE: Can I sync windows credentials to SQL Logins?

    Anytime! While I could not provide an easy path or complete solution, I am happy to assist 🙂

    If you do not mind, if you decide to implement something, whether it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 11:43 am

    #1463640

  • RE: temp table

    See the section titled TempDB Temporary Tables in SQL Server[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 11:14 am

    #1463618

  • RE: How to Disable COM Components

    Here is a way to find all XSPs in a user-database that were not delivered by Microsoft as part of the base installation of SQL Server:

    SELECT *

    FROM ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 10:59 am

    #1463597

  • RE: Index Rebuild Maintenance Plan

    Instead of Maintenance Plans, check out Ola Hallengren's SQL Server Index and Statistics Maintenance. I started using it about a year ago and have never looked back at MPs.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 23, 2012 at 10:23 am

    #1463558

Viewing 15 posts - 4,816 through 4,830 (of 7,164 total)