CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • CSS SQL Server Engineers

    Don’t touch that schema!!!

    • 4 Comments
    You know how every product that has an underlying database has documentation that says not to modify the schema?  Do you always pay attention to that warning? If your product is Reporting Services, I just ran into a case today which I hope convinces...
  • CSS SQL Server Engineers

    SQL Server 2008 R2 New Non-Yield Ring Buffer Information

    • 1 Comments
    In 2002 the SQLOS team added specific checks for non-yielding scheduler issues. You may be familiar with the 178** series of errors like 17883 scheduler non-yield. Since 2002 the test matrix for SQL Server has flagged these errors and corrected them....
  • CSS SQL Server Engineers

    How It Works: The SQLAgent Log File

    • 3 Comments
    I am still working to resolve the customers problem but during my investigation I briefly looked a the SQLAgent logging format and thought you all might like some of these details. From: Robert Dorr Sent: Monday, May 24, 2010 9:47 AM Subject: RE: SPID...
  • CSS SQL Server Engineers

    Reporting Services, Scale Out and Clusters…

    • 3 Comments
    Every once in a while, I get asked the question about deploying Reporting Services on a Cluster. Usually it is tied to a scale out deployment, sometimes it is not. I just was asked the question again by an engineer in our group. So, I figured I should...
  • CSS SQL Server Engineers

    Going dark next week…..

    • 0 Comments
    Our blog won’t have any posts next week due to an internal migration of the MSDN blog servers to a new system. You can track the progress of this migration at this site: http://blogs.msdn.com/seanjenkin/archive/2010/05/12/during-the-upgrade-of-the-blogging...
  • CSS SQL Server Engineers

    RS Content Types and SharePoint 2010

    • 1 Comments
    When creating a new document library within SharePoint you have a few options.  You can just create a new Document Library, or you can go to More Options and choose Report Library.     When you choose Report Library, by default, it will...
  • CSS SQL Server Engineers

    Follow-up to Questions from Europe PASS 2010….

    • 0 Comments
    I thought i would post some answers to questions I received during my pre-conference seminar at Europe PASS 2010: Q: You said that trace flag 2528 disables parallelism for DBCC CHECKDB. Is there any way to force CHECKDB to use a parallel threads? A: No...
  • CSS SQL Server Engineers

    Error 18056 can be unwanted noise in certain scenarios

    • 8 Comments
    I saw a lot of hits on the web when I searched for the Error message 18056 with State 29. I even saw two Microsoft Connect items for this issue filed for SQL Server 2008 instances: http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID...
Page 1 of 1 (8 items)