By Itzik Ben-Gan – Using expressions in queries is a common practice. But did you know that you can base a column in a query’s resultset on a computation rather than simply using the query to return a base column from a table? If you use the same computation in many queries against the same table, s
Tag: sql server
SQL Server Fast Facts
Got two minutes? SQL Server 2000 can give you over one million transactions. SQL Server 2000 running on Microsoft Windows® 2000 achieved the highest performance ever for the TPC-C benchmark, with 688,220 transactions per minute, type “C” (tpmC) and price/performance of $28.89 per tpmC. SQL Server 20
Some Useful Undocumented SQL Server 6.5 DBCC Commands
by Alexander Chigrik – In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 6.5 for administering and monitoring. DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the p
Microsoft SQL Server 2000 Scalability Project
SQL Server 2000 running on Microsoft Windows® 2000 servers handles the largest mission-critical applications. This white paper is a joint effort by Microsoft and Dell to demonstrate the scalability of SQL Server 2000 and Dell hardware. SQL Server 2000 running on a Dell enterprise eight-way server ca
Using AWE Memory in SQL Server 2000
by Brad M. McGehee – In most SQL Servers, the biggest performance bottleneck is I/O. This makes a lot of sense for two major reasons. First, the purpose of a database is to store data, and data is stored on disk arrays, requiring I/O to retrieve the data from the disk array before it can be put into
Cursor Performance
From SQLTeam – A recent article on 4GuysFromRolla.com had an ASP script to generate the Transact-SQL code for a cursor. I’ve always thought that cursors where slower than set-based SQL but I never knew how much slower. Read on for the results and a couple of suprises thrown in.
SQL Server/Unisys Configuration Tops TPC-C Nonclustered Benchmark
By Kathy Blomstrom – This week, Microsoft and Unisys announced that SQL Server 2000 running on a Unisys ES7000 server set a new world record for the Transaction Processing Performance Council’s (TPC’s) nonclustered, single-server (scale-up) TPC-C benchmark. The test system achieved 141,138.44 transa
Important Notice: PASS 2001 NA Postponed
The organizers of PASS 2001 North America are deeply saddened by the despicable acts of terrorism that took place on September 11, 2001. In light of this extraordinary situation along with the emotional, personal safety and logistical ramifications that are associated with it, PASS feels it is appro
HOSTPORTAL RELEASES ITS LATEST VERSION OF MAIL MACHINE
HostPortal, a global leader in Web-based applications and hosting services, unveils its new version of its newsletter manager, Mail Machine 2.2. Running on a Windows NT or Windows 2000 Server, Mail Machine can be accessed from any major Internet browser from anywhere. This extremely powerful applica
SQL Server Security Best Practices
by Vyas Kondreddi – This article discusses the security model of Microsoft SQL Server 7.0 and 2000, along with security best practices to help you secure your data. Special thanks to my friend Divya Kalra for her valuable input and content review. Security is a major concern for the modern ag