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

Problems you face when you do not check features not supported in SQL Server

Fri, 18 Sep 2009 11:06:00 GMT

Few developers on a client's place raised a question that why they should really be concerned about deprecated features or commands in SQL Server? Until SQL Server 2000 version it used to be a workaround to get the old scripts executed in a way. It...(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)

FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect results in SQL Server 2008

SqlServer-QA.net — Tue, 21 Oct 2008 14:38:00 GMT

Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect...(read more)

Dotnet 4.0

SqlServer-QA.net — Thu, 16 Oct 2008 19:54:00 GMT

Dotnet Framework 4.0 / Visual Studiod 2010 / VSTS 2010 : Next version of Dotnet is Visual Studio 2010 and Dotne Framwork 4.0. What will be NEW: Microsof is focusing on below new 5 areas for Dotnet Framework 4.0 / VisualStudio 2010 PlatformWave: We have...(read more)

Quick tips & tricks on fine tuning performance problem on a SQL Server instance.

SqlServer-QA.net — Mon, 06 Oct 2008 09:51:00 GMT

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself...(read more)

FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"

SSQA.net — Tue, 24 Jun 2008 01:30:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New FIX: Error message when...(read more)

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000

SSQA.net — Mon, 12 May 2008 18:43:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...(read more)

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

SSQA.net — Tue, 04 Mar 2008 08:04:00 GMT

If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...(read more)

See how Resource Governor can help you 'in action' in managing SQL Server resources?

SSQA.net — Fri, 08 Feb 2008 08:11:00 GMT

As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...(read more)

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?

SSQA.net — Tue, 05 Feb 2008 08:57:00 GMT

SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question...(read more)

SQL Server Analysis Services MDX Query performance monitoring - highlights

SSQA.net — Tue, 29 Jan 2008 09:27:00 GMT

When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve...(read more)

SQL Server 2005 methods to find table INDEX or Statistics age for better performance

SSQA.net — Wed, 09 Jan 2008 08:55:00 GMT

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller...(read more)

FIX: The query performance is slower when you run the query in SQL Server 2005 than when you run the query in SQL Server 2000

SSQA.net — Mon, 22 Oct 2007 11:13:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: The query performance is slower when...(read more)

FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005

SSQA.net — Wed, 17 Oct 2007 09:13:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications...(read more)

TSQL to list the most used query plans

SSQA.net — Fri, 28 Sep 2007 08:12:00 GMT

select TOP 100 objtype, p.size_in_bytes, LEFT([sql].[text], 100) as [text] from sys.dm_exec_cached_plans p outer apply sys.dm_exec_sql_text (p.plan_handle) sql ORDER BY usecounts DESC...( read more ) Read More......(read more)

FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join

SSQA.net — Tue, 25 Sep 2007 18:36:00 GMT

TSQL to create a TraceCollector with a default collection set

SSQA.net — Mon, 24 Sep 2007 10:45:00 GMT

use msdb declare @schedule_uid uniqueidentifier select @schedule_uid=(select schedule_uid from msdb..sysschedules where name=N'CollectorSchedule_Every_15min') declare @collection_set_id int; exec dbo.sp_syscollector_create_collection_set @name...(read more)

FIX: An access violation may occur when you run a query that uses a hash join hint in the x64 version of SQL Server 2005 Service Pack 2

SSQA.net — Sun, 23 Sep 2007 00:04:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...(read more)

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

SSQA.net — Thu, 20 Sep 2007 15:40:00 GMT

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...(read more)

Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks

SSQA.net — Wed, 05 Sep 2007 09:34:00 GMT

Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries...(read more)