Forum Replies Created

Viewing 15 posts - 19,456 through 19,470 (of 49,552 total)

  • RE: Primary Key TSQL

    Yes, but why? Gaps are a normal part of identity columns, any time an insert fails or a row is deleted there will be a gap. The identity can be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 8:51 am

    #1466994

  • RE: The server was unable to allocate from the system paged pool because the pool was empty.

    Have you gone through these?

    http://support.microsoft.com/kb/822219

    http://support.microsoft.com/kb/312362

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 8:15 am

    #1466958

  • RE: The server was unable to allocate from the system paged pool because the pool was empty.

    AWE? /PAE? /3GB?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 7:47 am

    #1466939

  • RE: "Microsoft SQL Server 2008 Internals" and it's "Chapter 4. Logging and Recovery".

    Shcherbunov Neil (3/30/2012)

    A!!! Think you are right, Kalen says about different minLSN, thanks to you for clear!

    But Kalen should choose less confuse term for "her" minLSN, 'Minimum crash LSN', may...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 7:46 am

    #1466938

  • RE: The server was unable to allocate from the system paged pool because the pool was empty.

    What's SQL's memory settings? How much memory on the server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 7:07 am

    #1466915

  • RE: "Microsoft SQL Server 2008 Internals" and it's "Chapter 4. Logging and Recovery".

    Two different things.

    The minLSN you are talking about (from BoL) is the one that controls log reuse. The MinLSN is the earliest of a number of things that keep the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 7:01 am

    #1466908

  • RE: Intra-Query Parallel Thread Deadlocks

    Please can you disable traceflag 1204, wait until you have another deadlock and post the entire deadlock graph.

    You have parallelism there, but I can't tell from that snippet if it's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 4:59 am

    #1466857

  • RE: set max server memory for a 32 bit server

    Please don't post multiple threads for the same problem. http://www.sqlservercentral.com/Forums/Topic1272448-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 4:57 am

    #1466855

  • RE: How do I go from SQL 2008 build 10.0.1600 to build 10.50.1600

    On a 32 bit operating system only 32 bit processes can run. On a 64 bit OS, both 32 and 64 can run. Hence if you installed SQL 2008 R2...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 4:55 am

    #1466854

  • RE: How do I go from SQL 2008 build 10.0.1600 to build 10.50.1600

    Did you install a separate R2 instance or did you upgrade the existing instance? From the description, sounds like you installed a separate instance so you have 2008 and 2008...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 30, 2012 at 3:40 am

    #1466831

  • RE: SQL 2008 - View - Order by Problem

    sdermer (3/29/2012)

    The view will order correctly if you use 'Select top 100000000000' or whatever number of records that you are sure to return all.

    For now, yes. In the next version...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 29, 2012 at 12:24 pm

    #1466554

  • RE: Max Memory- who suffers- Sql Server or OS?

    TravisDBA (3/29/2012)

    Isn't the (Windows) Lock Pages in Memory option due to be deprecated in future versions?

    No, it's a documentation error. It's AWE that in final deprecation and the deprecation...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 29, 2012 at 12:21 pm

    #1466551

  • RE: Log shipping restore error

    Huh?

    Suspect databases aren't a LAN (local area network) issue.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 29, 2012 at 9:04 am

    #1466413

  • RE: Indexing and Statistics Advice

    Updating stats at the end of imports is very good. I'm not that fond of manually created stats (unless auto-create stats is off)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 29, 2012 at 8:31 am

    #1466386

  • RE: How to design filegroups for large database

    Antares686 (3/29/2012)

    This is just the tip of potential question to ask, look at stuff already provided but you do need to understand what you are addressing versus just saying filegroups...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    March 29, 2012 at 8:09 am

    #1466368

Viewing 15 posts - 19,456 through 19,470 (of 49,552 total)