SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : performance

How fast you can obtain information about missing indexes? Its easy and quick!

Mon, 23 Nov 2009 00:26:00 GMT

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...(read more)

How SQL Server 2008 can help to build fast track data warehouse?

Fri, 09 Oct 2009 07:26:00 GMT

Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse....(read more)

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring

Fri, 21 Aug 2009 11:47:00 GMT

Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time...(read more)

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

Thu, 20 Aug 2009 14:21:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...(read more)

Microsoft Advisory Services Engagement Scenario - SQL Server Performance

Thu, 20 Aug 2009 14:19:00 GMT

Attaining SQL Server performance is not a black magic, you need to asses and implement the scenarios effectively. The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Edition & SQL Server...(read more)

Hyper-V and SQL Server Consolidation - whitepaper!

Tue, 28 Jul 2009 19:25:00 GMT

As you may know Hyper-V is the new kid on Windows 2008 block that offers the scalability enhancement using operating system for SQL Server. Here Microsoft IT has combined the power of Hyper-V and SQL Server that provides thousands of SQL Server instances...(read more)

SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

Mon, 27 Jul 2009 06:53:00 GMT

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...(read more)

Free Microsoft Press eBook offer - Introducing SQL Server 2008

Mon, 01 Jun 2009 14:55:00 GMT

Here is the interesting and fantastic news for the SQL Server users, Microsoft Press is offering eBook about "Introducing Microsoft SQL Server 2008" by Industry Experts & SQL Server MVPs - Greg Low, Peter DeBetta & Mark Whitehorn. *...(read more)

Do you know how many Monitoring Tools and Resources available in SQL Server?

Mon, 01 Jun 2009 07:25:00 GMT

Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...(read more)

Proactive caching for Analysis Services databases - performance techniques and better usage

Sun, 31 May 2009 14:32:00 GMT

By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...(read more)

SQL Server Edition - which is the best one to choose for your database needs?

Sun, 17 May 2009 17:54:00 GMT

When I look at the question, I feel that no direct answer to it! The reason being SQL Server has outgrown into an important enterprise RDBMS product from a simple desktop based database application, but still maintains the ease of installation and use...(read more)

SQL Server Performance patterns of a UDF with datetime parameters

Mon, 11 May 2009 07:10:00 GMT

There was an interesting discussion about User Defined Fuctions (UDF) performance and patterns, the actual phenomenon is that UDF has got parameters to pass on during the execution. Just to talk about introduction of such options in the SQL Server history...(read more)

Troubleshooting SQL Server 2008 Performance Problems

Sun, 12 Apr 2009 20:26:00 GMT

A new whitepaper covering the topic of performance troubleshooting in SQL Server 2008 has now been released. You can download the paper from the following link: http://msdn.microsoft.com/en-us/library/dd672789.aspx...( read more ) Read More......(read more)

Sharepoint Technologies - Monthly Technical Rollup

Wed, 01 Apr 2009 10:29:00 GMT

SharePoint Technologies Microsoft Office Protocol Documentation The Office protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in the Microsoft Office system. http://www.microsoft...(read more)

SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time

Tue, 17 Mar 2009 07:03:00 GMT

I have seen few users out there thinks that Deadlocks in SQL Server is a bug which has not be corrected by Microsoft since its release! Even few times they get think that deadlocks and blocking are similar reactions in SQL Server, a typical situation...(read more)

Reminder: Live Webcast TODAY! 10 Tips for Performance Monitoring - IDERA

Wed, 04 Feb 2009 09:01:00 GMT

Tired of phone calls from end users complaining about slow SQL Server performance? Tune into this two-part webcast to learn practical tips for proactively monitoring and managing SQL Server performance. In this live series, Greg Robidoux with Edgewood...(read more)

SQLcheck - a free performance monitoring tool from IDERA

Wed, 21 Jan 2009 09:22:00 GMT

SQLcheck is a free performance monitoring tool for SQL Server databases. It provides basic performance information for a single SQL Server and runs as a secure screensaver or on demand. Monitors key performance metrics Provides a view of processes, agent...(read more)

Indexes and UPDATE STATISTICS differences and undocumented options - SQL Server 2005

Fri, 16 Jan 2009 07:32:00 GMT

During an Usergroup meeting one user asked the question that why my query is affected with slow performance when the statistics are upto-date? When asked about the indexes the reply was why do you need indexes when you have updated statistics on all the...(read more)

Using SQL Server FORCESEEK table hint to solve PARAMETER SNIFFING issues

SqlServer-QA.net — Fri, 09 Jan 2009 16:57:00 GMT

Let us talk about few HINTS that can help to optimize the performance of a query, but bear in mind when using an INDEX hint it forces the query optimizer to use only the specified indexes to access the data in the referenced table or view in the query...(read more)

Technet events & webcasts - SQL Server related

SqlServer-QA.net — Fri, 09 Jan 2009 08:21:00 GMT

High Performance Computing (HPC) Traditional computing takes the form of an application running on a server or workstation. All of the commands for the application are processed on the local system. High Performance Computing (HPC) instead uses the processing...(read more)