SQL Server 2000 Enterprise Edition clocked an incredible 308,620 transactions per minute (tpmC)1 running on Windows .NET Server 2003, Datacenter Edition on an NEC TX7 server with 32 Intel Itanium 2 processors. The NEC system sets a new performance record on Windows, nearly doubling the best published 32-bit result. In addition, this Microsoft/Intel/NEC solution delivers the best price-performance of all results on the Top Ten performance list, at just $14.96/tpmC.

NGSSQuirreL Released.

by Additional Articles

Other

Security

NGSSoftware have released NGSSQuirreL, a security audit and management tool for SQL Server. Designed to ease the administrative burden of securing SQL Server, NGSSQuirreL finds the security holes then generates a lockdown script based upon the vulnerabilities found so the server can be secured in a matter of minutes; and regular audits can help keep it that way. For more information or an evaluation copy please see the NGSSite - http://www.nextgenss.com/.

Performance Adding Hints

by Robert Marda

SQLServerCentral.com

Performance Tuning

During the process of performance tuning queries and stored procedures there comes a time when you will notice that the execution plan selected by SQL Server is not the best plan. On occasion, everything you try doesnt cause SQL Server to choose the best way to execute your code. These are the times when hints can improve performance.

The Dot Com Bust - Part 2

by Steve Jones

SQLServerCentral.com

State of the Business

It's been a year since Steve Jones last wrote about the state of the DBA job market after the economy soured. Here's an update of the last year.

Threat Profiling SQL Server

by Additional Articles

Other

Security

An interesting research paper by David Litchfield on how an attacker might go about attacking your server. Definitely worth a read.

Using Bitwise Operators to Boost Performance

by Herve Roggero

SQLServerCentral.com

Performance Tuning

Bitwise operators can be challenging to manage at first. However, with practice and patience, and under the right conditions, these operators can provide remarkable performance improvements in production environments. This article will compare two methods of accomplishing the same output, one with a normalized model and the other with bitwise operators.

What's best for DBAs? GUI or T-SQL commands?

by Additional Articles

Vasyn MVP site

Administration

This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQL scripting expert!

ANSI Options Part 4 - ANSI_WARNINGS

by Steve Jones

SQLServerCentral.com

Administration

Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.

SQL-DMO - Using the '2' Objects

by Andy Warren

SQLServerCentral.com

SQL-DMO

In this short article Andy talks about the differences in DMO between SQL7 and SQL2K, why it matters, and when you should use the newer version of DMO that comes with SQL2K.

Book Review: SQL Server 2000 Resource Kit

by Andy Warren

SQLServerCentral.com

Book Reviews

This 1100 page book offers something for everyone. Using Blobs, Analysis Services, Replication, High Availability. 38 Chapters plus ebook and tools on the CD. Should you get it? Read our review of this book to find out!

Microsoft Platform Vaults into New Performance Territory

NGSSQuirreL Released.

Performance Adding Hints

The Dot Com Bust - Part 2

Threat Profiling SQL Server

Using Bitwise Operators to Boost Performance

What's best for DBAs? GUI or T-SQL commands?

ANSI Options Part 4 - ANSI_WARNINGS

SQL-DMO - Using the '2' Objects

Book Review: SQL Server 2000 Resource Kit

Blogs

2024 PASS Data Community Summit Prep

A New Word: Bye-over

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

Forums

Temporary Table Problem

A Few Good DBAs

Python with SQL 2022 Enterprise doesn’t work

Question of the Day

Incremental Statistics