Forum Replies Created

Viewing 6 posts - 661 through 667 (of 667 total)

  • RE: Maximum Capacity

    From BOL:

    [font="Tahoma"]SQL Server 2005 Workgroup Edition

    [Processor Type] Pentium III-compatible processor or higher

    [Processor Speed] Minimum: 600 MHz

    Recommended: 1 GHz or higher

    [Memory] Minimum: 512 MB

    Recommended: 1 GB or more

    Maximum: Operating system...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 3, 2008 at 3:06 am

    #837669

  • RE: How can I limit CPU usage per user in SQL 2005?

    Yuckon (2/6/2008)

    The stored procedures she is writing mostly consist of

    create proc uspHogTheServer as

    select * INTO #tmpHumongous from Massive

    INSERT INTO #tmpHumongous

    select * from Gigantic

    SELECT * FROM #tmpHumongous

    go

    Why don't you consider

    SELECT *...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 26, 2008 at 5:47 am

    #834541

  • RE: Function execution

    I got it wrong, in part because I didn't try it out, but also by relying on the trust I put into the SQL team, who should have thought of...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    May 20, 2008 at 4:32 am

    #817690

  • RE: SQL Server Express DAC

    Apologies, missed "Old Hand" remark. Cudos for the most hilareous post in the thread.

    Regards,

    Jan

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    April 24, 2008 at 4:01 pm

    #806924

  • RE: SQL Server Express DAC

    Hi all!

    Since I kicked off this thread (and was very surprised by the amount of subsequent posts about the matter) I feel obliged to give my two cents of wisdom...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    April 24, 2008 at 3:48 pm

    #806922

  • RE: SQL Server Express DAC

    Sorry, but I don't agree with the "correct" answer to the QotD. If one asks whether SQL Express allows DAC BY DEFAULT, then the answer should be a resounding NO!...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    April 24, 2008 at 1:23 am

    #806394

Viewing 6 posts - 661 through 667 (of 667 total)