by Rahul Sharma – Microsoft’s SQL Server™ 2000 promises performance, scalability, and speed. Microsoft SQL Server™ 2000: A Guide to Enhancements and New Features shows database administrators and developers how to deliver on these promises. This book illustrates all the significant enhancements and
Tag: sql server
Understanding DBCC SHOWCONTIG
by Dean Thompson – DBCC SHOWCONTIG is a wonderful tool which helps you to understand quite a bit more about your system than is obvious at first glance. And, frankly, the documentation doesn’t use terminology that makes it very obvious either. So, this article will focus on a few of the big ideas
SQL Server 7.0 Service Pack 4
SQL Server 7.0 Service Pack 4 (SP4) addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 since their ship date. Because SQL Server Service Packs are cumulative, SP4 includes all fixes from previously released Service Packs, and can be applied to an or
Oracle 9i ‘twice as Expensive’ To Run as SQL
By Liesbeth Evers and Lisa Kelly – Analysts are divided over a recent comparative database report which claims that Oracle 9i is twice as expensive to run as Microsoft SQL.The Walklett Group report argues that the total cost of ownership (TCO) of running SQL Server 2000 on a Unisys ES7000 bo
An Exclusive Interview with David Gugick, SQL Server Performance Expert and Software Developer
by Brad M. McGehee – David Gugick provides over 100 tips on how to boost SQL Server performance.
Scheduling jobs to run on alternate Saturdays
By Bianca Blount – To accomplish running a job on the first and third Saturday of the month you would create two job schedules.Here are the steps:
Database Wipeout Turns Into Unsolved Mystery
In making a hasty recovery after a SQL Server data loss, staffers may have overwritten critical evidence.
Database future debated
By Paul Krill – SAN JOSE, CALIF. — Whether the future of databases is the traditional, relational and SQL model with XML technologies incorporated into it or a new XML-based model is a matter of debate, according to panelists during a session Tuesday at the Software Development Conference & Expo he
Database not completing restore process, remaining in loading mode
By Bianca Blount – The problem may be all the necessary transaction logs were not restored. When restoring transaction logs, all logs between the last full back up or differential need to be restored in sequential order.
INF: Authentication Methods for Connections to SQL Server in Active Server Pages
SQL Server authentication relies on the internal user list maintained by the SQL Server computer. This list does not include Windows NT users, and is specific to the SQL Server computer. Users are created and configured using the SQL Server Enterprise Manager. To use this authentication method, perf