Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Tips and Tricks   (RSS)
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
Monday, February 19, 2007 1:14 PM

SQL 2005 SP2 is available now!

Finally, after rounds of CTPs (Community Technology Previews) and great feedback from customers, we have officially released Service Pack 2 (SP2) for SQL 2005. Download SP2 You can download it by visiting the Microsoft website here . Enhancements in SQL
Posted by sqlblog | 1 Comments
Friday, February 16, 2007 11:50 AM

PART II - Data security enhancements in SQL Server 2005

In the previous edition ( Data security enhancements in SQL Server 2005) , we talked about data encryption/decryption in general. In this installment, let’s talk about key maintenance. It is important to ensure that we can decrypt our data, even in case
Posted by sqlblog | 1 Comments
Friday, February 16, 2007 11:21 AM

Tools of the Trade: Part I – Universal Data Link Files

The other day I was working on an issue with one of our customers. I had been having him run several different tests using a few of the tools that we use on the SQL Developer team on a daily basis. After about the third or fourth diagnostic we ran, he
Posted by sqlblog | 4 Comments
Monday, January 29, 2007 10:39 AM

SQL Server 2000/2005 and DST changes

Background In August of 2005 the United States Congress passed the Energy Policy Act, which changes the dates of both the start and end of daylight saving time (DST). When this law goes into effect in 2007, DST will start three weeks earlier (2:00 A.M.
Posted by sqlblog | 1 Comments
Wednesday, December 06, 2006 3:16 PM

How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?

Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers. In SQL 2005, we have made several enhancements to help you avoid a reboot after applying Service Packs and hotfixes. To learn about these enhancements,
Posted by sqlblog | 1 Comments
Friday, November 10, 2006 6:44 PM

Tracking License Information in SQL 2005

SQL 2005 no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads the registry for this information, but the SQL 2005 setup doesn’t put licensing information in the registry during setup as in SQL 2000. This is
Posted by sqlblog | 15 Comments
Sunday, October 08, 2006 10:47 AM

Help! All of my reports fail with an authentication failure!

Have your Reporting Services 2005 reports started failing recently with the error message? Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Check your Unattended Execution Account (UEA).
Posted by sqlblog | 5 Comments
More Posts Next page »
 
Page view tracker