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
(6)
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)
September, 2012
TechNet Blogs
>
SQL Server KBs and Blogs
>
September, 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
Could not load package because of error 0x80070002 while upgrading from SSIS 2008 to SSIS 2012
Posted
7 months ago
by
SQL Server Support Content
When doing an In-place upgrade from Microsoft SQL Server 2008 or 2008 R2 to SQL Server 2012, be aware of this little caveat with SSIS. Last week I upgraded (note, I did an in-place upgrade and not a side-by-side installation) my Sql 2008 instance to Sql...
SQL Server KBs and Blogs
T-SQL Update Takes Much Longer Than The Matching Select Statement
Posted
7 months ago
by
SQL Server Support Content
I realize the title is generic and that is because the problem is generic. On the surface it would not surprise me that an update takes longer than a select. (A little bit anyway.) There is logging, updates to index rows, triggers, replication...
SQL Server KBs and Blogs
SQL Server: Correlating Timestamps From Various Data Points
Posted
8 months ago
by
SQL Server Support Content
I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging. Some times are local to the SQL...
SQL Server KBs and Blogs
Revisiting Inside Tempdb….
Posted
8 months ago
by
SQL Server Support Content
As I prepare for my next PASS Summit talk for the upcoming 2012 Summit, Inside SQLOS 2012 I was reviewing my talk from last year, Inside Tempdb , and some of the questions and feedback I received. They say it is never too late to provide all the facts...
SQL Server KBs and Blogs
Bulk Insert and Kerberos
Posted
8 months ago
by
SQL Server Support Content
I recently worked on two Bulk Insert cases that dealt with Kerberos. My favorite past time! In both cases, the customers were hitting the following error: Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file "<file name>"...
SQL Server KBs and Blogs
How It Works: SQL Server AlwaysOn Lease Timeout
Posted
8 months ago
by
SQL Server Support Content
The lease is used between the SQL Server resource DLL and the SQL Server instance to prevent split-brain from occurring for the availability group (AG). The lease is a standard signaling mechanism between the SQL Server resource DLL and the SQL Server...
SQL Server KBs and Blogs
AdomdConnectionException using PerformancePoint hitting Analysis Services
Posted
8 months ago
by
SQL Server Support Content
I was working with a customer who was encountering problems trying to use a PerformancePoint Dashboard against an Analysis Services Instance. The issue came down to the Claims to Windows Token Service (C2WTS) configuration. This is used to take...
SQL Server KBs and Blogs
Why is my command not timing out (JDBC)?
Posted
8 months ago
by
SQL Server Support Content
When working with the Microsoft JDBC driver for SQL Server, handling query timeouts is usually a fairly straight-forward issue. The driver supports the java.sql.Statement.setQueryTimeout() method and setting a timeout value through code will take...
SQL Server KBs and Blogs
How It Works: Online Index Rebuild - Can Cause Increased Fragmentation
Posted
8 months ago
by
SQL Server Support Content
SQL Server Books Online alludes to the fragmentation possibility but does not fully explain that the Online Index rebuilding may increase fragmentation when it is allowed to run with MAX DOP > 1 and ALLOW_PAGE_LOCKS = OFF directives . The process of...
SQL Server KBs and Blogs
Installing SQL Server on Windows 8
Posted
8 months ago
by
SQL Server Support Content
One of the things I often try to do is make sure I understand the experience of customers when installing new versions of SQL Server or existing versions of SQL Server on new Windows Operating Systems. So I took a recent tour of the experience installing...
Page 1 of 1 (10 items)