Tag: sql server

Community

Storing Computations

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

Community

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

Community

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.