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)
December, 2012
TechNet Blogs
»
SQL Server KBs and Blogs
»
December, 2012
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
No blog posts have yet been created.
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
Posted
over 2 years ago
by
SQL Server Support Content
The scenario: Table has a NTEXT column that the customer wanted converted to NVARCHAR(MAX) Data has both small and large storage for different rows Issued ALTER TABLE … ADD COLUMN …NVarCharColumn… NVARCHAR(MAX) Issued update MyTable set NVarCharColumn...
FileNotFoundException with Microsoft.AnalysisServices.Xmla
Posted
over 2 years ago
by
SQL Server Support Content
I ran across two cases that were hitting the following Exception within SharePoint trying to run the PowerPivot Management Portal. This was located in the SharePoint ULS Log: EXCEPTION: System.IO.FileNotFoundException: Could not load file or assembly...
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.
Posted
over 2 years ago
by
SQL Server Support Content
This error surprised me when it showed up in the error log so I decided to dig into it a bit more. “Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed...
SQL Server 2012 Setup just got smarter…
Posted
over 2 years ago
by
SQL Server Support Content
For many years, I’ve been pushing for a way for our SQL Server setup to “fix itself” or “get smarter”. What I mean is that I’ve always wanted a way for setup to detect if any fixes are available online to apply as part of running the original installation...
How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
Posted
over 2 years ago
by
SQL Server Support Content
This issue was puzzling until we stepped through the code and studied it in some detail. The report was “SQL Server won’t use the physical memory I expect it to use.” Scenario: SQL Server 2008 R2, 32GB RAM - SQL only using ~22GB...
How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)
Posted
over 2 years ago
by
SQL Server Support Content
The NODE an operating system page, physically belongs to can be acquired using the QueryVirtualMemoryEx Windows API. SQL Server uses this API to track locality of memory allocations. This blog is a very high level view of SQL Server behavior but...
Azure SQL Database Import/Export Service - Change always brings both challenges and benefits
Posted
over 2 years ago
by
SQL Server Support Content
We recently upgraded the Import/Export Service to v3 of the DAC Framework ( http://technet.microsoft.com/en-us/library/ee210546.aspx ). This aligns the Import/Export service with what shipped with SQL Server 2012. Like all upgrades, this has brought both...
How to limit connections to SQL Server until all databases are ONLINE!
Posted
over 2 years ago
by
SQL Server Support Content
Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this...
How to Login to SQL Server with NT AUTHORITY\SYSTEM using PSExec Tool
Posted
over 2 years ago
by
SQL Server Support Content
PSExec tool gives you an option to run a remote process or an application using System account, if SYSTEM account has permission on that application. Although there are many more features that are For example, if SQL Server has NT AUTHORITY\SYSTEM...
Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
Posted
over 2 years ago
by
SQL Server Support Content
My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue along with data access technologies and SSIS. I had chance to work with SQL DBA who was having issues while connecting to his SQL server machine. We...
Openrowset and FoxPro Database
Posted
over 2 years ago
by
SQL Server Support Content
I wanted to write about one of my experiences where I nearly pulled off my hair while trying to make an Openrowset call to my FoxPro Database work from my SQL Server. It was high time when we decided to move over, discard my old FoxPro databases and migrate...
Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS
Posted
over 2 years ago
by
SQL Server Support Content
Folks, yet another stumble with SSIS and Excel. This time I am using Microsoft Office 11.0 Object Library. The code runs fine on Windows Server 2003. Below is the code sample. ======================================================= using Microsoft.Office...
Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)
Posted
over 2 years ago
by
SQL Server Support Content
With the explosion of data, the open source Apache™ Hadoop™ Framework is gaining traction thanks to its huge ecosystem that has arisen around the core functionalities of Hadoop distributed file system (HDFS™) and Hadoop Map Reduce. As of today, being...
SQLCLR and sp_OA* procedures are not compatible
Posted
over 2 years ago
by
SQL Server Support Content
We ran into an issue today that is a bug you may need to be aware of because of its behavior. When a SQLCLR procedure calls back into the SQL Server (in proc provider) and executes sp_OA*, during the callback activity, it triggers a bug (currently...
How It Works: CMemThread and Debugging Them
Posted
over 2 years ago
by
SQL Server Support Content
The wait type of CMemThread shows up in outputs such as sys.dm_exec_requests. This post is intended to explain what a CMemThread is and what you might be able to do to avoid the waits. The easiest way to describe a CMemThread is to talk about...
Uneven query executions with parallelism
Posted
over 2 years ago
by
SQL Server Support Content
We had a customer who was doing stress testing on a machine with 40 cores. They designed a program that would launch multiple connections to execute the same query repeatedly based on their requirement to handle multiple concurrent executions... Read...