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
2005
2005 SP2
2008
2008 R2
Adam
AlwaysON
Connectivity
Database Engine
DBVideo
Engine
How It Works
Kerberos
NONSSIS
Performance
Reporting Services
SharePoint Adventures
SQL 2005
SQL 2008
SQL 2012
SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 SP1
SQL Server 2012
SSIS
Archive
Archives
May 2013
(9)
April 2013
(13)
March 2013
(15)
February 2013
(9)
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)
February 2011
(2)
January 2011
(2)
December 2010
(2)
November 2010
(1)
June 2010
(2)
April 2010
(1)
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.
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server KBs and Blogs
Uneven query executions with parallelism
Posted
4 months ago
by
SQL Server Support Content
0
Comments
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...
SQL Server KBs and Blogs
How It Works: CMemThread and Debugging Them
Posted
5 months 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...
SQL Server KBs and Blogs
SQLCLR and sp_OA* procedures are not compatible
Posted
5 months 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...
SQL Server KBs and Blogs
Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)
Posted
5 months 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...
SQL Server KBs and Blogs
Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS
Posted
5 months 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...
SQL Server KBs and Blogs
Openrowset and FoxPro Database
Posted
5 months 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...
SQL Server KBs and Blogs
Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."
Posted
5 months 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...
SQL Server KBs and Blogs
How to Login to SQL Server with NT AUTHORITY\SYSTEM using PSExec Tool
Posted
5 months 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...
SQL Server KBs and Blogs
How to limit connections to SQL Server until all databases are ONLINE!
Posted
5 months 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...
SQL Server KBs and Blogs
Azure SQL Database Import/Export Service - Change always brings both challenges and benefits
Posted
5 months 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...
SQL Server KBs and Blogs
How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)
Posted
5 months 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...
SQL Server KBs and Blogs
How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
Posted
5 months 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...
SQL Server KBs and Blogs
SQL Server 2012 Setup just got smarter…
Posted
5 months 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...
SQL Server KBs and Blogs
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
5 months 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 KBs and Blogs
FileNotFoundException with Microsoft.AnalysisServices.Xmla
Posted
5 months 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...
SQL Server KBs and Blogs
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
Posted
5 months 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...
Page 1 of 1 (16 items)