2001-07-16
6,508 reads
Performance Tuning
Taming the Stateless Beast: Managing Session State
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
Optimizing SQL Server Performance Using Files and Filegroups
Learn how to boost the performance of SQL Server by making proper use of filegroups.
2001-06-26
1,774 reads
2001-06-26
2,821 reads
Job to Monitor SQL Server 7.0 Performance and Activity
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads
Using Index Intersections
First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance.
2001-06-12
5,435 reads
Using SET to Tune Your Queries
On the surface, the goal of performance tuning a query seems simple enough. Essentially, we want our queries to run faster. This article looks at how the STATISTICS IO and STATISTICS TIME options can help us tune queries.
2001-06-12
2,431 reads
Speed Tips For Select Statements
This article by Neil Boyle examines techniques for speeding up your queries by writing better T-SQL.
2001-06-07
13,616 reads
Microsoft SQL Server 2000 Reliability
Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.
2001-06-05
1,660 reads
Speedy Database Recovery with Differential Backups
Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.
2001-06-05
7,652 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers