Forum Replies Created

Viewing 15 posts - 121 through 135 (of 223 total)

  • RE: How to configure sql server 2008 memory

    There are pro and con on 3GB. I am little confused.

    Should I change my boot.ini in my case scenario which 8GB Ram on Window Server 2003 Enterprise edition?

    multi(0) disk (0)...

  • RE: BCNF logical design

    Hi SQLBOT and GSquared,

    Many thanks for your advice and help.

    Enclosed are my final database scripts:

    --- CREATE Tables Roles

    CREATE TABLE dbo.ROLES (

    RoleIdsmallintNOT NULL,

    RoleNamechar(75)NOT NULL,

    RoleDescriptionvarchar(150)NULL

    );

    GO

    ALTER TABLE dbo.ROLES ADD CONSTRAINT [PK_RoleID] PRIMARY KEY...

  • RE: SQL SERVER 2005 Std edition license

    Jonathan,

    Thanks a lot of the Licensing -Mocirosoft, Contact information

    (800) 426-9400.

    Best regards,

    Edwin

  • RE: SQL SERVER 2005 Std edition license

    How many percentage from the initial cost that the company needs to pay on the second year?

    Thanks a lot for your information.

    Regards,

    Edwin

  • RE: Change the SQL Server TCP/IP Ports

    Perry,

    Thanks for your valuable help and advice.

    Regards,

    Edwin

  • RE: Database Mirroring in VMRC Plus

    I forgot to issues:

    Authorization [MyDomain\UserName] on my create endpoint statement.

    Regards,

    Edwin 😀

  • RE: Database Mirroring in VMRC Plus

    I figured it out and it's working now.

    Please ignore this posted. 😀

  • RE: Compare databases & TABLES

    Red Gate SQL Compare is very good tool.

    However, it did not guarantee 100% fit into your environment.

    For instance, DB_A located in Doman A and DB_B located different network segments...

  • RE: Database Health Report

    Hi room,

    I am interested too.

    Thanks,

    Edwin

  • RE: SAN Training

    Perry,

    The plan is 20 instances. My advice is 2 instances.

    I checked with SQL Training books indicated that both SQL Server 2005 std and enterprise can take advantage of the...

  • RE: SAN Training

    Hi Perry,

    How to add the AWE on 32 bits in boot.ini.

    For example:

    boot loader]

    timeout=30

    default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect

    Thanks,

    Edwin

  • RE: SAN Training

    Thanks to Todd, Moh and Perry help and advice.

    Hi Todd,

    Thanks for the Dell links.

    I contacted the Dell Sales person and asked about the SAN training classes. He informed me...

  • RE: SAN Training

    Perry,

    I ‘m a newbie on Storage Area Networks. I need to pick it up a lot and I only read some SAN articles on this forum.

    We are planning to...

  • RE: SAN Training

    Dell

    What kind of specific training the vendor will provide?

    What kind of training should I ask?

    Please advice on this?

    Thanks a lot for your kind help.

    Edwin

  • RE: SQL 2000 Database reports

    SQLORACLE,

    Can you direct me to the scripts?

    I only use:

    Select count (*) from table_name with (NOLOCK);

    go

Viewing 15 posts - 121 through 135 (of 223 total)