Forum Replies Created

Viewing 15 posts - 136 through 150 (of 282 total)

  • RE: ANNOYED: SSMS messes with formatted scripts

    Lynn Pettis (11/21/2008)

    Different people may use different settings for tabs. I set up SSMS to replace tabs with spaces which eliminates this as an issue with my formatted scripts.

    SO...

    November 21, 2008 at 12:43 pm

    #901849

  • RE: Identify DB Owner from Backup File?

    george sibbald (10/24/2008)

    I don't think you would be able to get that information from a backup as its not held in the database itself but in master..sysdatabases.

    So perhaps you are...

    October 24, 2008 at 2:43 pm

    #889485

  • RE: Identify DB Owner from Backup File?

    Lowell (10/24/2008)

    i looked at the 4 special RESTORE commands that I know of in BOL:

    RESTORE HEADERONLY

    RESTORE FILELISTONLY

    RESTORE LABELONLY

    RESTORE VERIFYONLY

    looks like you can find the name of the user that...

    October 24, 2008 at 10:36 am

    #889352

  • RE: SQL 2005 Enterprise Edition x64 SP2

    Perry Whittle (8/5/2008)

    Lee Hart (8/5/2008)

    forgetting for a moment that SQL server Enterprise edition uses more than the standard install...

    both SQL 2005 Std and Ent address RAM up to the OS...

    August 5, 2008 at 10:25 pm

    #853617

  • RE: SQL 2005 Enterprise Edition x64 SP2

    Jeffrey Williams (8/5/2008)

    Lee Hart (8/5/2008)

    1. I had already set the Min and Max values for RAM (1 GB's & 6 GB's)

    2. I did configure the domain account for...

    August 5, 2008 at 2:56 pm

    #853510

  • RE: SQL 2005 Enterprise Edition x64 SP2

    Jeffrey Williams (8/5/2008)

    A couple of things you should look at:

    1) Setting MIN/MAX memory (which you have already done)

    a) Make sure MIN is at...

    August 5, 2008 at 2:43 pm

    #853501

  • RE: SQL 2005 Enterprise Edition x64 SP2

    I did set the MIN and MAX memory limits and I am noticing a SMALL change in the amount of CPU usage down to 90% from 100%...

    I ran the PROFILER...

    August 5, 2008 at 12:50 pm

    #853426

  • RE: SQL 2005 Enterprise Edition x64 SP2

    Initially I didn't set anything, forgetting for a moment that SQL server Enterprise edition uses more than the standard install...

    Once i realized that so much of the available memory was...

    August 5, 2008 at 11:43 am

    #853380

  • RE: SQL 2000 Security Fix KB948110

    GilaMonster (7/31/2008)

    A quick guess - have you removed Builtin\Administrators from the allowed logins? If so, put it back, make it sysadmin and try the patch again.

    No promises. That security patch...

    July 31, 2008 at 6:00 am

    #851187

  • RE: SQL 2000 Security Fix KB948110

    getting the same exact senario

    July 30, 2008 at 10:45 pm

    #850986

  • RE: Maintaining Statistics in 7.0 & 2000

    Hi Manu,

    I am watching the webcast now!

    Thanks,

    Lee

    June 9, 2008 at 12:19 pm

    #826255

  • RE: DUMB reindexing question

    toniupstny (5/19/2008)

    Have you tried to increase the Fillfactor for this index?

    Toni

    Hi Toni,

    That fill factor is the "recommended" fillfactor from the company and hence is the delivered fillfactor for those indexes...

    I...

    May 19, 2008 at 4:02 pm

    #817506

  • RE: sql server does not use index without hint

    GilaMonster (5/7/2008)

    What tends to cause massive fragmentation on the disk level is repeated shrinks and grows of the data file, especially if there are multiple data files on the same...

    May 7, 2008 at 2:22 pm

    #812075

  • RE: sql server does not use index without hint

    TheSQLGuru (5/7/2008)

    Rem (5/7/2008)

    One more thing. This table is truncated and repopulated on a weekly basis. No insert/delete or update are done to the table after the load. ...

    May 7, 2008 at 1:49 pm

    #812043

  • RE: Migrating from one sqlserver 2000 to another new sqlserver2000

    Hi Mark,

    I guess it is personal preference on how you want to do it...in the past I have done the following when we migrated servers to new hardware

    The new server...

    April 24, 2008 at 10:57 am

    #806742

Viewing 15 posts - 136 through 150 (of 282 total)