Forum Replies Created

Viewing 15 posts - 2,206 through 2,220 (of 8,416 total)

  • RE: Memroy Issue

    Roy Ernest (1/13/2011)

    Regarding pagefile size, there are lots of confusing ideas out there. For normal application and file servers, you set the size as 1 to 1.5 times that of...

    January 13, 2011 at 5:26 pm

    #1273372

  • RE: Lock pages in Memory

    Rem70Rem (1/13/2011)

    For now I am running:

    Microsoft SQL Server 2005 - 9.00.3282.00 (X64) (Build 3790: Service Pack 2) . Can I lock the page in memory? I...

    January 13, 2011 at 5:05 pm

    #1273370

  • RE: Memroy Issue

    Roy Ernest (1/13/2011)

    Paul, The system_cache_kb is currently 593464. Unfortunately all the memory counters are kind of useless since I did a controlled reboot of the Server.

    Much better than an uncontrolled...

    January 13, 2011 at 7:35 am

    #1273032

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/13/2011)

    Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so the whole thing...

    January 13, 2011 at 6:50 am

    #1272994

  • RE: Are the posted questions getting worse?

    GilaMonster (1/13/2011)

    Happened here a few years back. The 1c and 2c coins were discontinued and are no longer legal tender. Shops are required to round down a customer's total bill...

    January 13, 2011 at 4:16 am

    #1272936

  • RE: Lock pages in Memory

    sachnam (1/12/2011)

    To Avail the benefits of Lock Pages in Memory in Sql server Standard Edition it is Mandatory to Enable the Trace Flag 845 REgardless of which Version of sql...

    January 12, 2011 at 9:46 pm

    #1272794

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/12/2011)

    Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made mistakes...

    January 12, 2011 at 9:42 pm

    #1272792

  • RE: Memroy Issue

    Roy Ernest (1/12/2011)

    We have 280 GB database hosted on a Server (4 x 6 core processor). The total Physical RAM available is 256 GB. Out of which 221 is set...

    January 12, 2011 at 9:40 pm

    #1272791

  • RE: Lock pages in Memory

    sqldba_icon (1/12/2011)

    I am runnning sql 2005 64 bit std edition with Sp3 + CU10 ..do i still need to enable the trace flag?

    Yes.

    January 12, 2011 at 6:19 pm

    #1272755

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/6/2011)

    Not to insert a technical discussion here, but could you explain how NULLIF and COALESCE introduce subtle bugs. Perhaps start another thread and put the link here...

    January 6, 2011 at 6:02 am

    #1270035

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/5/2011)

    Personally, I'd prefer a NULL to be returned instead of an error...

    Hmmm. That's an interesting question. I don't like the idea of NULL being overworked (yet...

    January 6, 2011 at 2:43 am

    #1269942

  • RE: Simple question regarding locks

    Hey Roy,

    This is a complex topic, but the most useful general point I can make is that locking tends to add CPU overhead rather than anything else. Alex Kuznetsov...

    January 5, 2011 at 3:13 pm

    #1269785

  • RE: Understanding T-SQL Expression Short-Circuiting

    sknox (12/30/2010)

    I know how to write an XOR using AND/OR/NOT.

    Yes, but Gianluca wasn't to know that. You might have been asking a sensible question, rather than just making the...

    December 30, 2010 at 1:16 pm

    #1267925

  • RE: Remove non printable characters

    telastruct (12/30/2010)

    Actually, I did test it and it works great. I tested it on a table with almost 4 million rows and it only took a minute or two.

    Now try...

    December 30, 2010 at 12:44 pm

    #1267904

  • RE: GetDate() or CURRENT_TIMESTAMP

    Gianluca Sartori (12/30/2010)

    According to BOL all of these return the same result and can be assigned to any of the date datatypes:

    SELECT SYSDATETIME()

    ,SYSDATETIMEOFFSET()

    ...

    December 30, 2010 at 1:46 am

    #1267563

Viewing 15 posts - 2,206 through 2,220 (of 8,416 total)