<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
Content with tags
Basic Querying
,
Performance Tuning
Refine your search with one of the following additional tags (with number of items):
T-SQL
(10)
Backup and Recovery
(1)
Installation
(1)
Strategies
(1)
Performance Tuning and Scaling
(3)
Configuring
(1)
Monitoring
(1)
Triggers
(1)
SQL Server 7, 2000
(3)
Distributed Queries
(1)
OpenXML
(1)
UpdateGrams
(1)
Stored Procedures
(3)
DTS
(1)
Programming
(1)
User-Defined functions
(1)
Miscellaneous
(2)
English Query
(1)
Replication
(1)
XML
(1)
Security
(2)
Indexing
(1)
SQL Puzzles
(1)
XSL
(1)
Administering
(1)
Items 1 to 10 of 10
Is a Temporary Table Really Necessary?
In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.
Read more...
By
Randy Dyess
2008/05/30 (first posted: 2002/04/09)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
38,506 reads
Is a Temporary Table Really Necessary?
In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.
Read more...
By
Randy Dyess
2008/05/30 (first posted: 2002/04/09)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
38,506 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 posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
40,993 reads
Uses For Derived Tables
In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.
Read more...
By
Robert Marda
2004/02/06
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
14,983 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 posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
40,993 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
|
16,988 reads
What is the search order for Procedures prefixed sp_?
In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?
Read more...
By
James Travis
2002/11/14
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
6,015 reads
Advice on using COUNT( )
In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).
Read more...
By
Christoffer Hedgate
2002/09/23
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
11,003 reads
Is a Temporary Table Really Necessary?
In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.
Read more...
By
Randy Dyess
2008/05/30 (first posted: 2002/04/09)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
38,506 reads
How Dynamic SQL Can Be Static SQL
This article demonstrates the flexibility of static SQL when using the CASE function in a WHERE clause, SELECT clause, ORDER BY clause, GROUP BY clause, HAVING clause, and JOIN. This is done with five examples and includes sample code you can execute on your SQL Server.
Read more...
By
Robert Marda
2002/03/14
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
9,177 reads
Dynamic SQL vs. Static SQL Part 2, Code
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
Read more...
By
Robert Marda
2002/03/07
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
10,639 reads
When to Use Dynamic SQL
Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.
Read more...
By
Robert Marda
2002/02/12
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
12,015 reads
Tip: Testing for the Existence of Data
There are times when we need to know that rows of data that meet specific criteria exist in a table. There are 2 basic ways to find this information: COUNT() and EXISTS(). Here are some examples.
Read more...
By
Jason Rein
2001/12/20
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
4,398 reads
Items 1 to 10 of 10
Most popular
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 posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
40,993 reads
Is a Temporary Table Really Necessary?
In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.
Read more...
By
Randy Dyess
2008/05/30 (first posted: 2002/04/09)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
38,506 reads
Advice on using COUNT( )
In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).
Read more...
By
Christoffer Hedgate
2002/09/23
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
11,003 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
