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
(8)
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)
TechNet Blogs
>
SQL Server KBs and Blogs
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server KBs and Blogs
System Center Advisor is now free
Posted
2 months 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...
SQL Server KBs and Blogs
Windows Phone App for SQL Server Support Content
Posted
3 months ago
by
SQL Server Support Content
0
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...
SQL Server KBs and Blogs
TCPChimney KB article for SQL Server updated with additional info and guidance – Please check.
Posted
14 hours ago
by
SQL Server Support Content
0
Comments
Just wanted to update you all about the recent changes we had made to the KB article on this subject. The KB article now gives OS specific guidance on various settings that are part of 'High Speed networking features (formerly called as Scalable Networking...
Page 1 of 1 (3 items)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server KBs and Blogs
Getting a Power View report within Excel 2013 to work with SharePoint
Posted
4 months ago
by
SQL Server Support Content
I was setting up my SharePoint 2013 server to be able to use an Excel 2013 workbook that had a Power View Report in it. However, when I tried opening the workbook, I got the following error: In the ULS logs of my SharePoint server that had RS installed...
SQL Server KBs and Blogs
How can I get that user out of my table quickly
Posted
3 months ago
by
SQL Server Support Content
Recently, I worked on an customer issue to help tune their slow query. The query was fairly complex involving multiple table joins. The key issue is the inability to do seeks on a particular table. The table has a column that stores...
SQL Server KBs and Blogs
AppDomain unloading messages flooding the SQL Server error log
Posted
3 months ago
by
SQL Server Support Content
This blog is built directly from a customer reported issue. As I helped investigate the source of the issue I thought it would be of interest to a broader audience – hopefully you find this interesting, as well. Allow me to provide some history...
SQL Server KBs and Blogs
Don’t change value of that parameter
Posted
3 months 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 Server KBs and Blogs
Query hint QUERYTRACEON is now documented publically
Posted
3 months 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...
SQL Server KBs and Blogs
Under rare conditions, using IN clause can cause unexpected SQL behavior
Posted
3 months 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...
SQL Server KBs and Blogs
Windows Phone App for SQL Server Support Content
Posted
3 months ago
by
SQL Server Support Content
0
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...
SQL Server KBs and Blogs
Breaking Down 18065
Posted
3 months 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...
SQL Server KBs and Blogs
RS: Database Engine does not meet edition requirements
Posted
3 months 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...
SQL Server KBs and Blogs
Unable to register .NET framework assembly not in the supported list
Posted
2 months 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 KBs and Blogs
Temp table caching improvement for table valued parameters in SQL Server 2012
Posted
2 months 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...
SQL Server KBs and Blogs
switchoffset built-in function can cause incorrect cardinality estimate
Posted
2 months 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') ...
SQL Server KBs and Blogs
Integration services packages using Execute process task with WinZip32.exe fails intermittently, when run under a SQL Server Agent Job:
Posted
2 months 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...
SQL Server KBs and Blogs
Why is my Stored Procedure executed twice?
Posted
2 months 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...
SQL Server KBs and Blogs
"Cursor operation conflict" error while inserting data from flat file source to OLEDB destination
Posted
2 months 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...
SQL Server KBs and Blogs
Lookup Transform Error: Row yielded no match during lookup
Posted
2 months 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...
SQL Server KBs and Blogs
Flat File source cannot handle file with uneven number of columns in each row
Posted
2 months 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...
SQL Server KBs and Blogs
Ventured into BULK INSERTS
Posted
2 months 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...
SQL Server KBs and Blogs
SQL Server 2012 partitioned table statistics update behavior change when rebuilding index
Posted
2 months 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. ...
SQL Server KBs and Blogs
System Center Advisor is now free
Posted
2 months 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...
SQL Server KBs and Blogs
PowerPivot Table Import Wizard cannot find provider
Posted
1 month 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...
SQL Server KBs and Blogs
The Case of Anti-Virus filter drive interference with File Stream Restore
Posted
1 month 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...
SQL Server KBs and Blogs
SQLIOSim Checksum Validations
Posted
1 month ago
by
SQL Server Support Content
I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic. It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the...
SQL Server KBs and Blogs
How It Works: Always On–When Is My Secondary Failover Ready?
Posted
1 month ago
by
SQL Server Support Content
I keep running into the question: “When will my secondary allow automatic failover?” Based on the question I did some extended research and I will try to summarize in is blog post. I don’t want to turn this post into a novel so I am...
SQL Server KBs and Blogs
AlwaysON - HADRON Learning Series: HADR_SYNC_COMMIT vs WRITELOG wait
Posted
26 days ago
by
SQL Server Support Content
The distinction between these two wait types is subtle but very helpful in tuning your Always On environment. The committing of a transaction means the log block must be written locally as well as remotely for synchronous replicas. When in...
Page 5 of 6 (148 items)
«
2
3
4
5
6