Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Friday, August 28, 2009 12:26 PM

SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed

  There is a known issue with SQL Server setup when MSXML6 component update has been installed on the system. The problem described in KB 968749 http://support.microsoft.com/kb/968749 has raised a lot of concerns by customers. The concerns are related
Posted by sqlblog | 0 Comments
Friday, July 17, 2009 5:17 PM

How to configure SQL server to listen on different ports on different IP addresses?

Technorati Tags: SQL Port The following post describes how you can configure your SQL Server to listen on a different port(s) on different IP addresses that are available on your system. This procedure applies to both SQL server 2005 and SQL server 2008.
Posted by sqlblog | 0 Comments
Filed under:
Tuesday, July 14, 2009 7:27 PM

Dealing with very large SQL Compact database files

Working with very large SQL Compact files, you may run into two issues: 1. Manipulating a large SQL Compact database in VS 2008 IDE requires a hotfix http://support.microsoft.com/kb/968436 Error message when you use the Visual Studio 2008 IDE to manipulate
Posted by sqlblog | 0 Comments
Wednesday, June 24, 2009 3:12 PM

Performance: Tips for faster download of a large SQL Compact 3.5 database via Replication

SQL Compact 3.x Replication initial subscription is resource-intensive and may take significant time on devices. Read the introduction to the SQL Compact Blog for this problem. Introduction ( from SQL Compact Blog ) “The initial subscription is going
Posted by sqlblog | 0 Comments
Wednesday, April 15, 2009 7:53 PM

SQL Compact Performance: PostSyncCleanup to turn off UpdateStatistics during initial download of SQL Compact Replication

SQL Compact Replication initial subscription may take significant time on devices. The UpdateStatistics operation adds additional overhead to the initial download. Indicators: The Client Agent log may show the start and end times of UpdateStatistics operation.
Posted by sqlblog | 1 Comments
Wednesday, April 15, 2009 11:02 AM

Class not registered error after restoring an Analysis Services database that uses the SQL Server 2005 SQL Native Client.

After restoring an Analysis Services database that uses the SQLNCLI.1 SQL Native Client (SNAC) on a server which has never had SQL Server 2005 installed, an error similar to the following occurs during processing operations: Internal error: The operation
Posted by sqlblog | 2 Comments
Thursday, April 09, 2009 5:39 PM

After Installation of .NET Framework 3.5 SP1 (or .Net framework 2.0 SP2) , SSIS packages using ODBC 3rd party drivers may fail

The Issue: In the last few months, we have seen quite a few cases where after installing .net framework 3.5 SP1 ( KB http://support.microsoft.com/kb/951847 ), SSIS packages using certain ODBC 3 rd party drivers and importing character data may fail with
Posted by sqlblog | 2 Comments
Thursday, February 19, 2009 8:34 PM

Plan guides (plan freezing) in SQL Server 2005/2008

  SQL Server 2005   The plan guides were first introduced in SQL Server 2005.You may find detailed information about the plan guides in SQL Server 2005 here:   General information http://msdn.microsoft.com/en-us/library/ms187032(SQL.90).aspx
Posted by sqlblog | 6 Comments
Friday, November 09, 2007 4:01 PM

Reporting Services Staaaarrrrrtttt Up

I hear the complaint a lot that after a time period of no calls to Reporting Services, the first call to the Reporting Services instance is very slow. This is totally expected because the application pool generally gets spun down and we need to restart
Posted by sqlblog | 2 Comments
Tuesday, November 06, 2007 3:23 PM

Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases...

An Analysis Services 2005 query against a calculation on a cell may report the error: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples." This may be because there are simply more underlying cells in
Posted by sqlblog | 1 Comments
Thursday, September 06, 2007 9:17 AM

General network errors (GNEs), Timeout expired, SQL Server not found or Access Denied…

Many times, the key to solving these errors is a network packet trace. The problem is that these errors are often thrown intermittently. This can obviously make it problematic to capture a network trace. Network Monitor 3 (AKA Netmon3) solves this problem
Posted by sqlblog | 0 Comments
Tuesday, September 04, 2007 10:50 AM

Tools of the Trade: Part IV – WinDbg & AdPlus (I)

In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support -- Database commonly use, how to use them, and the types of issues they can be used to resolve. In this article, Enamul Khaleque starts down the
Posted by sqlblog | 0 Comments
Thursday, August 16, 2007 12:15 AM

SQL Server Support FAQ

How often should I expect to hear from my Support Engineer? This will vary based on the issue and its impact to your business. If you have specific preferences for frequency of contact, time of day, or method (prefer phone vs. e-mail), please discuss
Posted by sqlblog | 2 Comments
Monday, April 16, 2007 2:57 PM

Tools of the Trade: Part III – Kerberos (I)

In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support -- Database commonly use, how to use them, and the types of issues they can be used to resolve. In this article, Adam Saxton starts down the long
Posted by sqlblog | 1 Comments
Monday, April 16, 2007 2:52 PM

Tools of the Trade: Part II – The Repro

In this series of posts, we’re going to take a look at some of the tools we at Microsoft Developer Support -- Database commonly use, how to use them, and the types of issues they can be used to resolve. This post might seem like a bit of a stretch. For
Posted by sqlblog | 1 Comments
More Posts Next page »
 
Page view tracker