Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
Miscellaneous
,
Performance Tuning
Items 1 to 20 of 25
Older >>
Tracing Deadlocks
New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.
Read more...
By
Shiv Kumar
2007/04/06 (first published: 2004/04/06)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
43,683 reads
Table Variables
New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.
Read more...
By
Jambu Krishnamurthy
2006/11/21
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
16,436 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first published: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
47,291 reads
Performance Monitoring by Internal Fragmentation Measurement
It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.
Read more...
By
Koby Biller
2005/08/16
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
8,413 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 published: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
33,837 reads
Reducing Round Trips Part 4
The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!
Read more...
By
Andy Warren
2004/04/23
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
8,954 reads
Tracing Deadlocks
New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.
Read more...
By
Shiv Kumar
2007/04/06 (first published: 2004/04/06)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
43,683 reads
Dealing With Changing Data
As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.
Read more...
By
Christoffer Hedgate
2003/12/19
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
9,426 reads
Scaling Out
Kumar discusses the differences between scale up and scale out, then does a very good walk through of how to build a scale out solution.
Read more...
By
Kumar Part
2003/12/03
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
7,291 reads
Importing And Analyzing Event Logs
Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!
Read more...
By
Gheorghe Ciubuc
2003/05/28
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
12,804 reads
COM+, SQL Server, Serializable isolation level and the issues!
This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.
Read more...
By
Additional Articles
2003/05/22
|
Source:
Other
|
Category:
performance tuning
Rating:
Rate this
|
Briefcase
|
1,735 reads
Economies of Speed Whitepaper
Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.
Read more...
By
Additional Articles
2003/05/08
|
Source:
Other
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
1,450 reads
Auto Close and Auto Shrink - Just Don't
New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.
Read more...
By
Mike Pearson
2003/05/05
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
19,985 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first published: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
47,291 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:
|
Discuss
|
Briefcase
|
18,208 reads
Cluster That Index!
Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.
Read more...
By
Christoffer Hedgate
2003/03/30
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
18,118 reads
Using Interface-Based Programming Techniques in SQL Server
Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL.
Read more...
By
Chris Cubley
2002/07/19
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
6,838 reads
Review of SQL Server 2000 Performance Tuning
This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!
Read more...
By
Andy Warren
2002/05/03
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
8,248 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 published: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
33,837 reads
Reducing Round Trips - Part 3
This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.
Read more...
By
Andy Warren
2002/03/11
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
7,869 reads
Items 1 to 20 of 25
Older >>
Tags
sql server 7
(19)
t-sql
(13)
programming
(10)
administration
(7)
configuring
(6)
indexing
(4)
strategies
(4)
ado
(3)
monitoring
(3)
stored procedures
(3)
visual basic 6
(3)
xml
(3)
backup and restore
(2)
basics
(2)
distributed queries
(2)
openxml
(2)
replication
(2)
security
(2)
analysis services (ssas)
(1)
asp
(1)
data warehousing
(1)
database design
(1)
dts
(1)
english query
(1)
installation
(1)
olap server
(1)
sql puzzles
(1)
triggers
(1)
updategrams
(1)
user defined function (udf)
(1)
xsl
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.