SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
»
All Tags
»
query
(
RSS
)
Sign in
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
Media
Browse by Tags
Blogs
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Problems you face when you do not check features not supported in SQL Server
Indexes and UPDATE STATISTICS differences and undocumented options - SQL Server 2005
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
Dotnet 4.0
Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
Tags
2005
2008
best practice
best practices
community
conference
database
databases
dba
dmv
download
error
indexes
kba
microsoft
performance
query
replication
security
sql server
ssis
ssms
tsql
T-SQL
webcast
View more
News
Archives
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
.sqlplan
.xml
2000
2005
2008
access violation
agent
alias
Analysis Services
application
backups
bad
baseline
benchmarking
best practice
best practices
blocking
blogs
cache
cached
clr
collation
collecter
collection
condition
contribution
cpu
create
cte
databases
delete
deprecated
disabled
dmv
document
dotnet 4.0
dotnet framework 4.0
engine
error
execution
execution plan
FAQ
feature
forums
function
hash join
high cpu
hints
incorrect
index
index plan
indexed views
indexes
internal
joins
kba
knowledge
linked
mdx
monitoring
optimization
perfmance
performance
plan
processor
resources
results
running
script
security
self
server
service pack
service pack2
slow
sp2
sql server
sql server central
sqldiag
sqldumper
sqlexecute
ssas
ssms
ssp
statement
statiscs age
statistics
stats
stored procedure
table
tables
trigger
tsql
tuning
update
update statistics
upgrade advisor
users
visual studio 2010
xml
Problems you face when you do not check features not supported in SQL Server
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...
Published
Fri, Sep 18 2009 6:06
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
tools
,
query
,
best practices
,
deprecated
,
feature
,
disabled
,
upgrade advisor
Indexes and UPDATE STATISTICS differences and undocumented options - SQL Server 2005
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...
Published
Fri, Jan 16 2009 1:32
by
<P>SqlServer-Qa.net</P>
Filed under:
sql server
,
performance
,
indexes
,
query
,
optimization
,
procedure
,
update statistics
,
monitoring
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...
Published
Tue, Oct 21 2008 9:38
by
SqlServer-QA.net
Filed under:
sql server
,
query
,
kba
,
function
,
results
,
sqlexecute
Dotnet 4.0
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...
Published
Thu, Oct 16 2008 14:54
by
SqlServer-QA.net
Filed under:
query
,
visual studio 2010
,
dotnet 4.0
,
dotnet framework 4.0
,
VSTS 2010
Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
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...
Published
Mon, Oct 6 2008 4:51
by
SqlServer-QA.net
Filed under:
sql server
,
performance
,
query
,
optimization
,
best practices
,
hints
,
knowledge
,
performance monitoring
,
engine
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...
Published
Mon, Jun 23 2008 20:30
by
SSQA.net
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...
Published
Mon, May 12 2008 13:43
by
SSQA.net
Filed under:
sql server
,
performance
,
query
,
kba
,
2000
,
2005
,
slow
Query Execution Plans security and new feature within SQL Server 2008 Management Studio
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...
Published
Tue, Mar 4 2008 2:04
by
SSQA.net
Filed under:
sql server
,
performance
,
ssms
,
query
,
users
,
execution plan
,
monitoring
,
new features
,
.xml
,
plan cache
,
document
,
.sqlplan
See how Resource Governor can help you 'in action' in managing SQL Server resources?
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...
Published
Fri, Feb 8 2008 2:11
by
SSQA.net
Filed under:
application
,
sql server
,
management
,
blogs
,
security
,
query
,
2008
,
resource governor
SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
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...
Published
Tue, Feb 5 2008 2:57
by
SSQA.net
Filed under:
sql server
,
performance
,
blogs
,
blocking
,
security
,
query
,
best practice
,
index plan
,
sql server central
,
newsgroups
,
forums
SQL Server Analysis Services MDX Query performance monitoring - highlights
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...
Published
Tue, Jan 29 2008 3:27
by
SSQA.net
Filed under:
sql server
,
performance
,
mdx
,
query
,
best practices
,
tsql
,
monitoring
,
Analysis Services
,
baseline
,
benchmarking
SQL Server 2005 methods to find table INDEX or Statistics age for better performance
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...
Published
Wed, Jan 9 2008 2:55
by
SSQA.net
Filed under:
sql server
,
performance
,
query
,
index
,
process
,
agent
,
statistics
,
timeout
,
statiscs age
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...
Published
Mon, Oct 22 2007 6:13
by
SSQA.net
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...
Published
Wed, Oct 17 2007 4:13
by
SSQA.net
Filed under:
sql server
,
performance
,
query
,
kba
,
condition
,
outer join
,
long time
TSQL to list the most used query plans
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...
Published
Fri, Sep 28 2007 3:12
by
SSQA.net
Filed under:
sql server
,
query
,
plan
,
tsql
,
execution
,
cached
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...
Published
Tue, Sep 25 2007 13:36
by
SSQA.net
Filed under:
sql server
,
query
,
kba
,
incorrect
,
multi-processor
,
running
,
results
TSQL to create a TraceCollector with a default collection set
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...
Published
Mon, Sep 24 2007 5:45
by
SSQA.net
Filed under:
sql server
,
profiler
,
trace
,
query
,
tsql
,
collation
,
collecter
,
collection
,
msdb
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...
Published
Sat, Sep 22 2007 19:04
by
SSQA.net
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...
Published
Thu, Sep 20 2007 10:40
by
SSQA.net
Filed under:
sql server
,
performance
,
databases
,
blogs
,
blocking
,
query
,
kba
,
cpu
,
execution plan
,
backups
,
resources
,
high cpu
,
FAQ
Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks
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...
Published
Wed, Sep 5 2007 4:34
by
SSQA.net
Filed under:
sql server
,
performance
,
mdx
,
tuning
,
ssas
,
query
,
best practices
,
tsql
1
2
3
Next >
Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.
zines:andrewbelon.com