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.
Under rare conditions, using IN clause can cause unexpected SQL behavior
I want to make you aware of a latest SQL Server 2008 hotfix documented in...
Author: JackLi Date: 02/11/2013
Query hint QUERYTRACEON is now documented publically
I just wanted to put a quick note that QUERYTRACEON is now publically documented in...
Author: JackLi Date: 02/07/2013
Don’t change value of that parameter
Parameter sniffing is a well known among SQL User community. But I have seen variations...
Author: JackLi Date: 02/03/2013
AppDomain unloading messages flooding the SQL Server error log
This blog is built directly from a customer reported issue. As I helped investigate the source...
Author: psssql Date: 01/30/2013
How can I get that user out of my table quickly
Recently, I worked on an customer issue to help tune their slow query. The query was fairly complex...
Author: JackLi Date: 01/22/2013
Getting a Power View report within Excel 2013 to work with SharePoint
I was setting up my SharePoint 2013 server to be able to use an Excel 2013 workbook that had a Power...
Author: Adam W. Saxton Date: 01/09/2013
Uneven query executions with parallelism
We had a customer who was doing stress testing on a machine with 40 cores. They designed...
Author: JackLi Date: 12/21/2012
How It Works: CMemThread and Debugging Them
The wait type of CMemThread shows up in outputs such as sys.dm_exec_requests. This post is...
Author: psssql Date: 12/20/2012
SQLCLR and sp_OA* procedures are not compatible
We ran into an issue today that is a bug you may need to be aware of because of its behavior. When a...
Author: psssql Date: 12/20/2012
Azure SQL Database Import/Export Service - Change always brings both challenges and benefits
We recently upgraded the Import/Export Service to v3 of the DAC Framework...
Author: Evan Basalik Date: 12/14/2012
How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)
Applies to: SQL 2005, 2008, 2008 R2, and SQL 2012 versions. The NODE an operating system page,...
Author: psssql Date: 12/13/2012
How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
This issue was puzzling until we stepped through the code and studied it in some detail. ...
Author: psssql Date: 12/11/2012
SQL Server 2012 Setup just got smarter…
For many years, I’ve been pushing for a way for our SQL Server setup to “fix itself” or “get...
Author: psssql Date: 12/06/2012
AlwaysOn ERROR: Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary.
This error surprised me when it showed up in the error log so I decided to dig into it a bit more....
Author: psssql Date: 12/05/2012
FileNotFoundException with Microsoft.AnalysisServices.Xmla
I ran across two cases that were hitting the following Exception within SharePoint trying to run the...
Author: Adam W. Saxton Date: 12/05/2012
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
The scenario: Table has a NTEXT column that the customer wanted converted to NVARCHAR(MAX) Data has...
Author: psssql Date: 12/03/2012
Analysis Services - Errors when trying to add a User as a Server Admin
When trying to add a user as a Server Admin to Analysis Services, you may encounter one of the...
Author: psssql Date: 11/16/2012
Ack! Where the heck did Azure Reporting and Data Sync go??!?!
As you might have noticed, we have been moving more and more of our portal functionality to the new...
Author: Evan Basalik Date: 11/14/2012
Using a Windows Azure worker role to generate reports using Azure Reporting
While trying to reproduce an issue in Azure Reporting, I found myself building a simple worker role...
Author: Evan Basalik Date: 11/12/2012
How Can Reference Counting Be A Leading Memory Scribbler Cause?
The concept of the memory scribbler comes up quite a bit in support. The term can often...
Author: psssql Date: 11/12/2012
Microsoft CSS @ PASS Summit 2012
This is a little later than we normally do it, but better late than never! During November...
Author: psssql Date: 10/31/2012
Worker thread governance coming to Azure SQL Database
NOTE: As of 1/10, this change is now live in our datacenters. Starting with the service update that...
Author: Evan Basalik Date: 10/30/2012
T-SQL Update Takes Much Longer Than The Matching Select Statement
I realize the title is generic and that is because the problem is generic. On the surface it would...
Author: psssql Date: 09/21/2012
SQL Server: Correlating Timestamps From Various Data Points
I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week...
Author: psssql Date: 09/11/2012
Revisiting Inside Tempdb….
As I prepare for my next PASS Summit talk for the upcoming 2012 Summit, Inside SQLOS 2012 I was...
Author: psssql Date: 09/08/2012
Bulk Insert and Kerberos
I recently worked on two Bulk Insert cases that dealt with Kerberos. My favorite past time! In both...
Author: Adam W. Saxton Date: 09/07/2012
How It Works: SQL Server AlwaysOn Lease Timeout
Nov 2013 Based in recent cases I needed to extend and clarify this post. The LeaseTimeout controls...
Author: psssql Date: 09/07/2012
AdomdConnectionException using PerformancePoint hitting Analysis Services
I was working with a customer who was encountering problems trying to use a PerformancePoint...
Author: Adam W. Saxton Date: 09/06/2012
How It Works: Online Index Rebuild - Can Cause Increased Fragmentation
SQL Server Books Online alludes to the fragmentation possibility but does not fully explain that the...
Author: psssql Date: 09/05/2012
Installing SQL Server on Windows 8
One of the things I often try to do is make sure I understand the experience of customers when...
Author: psssql Date: 09/01/2012
Strange Sch-S / Sch-M Deadlock on Machines with 16 or More Schedulers
Since it took me several days to track down this bug, and I did learn a couple of new things along...
Author: psssql Date: 08/31/2012
SharePoint Adventures : Reporting Services, Claims and One Way Trusts
I had an interesting case that was presented to me by our friends in the SharePoint support...
Author: Adam W. Saxton Date: 08/20/2012
SETSPN -A with Windows 2012 does a duplicate check upfront
If you have followed my posts, or caught my sessions at PASS, you may have figured out that Kerberos...
Author: Adam W. Saxton Date: 08/17/2012
SharePoint Adventures : AccessDeniedException when a user tries to Add Subscription
I’ve been seeing a few cases that relate to a previous blog post which involved an...
Author: Adam W. Saxton Date: 08/16/2012
PowerShell and AlwaysOn - Gotcha - Exception setting "ConnectionString": "Keyword not supported: 'applicationintent'."
Here is the an issue I saw come across an alias that is a gotcha! I’m running into a problem...
Author: psssql Date: 08/09/2012
How It Works: XEL Display in SQL Server Management Studio (SSMS) Row Limit
This is a simple issue but if you don't expect the behavior it can surprise you. The grid, used by...
Author: psssql Date: 08/02/2012
How It Works: SQL Server (BCP, Database I/O, Backup/Restore, …) Reports Operating System Error (665, 1450 or 33) when writing to the file - BIG DATA
Suresh and I have blogged about these issues before but this post will put another spin on the...
Author: psssql Date: 07/25/2012
SocketException when upgrading Reporting Services from SQL 2008/R2 to SQL 2012
I ran into an interesting case yesterday that brought back some memories. The customer had a SQL...
Author: Adam W. Saxton Date: 07/25/2012
PowerPivot : When versions get mixed up…
I worked a case today where they were trying to get SQL 2012 Reporting Services installed in a...
Author: Adam W. Saxton Date: 07/17/2012
Where Did My Availability Group (AG) Go?
I ran into an issue where the AG was no longer present on a specific node of my cluster but I had...
Author: psssql Date: 07/16/2012
SharePoint Adventures : Access Denied errors when using RS 2012 with a Claims SharePoint Site
I actually ran into this issue back in late April. I wanted to get this out sooner but life...
Author: Adam W. Saxton Date: 07/12/2012
SharePoint Adventures : “The connection either timed out or was lost” with RS DataSource to SSAS
A customer had encountered an issue with their SharePoint 2010 / Reporting Services 2012...
Author: Adam W. Saxton Date: 07/12/2012
Could not load file or assembly System.EnterpriseServices
While setting up a SharePoint 2010 environment with Reporting Services 2012, I hit an interesting...
Author: Adam W. Saxton Date: 07/11/2012
How It Works: DROP AVAILABILITY GROUP Behaviors
I just learned something new about the DROP AVAILABILITY GROUP command behavior that I didn't...
Author: psssql Date: 06/13/2012
How It Works: When is the FlushCache message added to SQL Server Error Log?
FlushCache is the SQL Server routine that performs the checkpoint operation. The following message...
Author: psssql Date: 06/01/2012
AlwaysON - HADRON Learning Series: Worker Pool Usage for HADRON Enabled Databases
I am on several e-mail aliases related to Always On databases (reference Availability Group, AG,...
Author: psssql Date: 05/17/2012
SQL Rally 2012 recap
Getting back into the swing of things, I thought I would post my thoughts about how SQL Rally 2012...
Author: Adam W. Saxton Date: 05/15/2012
CSS will be at SQL Rally
I’m happy to announce that the SQL Support group will be present at SQL Rally 2012 which will...
Author: Adam W. Saxton Date: 05/01/2012
Clarification about the two LPIM upgrade rules that did not FAIL
Consider the following scenario on a X64 system: You install SQL Server [2008 R2, 2008, 2005]...
Author: psssql Date: 04/30/2012