Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
SQL Server
»
query
»
kba
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
2000
2005
access violation
agent
alias
backups
blocking
blogs
condition
cpu
databases
delete
execution plan
FAQ
function
hash join
high cpu
hints
incorrect
internal
linked
long time
maintenance
merge
monitor
multi-processor
operation
outer join
parallel execution
performance
plan
processor
profiler
query performance
query plan
replication
resources
results
running
server
service pack
service pack2
slow
sp2
sqlexecute
statement
table
trigger
update
xml
Improve Performance on query execution - control Parameter Sniffing
Going back to basics 'parameter sniffing' is a process where SQL Optimizer helps (sniffs) the execution process any current parameter values during compilation or reccompilation process. It will attain a pass-along values to the query optimizer...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Mar 22 2010
Filed under:
Filed under:
sql server
,
profiler
,
performance
,
query
,
monitor
,
kba
,
maintenance
,
parallel execution
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Oct 21 2008
Filed under:
Filed under:
sql server
,
query
,
kba
,
function
,
results
,
sqlexecute
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"
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Jun 23 2008
Filed under:
Filed under:
sql server
,
query
,
kba
,
processor
,
delete
,
query plan
,
statement
,
internal
A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, May 12 2008
Filed under:
Filed under:
sql server
,
performance
,
query
,
kba
,
2000
,
2005
,
slow
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Oct 22 2007
Filed under:
Filed under:
sql server
,
query
,
kba
,
slow
,
query performance
FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Oct 17 2007
Filed under:
Filed under:
sql server
,
performance
,
query
,
kba
,
condition
,
outer join
,
long time
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
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 and Major Modifications...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Sep 25 2007
Filed under:
Filed under:
sql server
,
query
,
kba
,
incorrect
,
multi-processor
,
running
,
results
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
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Sat, Sep 22 2007
Filed under:
Filed under:
sql server
,
query
,
kba
,
service pack2
,
hints
,
access violation
,
hash join
High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Sep 20 2007
Filed under:
Filed under:
sql server
,
performance
,
databases
,
blogs
,
blocking
,
query
,
kba
,
cpu
,
execution plan
,
backups
,
resources
,
high cpu
,
FAQ
FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 30 2007
Filed under:
Filed under:
sql server
,
query
,
plan
,
kba
,
service pack2
,
processor
FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 30 2007
Filed under:
Filed under:
sql server
,
performance
,
update
,
query
,
kba
,
service pack
,
operation
FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan"
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you run a query that...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Aug 20 2007
Filed under:
Filed under:
sql server
,
query
,
sp2
,
kba
,
trigger
,
processor
FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used
Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error messages when you run a query against...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jun 27 2007
Filed under:
Filed under:
sql server
,
server
,
query
,
kba
,
table
,
linked
,
alias
FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: “The merge process failed to execute a query because the query timed out”
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Jun 22 2007
Filed under:
Filed under:
sql server
,
query
,
replication
,
kba
,
merge
,
agent
FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged”
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jun 13 2007
Filed under:
Filed under:
sql server
,
query
,
kba
,
xml
Page 1 of 1 (15 items)