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

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 (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

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

by Brad M. McGehee – David Gugick provides over 100 tips on how to boost SQL Server performance.

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:

In making a hasty recovery after a SQL Server data loss, staffers may have overwritten critical evidence.

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

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.

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