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)
March, 2013
TechNet Blogs
»
SQL Server KBs and Blogs
»
March, 2013
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
System Center Advisor is now free
Posted
over 1 year ago
by
SQL Server Support Content
It has been well over a year when I wrote a series of blog posts about a product called System Center Advisor. You can read these posts at this link http://blogs.msdn.com/b/psssql/archive/tags/system+center+advisor/ When Advisor was first released, this...
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Lookup Transform Error: Row yielded no match during lookup
Posted
over 1 year ago
by
SQL Server Support Content
Guys, Recently, I had to implement a lot of data warehousing solutions, hence I stumbled on an error in the SSIS Lookup transform task which I wanted to share. Most of my package tasks went on fine till it hit the below error in the Lookup task after...
Troubleshooting SQL Server High CPU usage using Xperf
Posted
over 1 year ago
by
SQL Server Support Content
Xperf/WPA is a powerful Windows tracing tool that can be used to assist in troubleshooting numerous issues on a Windows server. The utility allows for in depth tracing without the high overhead typically associated with such tracing...
SQL Server 2012 partitioned table statistics update behavior change when rebuilding index
Posted
over 1 year ago
by
SQL Server Support Content
In this blog, I will talk about a couple of things related to statistics update when rebuilding index on a partitioned table. In past versions, when you rebuild an index, you will get statistics update equivalent to FULLSCAN for free. ...
"Cursor operation conflict" error while inserting data from flat file source to OLEDB destination
Posted
over 1 year ago
by
SQL Server Support Content
I was working on one of the issue related with SSIS OLEDB destination editor. Here is the scenario. We are fetching the record from the excel file and inserting into the SQL through SSIS by using flat file source and OLEDB destination. While running the...
Observing SQL Server Transaction Log Flush Sizes using Extended Events and Process Monitor
Posted
over 1 year ago
by
SQL Server Support Content
In this blog post we’ll take a look at how SQL Server interacts with the transaction log file using Extended Events and Process Monitor. We will see how small transactions can have a negative impact on transaction log IO throughput and how larger...
Why is my Stored Procedure executed twice?
Posted
over 1 year ago
by
SQL Server Support Content
Yesterday morning I spent quite a few hours on a problem that almost made my crazy. It was a simple little SSIS package executing a stored procedure on my SQL and writing the data out to a disk file. I used an OLE DB Source in my Data Flow and the first...
switchoffset built-in function can cause incorrect cardinality estimate
Posted
over 1 year ago
by
SQL Server Support Content
Recently, we received a call from a customer reported that a query was slow. Upon further investigation, his query has a predicate that look like this: select * from t o where c1 >switchoffset (Convert(datetimeoffset, GETDATE()), '-04:00') ...
Integration services packages using Execute process task with WinZip32.exe fails intermittently, when run under a SQL Server Agent Job:
Posted
over 1 year ago
by
SQL Server Support Content
This blog is about one of the known issues that anyone would run into when executing an Integration services package that contains an Execute Process Task calling a custom or 3 rd party executable scheduled through a SQL Agent job. The scheduled job fails...
Flat File source cannot handle file with uneven number of columns in each row
Posted
over 1 year ago
by
SQL Server Support Content
I hope not many people are using flat file with such kind of structure, but if you are then no worries now you don’t have to do any weird adjustments. J I took some time to figure out what is going wrong here and why it is not working, and it caused some...
Dissecting SQL Server physical reads with Extended Events and Process monitor
Posted
over 1 year ago
by
SQL Server Support Content
In this blog post I’ll (re)introduce you to a really neat tool to use alongside of SQL Server and use this tool to show you how SQL Server is handling IO under the covers. We will view the IOs as they occur, and then tie the IO back to the...
SQL FileStream Restore and Anti-Virus
Posted
over 1 year ago
by
SQL Server Support Content
I encountered an interesting case with FileStream and Antivirus which I looked at with Bob Dorr, blogged about it on the PSS SQL Blog, thought I’d share that link here as well http://blogs.msdn.com/b/psssql/archive/2013/03/29/the-case-of-anti-virus-filter...
System Center Advisor is now free
Posted
over 1 year ago
by
SQL Server Support Content
It has been well over a year when I wrote a series of blog posts about a product called System Center Advisor. You can read these posts at this link http://blogs.msdn.com/b/psssql/archive/tags/system+center+advisor/ When Advisor was first released, this...
The Case of Anti-Virus filter drive interference with File Stream Restore
Posted
over 1 year ago
by
SQL Server Support Content
"Denzil and I were working on this issue for a customer and Denzil has been gracious enough to write-up a blog for all of us." – Bob Dorr From Denzil: I recently worked with a customer on a Database restore issue where the database being restored had...
Ventured into BULK INSERTS
Posted
over 1 year ago
by
SQL Server Support Content
Recently, whilst working with bulk insert queries I came across an unexpected result set which led to some more research. Therefore, following facts/tips/tricks/workarounds might help you: If you execute the following code for example: NOTE...
PowerPivot Table Import Wizard cannot find provider
Posted
over 1 year ago
by
SQL Server Support Content
The data source provider list in PowerPivot can often be a source of confusion for users since they equate the fact that a provider appears in the list as the provider being installed and available. Unfortunately, the list of providers is actually a static...