CSS SQL Server Engineers

Applies To:   SQL 2008, 2008 R2 and Denail builds The SQL Server developer can elect to partition memory allocations at different levels based on the what the memory is used for.   The developer may choose a global, CPU, Node, or even worker...

In SQL Server 2008 R2 SP1 we made updates to dynamically accommodate disk drives that present physical sector sizes greater than 512 bytes.   In practice, these are generally 4K, physical sector size drives and the SQL 2008 R2 transaction log...

In SQL Server 2008 some of the memory based DMVs show memory node id 0 when you might not expect them to.   For example you could see the following on a single, node system. SQL 2008 memory_clerk_address  type                     ...

In my last post, I reviewed the Microsoft CSS involvement at the upcoming 2011 SQL Server PASS Summit . One big part as I’ve mentioned is the SQL Server Clinic. I thought you might find it interesting to learn more about exactly what the clinic is and...

For the 9th year, the Microsoft CSS team will speak and meet customers at the SQL PASS Summit, being held  this year in Seattle, Washington from October 11th through the 14th. As in past summits, CSS will have a presence during pre-conference seminars...

  The following questions have surfaced several times recently so I decided to post the answers to assist others.   String is missing proper closing quote near (Char Pos: 0xC1 Byte Pos: 0x182) This is not a utility bug.   It is a command...