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 team.
Error 17953 - SidePageTable::Init() DeviceIoControl() : Operating system error 1(Incorrect function.) encountered.
When attempting to run dbcc checkdb or create a snapshot database you may encounter the following...
Author: psssql Date: 09/22/2010
Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000
We have a few customers who reported that some of their queries run slower following upgrade from...
Author: JackLi Date: 09/01/2010
Query performance and table variables
Technorati Tags: Performance Frequently, we see our customers using table variables in their stored...
Author: JackLi Date: 08/24/2010
Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates…..
In June I introduced you to a new Best Practices Analyzer for SQL Server, SQL Server 2008 R2 BPA:...
Author: psssql Date: 08/24/2010
How It Works: Timer Outputs in SQL Server 2008 R2 - Invariant TSC
I would love nothing more than to take you back to my high-school days running the 440 yard hurdles...
Author: psssql Date: 08/18/2010
How It Works: Enumeration of sys.messages
I ran into an issue which has some aspects I found interesting and thought you might as well. When...
Author: psssql Date: 08/16/2010
Replay Result Set Event (Replay * Events)
From: Robert Dorr Sent: Friday, August 13, 2010 8:58 AMSubject: RE: SQL Server Trace Replay -...
Author: psssql Date: 08/13/2010
When a full dump isn’t really a full dump…
I was working on a customer issue which involved debugging a dump. The dump was generated via...
Author: Adam W. Saxton Date: 08/04/2010
How It Works: Error 18056 - The client was unable to reuse a session with SPID ##, which had been reset for connection pooling
This message has come across my desk a couple of times in the last week and when that happens I like...
Author: psssql Date: 08/03/2010
SQL 2008 FileStream Fails to Enable After Setup on Cluster that uses Veritas Mountpoints
Recently a customer ran into an issue where they had successfully installed SQL Server 2008 SP1 on a...
Author: psssql Date: 07/29/2010
Installing SQL Integration Services after SQL Cluster Setup has Completed
Today I ran into an issue where, SQL Server 2008 SP1 was installed on a Windows 2008 cluster and was...
Author: psssql Date: 07/29/2010
Why does PREEMPTIVE_OS_GETPROCADDRESS Show a Large Accumulation?
There is a bug in SQL Server 2008 that causes PREEMPTIVE_OS_GETPROCADDRESS to include and accumulate...
Author: psssql Date: 07/21/2010
Sampling can produce less accurate statistics if the data is not evenly distributed
Recently I worked with a very knowledgable customer who called in and wanting to know things about...
Author: JackLi Date: 07/09/2010
Why is my SQL Clustered Instance changing authentication modes?
We get our fair share of cases related to SQL Server running ( or not running) on a Windows...
Author: psssql Date: 07/09/2010
Why doesn't SQL Server use statistics and index on this computed column?
In this post, I talked about how to use computed column to improve performance. By creating index on...
Author: psssql Date: 07/08/2010
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...
Author: psssql Date: 07/04/2010
My Kerberos Checklist…
I’ve had numerous questions regarding Kerberos, both internally within Microsoft and with...
Author: Adam W. Saxton Date: 06/23/2010
Known issues installing SQL 2008 R2 BPA relating to Remoting
After getting through the Pre-Reqs for BPA (PowerShell 2.0, MBCA, .NET Framework), you may hit one...
Author: Adam W. Saxton Date: 06/21/2010
Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)…
Some of you may have noticed I haven’t posted a blog in some time. Well, I’ve been a bit busy...
Author: psssql Date: 06/20/2010
Where did the SQL Server Instance disappear? The clue may be in the WMI logs!
We recently worked with a customer who ran into an interesting situation. This problem deals with...
Author: psssql Date: 06/12/2010
How It Works: SqlDataReader::RecordsAffected and Why it Returns -1
I encountered another interesting research issue to share with you. The documentation states...
Author: psssql Date: 06/08/2010
SQLIOSim - Is Error: Unable to get disk cache info really an error?
The short answer is that it is not an error and the message should be a WARNING. I looked at the...
Author: psssql Date: 06/08/2010
How It Works: Spinlock Of Type LPE_BATCH
A question arose asking - "What does the LPE_BATCH spinlock type represent?" You can see the LPE_*...
Author: psssql Date: 06/08/2010
Don’t touch that schema!!!
You know how every product that has an underlying database has documentation that says not to modify...
Author: psssql Date: 05/30/2010
SQL Server 2008 R2 New Non-Yield Ring Buffer Information
In 2002 the SQLOS team added specific checks for non-yielding scheduler issues. You may be familiar...
Author: psssql Date: 05/27/2010
How It Works: The SQLAgent Log File
I am still working to resolve the customers problem but during my investigation I briefly looked a...
Author: psssql Date: 05/27/2010
Reporting Services, Scale Out and Clusters…
Every once in a while, I get asked the question about deploying Reporting Services on a Cluster....
Author: Adam W. Saxton Date: 05/27/2010
Going dark next week…..
Our blog won’t have any posts next week due to an internal migration of the MSDN blog servers...
Author: psssql Date: 05/14/2010
RS Content Types and SharePoint 2010
When creating a new document library within SharePoint you have a few options. You can just...
Author: psssql Date: 05/11/2010
Follow-up to Questions from Europe PASS 2010….
I thought i would post some answers to questions I received during my pre-conference seminar at...
Author: psssql Date: 05/06/2010
Error 18056 can be unwanted noise in certain scenarios
I saw a lot of hits on the web when I searched for the Error message 18056 with State 29. I even saw...
Author: psssql Date: 05/05/2010
Europe PASS, a volcano, Live Meeting, and SQL 2008 R2 BPA….
What do these have in common? Sounds like a question on Jeopardy. There is some bad and good news as...
Author: psssql Date: 04/22/2010
AWE Allocated Values Reported Incorrectly (Large or Negative Value)
I ran into an issue today that is documented but you have to know where to find it so I wanted to...
Author: psssql Date: 04/21/2010
How It Works: Orphan DTC Transaction (Session/SPID = -2)
It looks like it would be a good post to help clarify that -2 does NOT mean...
Author: psssql Date: 04/20/2010
An important change for the Microsoft Lifecycle Support Policy….
Over the past few months I’ve filed some posts on our blog regarding our support lifecycle...
Author: psssql Date: 04/13/2010
The case of the additional indexes
I was assisting with a SQL Server performance issue the other day. The issue was transactional...
Author: psssql Date: 04/11/2010
How It Works: Soft NUMA, I/O Completion Thread, Lazy Writer Workers and Memory Nodes
There seems to be some semantic(s) confusion on the books online description of SOFT NUMA. The area...
Author: psssql Date: 04/02/2010
How to troubleshoot database corruption errors and System Center…
What do these two subjects have in common? The SQL Server product team is currently developing an...
Author: psssql Date: 04/01/2010
Unable to load CLR assembly intermittently
Recently, I worked with a customer on an CLR assembly loading issue.Intermittently, they would...
Author: psssql Date: 03/23/2010
What SPN do I use and how does it get there?
This month has turned into another Kerberos Month for me. I had an email discussion regarding...
Author: psssql Date: 03/09/2010
How It Works: SQL Server 2008 NUMA and Foreign Pages
I have received numerous questions about 'foreign pages' so I have put this post together to answer...
Author: psssql Date: 02/23/2010
TCP Offloading again?!
I have spent probably hundreds of hours on cases involving TCP Offloading and I know most of the...
Author: psssql Date: 02/21/2010
Did you start your SQL Server Engine correctly?
Often we run into situations where there is a need to add a trace flag or a startup parameter other...
Author: psssql Date: 02/19/2010
Microsoft CSS once again a big part of SQL European PASS Summit…
I’m very excited to be invited back to speak at the SQL European PASS Summit 2010 being held...
Author: psssql Date: 02/17/2010
Mainstream vs Extended Support and SQL Server 2005 SP4: Can someone explain all of this?….
Please note: Important changes to the support lifecycle policy for service packs that affect this...
Author: psssql Date: 02/17/2010
How to have a Select All Multi-Value Cascading Parameter
I’ve seen several cases that involved Multi-Value Cascading Parameters and how the behavior of those...
Author: psssql Date: 01/29/2010
How to get a x64 version of Jet?
We have had a number of people ask about how they can get the Jet ODBC driver/OLE DB Provider as 64...
Author: psssql Date: 01/21/2010
High CPU after upgrading to SQL Server 2005 from 2000 due to batch sort
We have had some customers who reported to us that their queries consumed more CPU in SQL Server...
Author: psssql Date: 01/11/2010