Browse by Tags

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
  • Blog Post: The case of the incorrect page numbers

    As you may or may not know, SSRS 2008 R2 added the ability to automatically create page breaks on group changes.  Historically, people attempted to use custom code to accomplish this and, while it worked, the pagination logic we use in SSRS 2008 R2 breaks the standard implementation of this for...
  • Blog Post: Easy JDBC Logging

    I have been supporting Microsoft’s JDBC driver for almost six years now and the one thing with which I always struggle is getting logging going.  JDBC logging is probably some of the most useful logging out there (I only wish BID tracing were so easy to enable and consume!), but for some reason...
  • Blog Post: Numbers are better than letters…

    Back in a post from May ( http://blogs.msdn.com/b/psssql/archive/2010/05/30/don-t-touch-that-schema.aspx ), I reported that SSRS referenced fields by index instead of by name in code for performance benefits.  As a follow up to that, I decided to do some testing to demonstrate the performance benefit...
  • Blog Post: Revisiting an old SSRS performance topic again…

    Almost three years ago, I posted about why Reporting Services takes so long to respond to the first request if it has been sitting idle for a long time (like overnight).  The original post can be found at http://blogs.msdn.com/b/sqlblog/archive/2007/11/09/reporting-services-staaaarrrrrtttt-up.aspx...
  • Blog Post: Don’t touch that schema!!!

    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 you to keep your hands off!!! The problem was...
  • Blog Post: The case of the additional indexes

    I was assisting with a SQL Server performance issue the other day.  The issue was transactional replication was unable to keep up while trying to replicate data from a transactional database to a reporting database.  This was causing the customer to miss their data latency SLAs.  The oddest...
  • Blog Post: It helps to read the “What’s New…” once in a while

    In the course of my job, I use ADPlus (a command-line tool that ships with Debugging Tools for Windows) to capture hang dumps on a regular basis.  For both low and high CPU scenarios, I generally need 2-3 hang dumps spaced out over about 10 minutes.  Historically, I have always given customers...
Page 1 of 1 (7 items)