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.
2017-08-18 (first published: 2002-04-09)
69,737 reads
Performance Tuning
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.
2002-03-14
11,518 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.
2002-03-11
8,039 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.
2002-03-07
13,114 reads
Performance Comparison: Data Access Techniques
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
2002-03-01
2,857 reads
Optimizing Stored Procedures To Avoid Recompiles
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.
2002-02-26
24,998 reads
SQL Server 2000 Performance Tuning
A series of web presenatations from Microsoft about tuning SQL Server 2000.
2002-02-15
1,362 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.
2002-02-12
14,849 reads
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
2002-02-08
207 reads
Reducing Round Trips - Part 2
Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!
2002-02-06
9,370 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers