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)
April, 2014
TechNet Blogs
»
SQL Server KBs and Blogs
»
April, 2014
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: Behavior of a 1 Trillion Row Index Build (Gather Streams from SORT)
Posted
8 months ago
by
SQL Server Support Content
I ran into this behavior working on a 1 trillion row, spatial index build but the behavior can apply to any Gather Streams operator, retaining the sort order as rows pass though it. I was just surprised a bit by the behavior until I dug deeper...
How to grab multiple parent/child elements from XML Data Source
Posted
8 months ago
by
SQL Server Support Content
We had a question come up about why an XML query wasn’t pulling a 2nd Parent/Child element from the resulting data. This was grabbing data off of a Web Service. The example I was given was a public Web Service call for getting Weather information...
SharePoint Adventures : Using Claims with Reporting Services
Posted
8 months ago
by
SQL Server Support Content
Back in February of 2011, I created a blog that walked through using Kerberos with Reporting Services . Since then, we have moved Reporting Services to a shared service within SharePoint. This changes the game and we are now in the Claims world...
Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center
Posted
8 months ago
by
SQL Server Support Content
X64 : http://download.microsoft.com/download/0/a/4/0a41538e-2d57-40ff-ae85-ec4459f7cdaa/RMLSetup_AMD64.msi X86 : http://download.microsoft.com/download/4/6/a/46a3217e-f523-4cc6-96e9...
RS, SharePoint and Forefront UAG Series – Intro
Posted
8 months ago
by
SQL Server Support Content
I have been working a fairly complicated case over the last year that involved running Reporting Services Reports through a Universal Access Gateway (UAG) to publish a SharePoint Site. I worked with an engineer (Alejandro Lopez) in the SharePoint...
RS, SharePoint and Forefront UAG Series – Part 2 (Operational Reports)
Posted
8 months ago
by
SQL Server Support Content
Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) (you are here) Part 3 – Power Pivot Gallery (Silverlight) Part 4 – Export a Power View Report to PowerPoint This piece took the longest amount of time to narrow down what was going...
RS, SharePoint and Forefront UAG Series – Part 3 (Power Pivot Gallery - Silverlight)
Posted
8 months ago
by
SQL Server Support Content
Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) Part 3 – Power Pivot Gallery (Silverlight) (you are here) Part 4 – Export a Power View Report to PowerPoint The last post really went into the meat of the issue that we had. ...
RS, SharePoint and Forefront UAG Series – Part 4 (Power View - Export to PowerPoint)
Posted
8 months ago
by
SQL Server Support Content
Part 1 – Intro Part 2 – Operational Reports (Classic RDL Reports) Part 3 – Power Pivot Gallery (Silverlight) Part 4 – Export a Power View Report to PowerPoint (you are here) The last part of this engagement was when they tried to Export a Power View report...
SQL Server 2014: TEMPDB Hidden Performance Gem
Posted
8 months ago
by
SQL Server Support Content
I ran across a change for TEMPDB BULK OPERATIONS (Select into, table valued parameters (TVP), create index with SORT IN TEMPDB, …) that you will benefit from. For example, I have a Create Index … WITH SORT IN TEMPDB that takes ~1 minute in SQL Server...
How It Works: FileStream (RsFx) Garbage Collection–Part (2)
Posted
8 months ago
by
SQL Server Support Content
In a previous post I outlined the basics of File Stream, garbage collection: http://blogs.msdn.com/b/psssql/archive/2011/06/23/how-it-works-filestream-rsfx-garbage-collection.aspx This post continues the discussion, outlining specific details as to how...
I think I am getting duplicate query plan entries in SQL Server’s procedure cache
Posted
8 months ago
by
SQL Server Support Content
Before the post dives into the subject I need to point out that Keith did most of the work. I just kept pestering him with various scenarios until he sent me the e-mail content I needed. Thanks Keith – Keith devised a set of steps that...
SQL Server 2014’s new cardinality estimator (Part 1)
Posted
8 months ago
by
SQL Server Support Content
One of the performance improvement in SQL Server 2014 is the redesign of cardinality estimation. The component which does cardinality estimation (CE) is called cardinality estimator. It is the essential component of SQL query processor for query plan...