<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Articles with tags
Administering
,
Performance Tuning
Refine your search with one of the following additional tags (with number of items):
SQL Server 7, 2000
(6)
Stored Procedures
(2)
English Query
(1)
SQL Server 6.5
(1)
T-SQL
(6)
Advanced Querying
(1)
Installation
(1)
Strategies
(1)
Performance Tuning and Scaling
(5)
Backup and Recovery
(1)
Naming Standards
(1)
Triggers
(1)
Configuring
(2)
Basic Querying
(1)
OpenXML
(1)
UpdateGrams
(1)
Indexing
(2)
Database Design
(1)
Programming
(1)
User-Defined functions
(1)
Miscellaneous
(2)
Distributed Queries
(1)
Replication
(1)
XML
(1)
Monitoring
(2)
DTS
(1)
Security
(1)
XSL
(1)
Search for
any
content tagged
Administering & Performance Tuning
Items 1 to 8 of 8
Moving the tempdb database
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
Read more...
By
Additional Articles
2007/12/06
|
Source:
SQLTeam.com
|
Category:
Administering
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,865 reads
Execution Plans
How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.
Read more...
By
G Vijayakumar
2005/10/07 (first posted: 2004/05/06)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
38,855 reads
SQL Maintenance Plans
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
Read more...
By
Andy Warren
2005/03/04 (first posted: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
28,609 reads
Stored Procedures and Caching
One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.
Read more...
By
Brian Kelley
2004/11/19 (first posted: 2002/01/28)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
32,627 reads
Execution Plans
How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.
Read more...
By
G Vijayakumar
2005/10/07 (first posted: 2004/05/06)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
38,855 reads
Review of SQL 2000 Fast Answers
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
Read more...
By
Andy Warren
2003/04/18
|
Source:
SQLServerCentral.com
|
Category:
Installation
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
17,001 reads
Identifying performance issues using Profiler
It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored procedures for analyzing Profiler output.
Read more...
By
Additional Articles
2003/04/01
|
Source:
Other
|
Category:
Administering
Rating:
Rate this
|
Briefcase
|
1,839 reads
Interact with SQL Server's Data and Procedure Cache
This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
Read more...
By
Randy Dyess
2002/08/15
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
10,404 reads
SQL Maintenance Plans
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
Read more...
By
Andy Warren
2005/03/04 (first posted: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
28,609 reads
Stored Procedures and Caching
One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.
Read more...
By
Brian Kelley
2004/11/19 (first posted: 2002/01/28)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
32,627 reads
Locking in SQL Server 6.5
This article examines how locking occurs in SQL Server 6.5
Read more...
By
Alexander Chigrik
2001/07/13
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
2,636 reads
Items 1 to 8 of 8
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
