In the Microsoft SQL Server 2000 Resource Kit, I read about a procedure that checks all databases for options that you should avoid using. I understand why I should avoid using options such as offline, DBO-use only, statistics off, truncate log on checkpoint, and so on. However, the inclusion of two
Other News
SQL LiteSpeed 2.6 – SQL Server Backup Just Got Faster
Software Spotlight by Brad M. McGehee – Wouldn’t it be great if there was some way to not only reduce the size of SQL Server backups, but to also speed them up. As a matter of fact, I am not the only person to have this problem. The good people at DBAssociates, in Melbourne, Australia, also had this
How to troubleshoot replication problems
In this article, Alexander Chigrik explains some problems that you can have whenyou set up replication. He also tells you how you can resolve these problems.
What’s in a Condition?
Oracle9i includes support for the SQL92 join syntax. Find out why it’s important to have the choice to make a condition a join condition in this article by Jonathan Gennick, author of Oracle SQL*Plus Pocket Reference, 2nd Edition.
Scripts for hot backup and restore
Robert Hanrahan) This procedure generates two scripts that do a hot backup and restore of the database. It is a full backup of the database datafiles, redolog, init, and control files. You can run this script at database open and it will generate 2 files: (R)
SOAPing Up Web Services
By Don MacVittie – Simple Object Access Protocol takes Web services to the next level by letting applications communicate. Network Computing comes clean on the technology.
OracleInstall
Have you downloaded Oracle trial software from Oracle Corp.’s Web site? Are you having any problems? Do you have any questions? OracleInstall provides installation assistance and technical information for Oracle’s free trial software. This information is available to you from Oracle’s Web sit
Fast way to add a comment header
By Michael Garstin – For a rapid way to add a comment header to your code from Query Analyzer, add a “comments.tql” file to the Query Analyzer Templates sub-directory.
Cross-Join Performance
By Russ Whitney – When you’re analyzing terabytes of data, the performance of your CROSSJOIN() functions can make–or break–your application’s overall performance.
Inside SQL Server 2000
By Kalen Delaney – Inside SQL Server 2000 was published in November 2000. As an update to my 7.0 update of Ron Soukup’s best selling 6.5 version, it is intended to fill in many of the gaps left by the online documentation dealing with how SQL Server actually stores and processes data internally. It