TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
SQL Server KBs and Blogs
Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news
Options
RSS for posts
Atom
RSS for comments
OK
Search Blogs
Tags
2008
2008 R2
ADAM
Alwayson
Connectivity
database engine
DBVideo
Engine
How It Works
Kerberos
NONSSIS
Performance
Reporting Services
SharePoint
SharePoint Adventures
SharePoint Integration
SQL 2005
SQL 2008
SQL 2012
SQL 2014
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 SP1
SQL Server 2012
SSIS
Archive
Archives
December 2014
(4)
November 2014
(5)
October 2014
(3)
September 2014
(1)
August 2014
(4)
July 2014
(5)
June 2014
(5)
May 2014
(5)
April 2014
(12)
March 2014
(3)
February 2014
(4)
January 2014
(2)
December 2013
(2)
November 2013
(14)
October 2013
(12)
September 2013
(6)
August 2013
(13)
July 2013
(10)
June 2013
(9)
May 2013
(9)
April 2013
(13)
March 2013
(15)
February 2013
(13)
January 2013
(3)
December 2012
(16)
November 2012
(4)
October 2012
(2)
September 2012
(10)
August 2012
(6)
June 2012
(7)
May 2012
(1)
April 2012
(4)
March 2012
(5)
February 2012
(5)
January 2012
(7)
December 2011
(1)
November 2011
(2)
October 2011
(4)
September 2011
(1)
August 2011
(4)
June 2011
(2)
May 2011
(2)
April 2011
(1)
February 2011
(2)
January 2011
(2)
December 2010
(2)
November 2010
(1)
August 2010
(1)
June 2010
(2)
April 2010
(1)
February 2010
(2)
January 2010
(2)
December 2009
(2)
August 2009
(1)
July 2009
(2)
February, 2013
TechNet Blogs
»
SQL Server KBs and Blogs
»
February, 2013
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Windows Phone App for SQL Server Support Content
Posted
over 1 year ago
by
SQL Server Support Content
2
Comments
Just wanted to let you all know that we recently released a WP app (SQL Support Content) that is an RSS aggregator for SQL Server Support blogs. The app essentially provides quick access to RSS feeds of various SQL Server support blogs (including PSSSQL...
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Don’t change value of that parameter
Posted
over 1 year ago
by
SQL Server Support Content
Parameter sniffing is a well known among SQL User community. But I have seen variations of this frequently that need a bit creative handling and solution may not that straight forward. One of the variation is that a user changes the value...
SQL Collation and related performance impact, viewing collation in query plans
Posted
over 1 year ago
by
SQL Server Support Content
It has been a while since there has been activity on this blog, we as a team will be trying to post weekly going forwards so as to share what we do on a regular basis – happy reading! I was posed a question by a fellow PFE during his performance...
Query hint QUERYTRACEON is now documented publically
Posted
over 1 year ago
by
SQL Server Support Content
I just wanted to put a quick note that QUERYTRACEON is now publically documented in http://support.microsoft.com/kb/2801413/en-us . If you have situations where you don’t want to enable an optimizer trace flag globally on your server instance, you...
MDX: SET overwrite and the use of EXISTING function
Posted
over 1 year ago
by
SQL Server Support Content
The SET overwrite is largely impacted by the attribute relationships and the behavior does depend on whether the attribute is below or above or no relationship in the relationship chains. For illustrate the point, I run a test base on the following...
Under rare conditions, using IN clause can cause unexpected SQL behavior
Posted
over 1 year ago
by
SQL Server Support Content
I want to make you aware of a latest SQL Server 2008 hotfix documented in http://support.microsoft.com/kb/2791745 . Using large number of constants in IN clause can result in SQL Server termination unexpectedly. When this happens...
Windows Phone App for SQL Server Support Content
Posted
over 1 year ago
by
SQL Server Support Content
2
Comments
Just wanted to let you all know that we recently released a WP app (SQL Support Content) that is an RSS aggregator for SQL Server Support blogs. The app essentially provides quick access to RSS feeds of various SQL Server support blogs (including PSSSQL...
Breaking Down 18065
Posted
over 1 year ago
by
SQL Server Support Content
We have had two blog posts on this blog regarding the 18056 error. Two from Bob Dorr (and part 2 ) and another from Tejas Shah . However, we still see a lot of questions about this error message. This error message can show up for different reasons...
Use PowerShell Script via startup Agent Job to balance Memory between two instances on a cluster on a Failover
Posted
over 1 year ago
by
SQL Server Support Content
Scenario: You have a two instance, two node cluster. SQL1 is typically running on Node1, SQL2 is typically running on Node2. The Objective is to maximize memory usage when each instance is running on its own node, yet balance memory usage if both of them...
RS: Database Engine does not meet edition requirements
Posted
over 1 year ago
by
SQL Server Support Content
I've ran across the following error a few times and thought I would post this out there for people to understand what is happening. ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices...
Unable to register .NET framework assembly not in the supported list
Posted
over 1 year ago
by
SQL Server Support Content
SQL Server has supported CLR usage since version 2005. But support of .NET framework assemblies within SQL Server is limited per our support policy in KB http://support.microsoft.com/kb/922672 . Some users chose to use .NET framework assemblies...
SQL Server 2012 Partially Contained Databases Part 1 - Contained Logins
Posted
over 1 year ago
by
SQL Server Support Content
The concept of database containment basically means that all instance level dependencies are severed from the database. If you have ever implemented log shipping or mirroring, you are probably aware of many of these. Instance level logins...
SQL Server 2012 Partially Contained Databases Part 2 - Collation
Posted
over 1 year ago
by
SQL Server Support Content
In my last post, I went over partial database containment and contained users. This post will focus on the other piece of functionality in partial containment… collation. The collation of data determines how data is sorted and compared...
Temp table caching improvement for table valued parameters in SQL Server 2012
Posted
over 1 year ago
by
SQL Server Support Content
I wanted to point out a nice performance improvement related to table valued parameters (TVP) in SQL Server 2012. It’s not currently documented in our online documentation. But we have had customers who inquired about this. When...