After more than a year's delay, Intel recently released its Itanium chip to OEMs such as Dell, Hewlett-Packard (HP), and IBM, making 64-bit Wintel systems a reality. To coincide with the initial Itanium release, Microsoft in the third quarter is...
SQL Server offers several options for recovering just part of your database
The recovery model, a new option in SQL Server 2000, determines what level you'll be able to recover your database and recently entered data to in the event of a system failure. To set a recovery model, right-click the database in Enterprise...
I selected an identity field as a primary key in a SQL Server table. When I delete the last record, then enter a new record, SQL Server creates a new number. However, when I insert a new record, I want SQL Server to check the maximum number in the...
As I understand it, SQL Server 2000's Open Data Service (ODS) is compatible with Tabular Data Stream (TDS) 8.0, TDS 7.0, and TDS 4.2 running on client machines; SQL Server 7.0's ODS is compatible with TDS 7.0 and TDS 4.2; and earlier SQL Server...
7 products vie to give your enterprise that nice, cozy feeling of protection
When I use a script to drop a database and reload the database with updated data, I often get an error message saying that the database is in use. I'm the only user. If I stop and restart the MSSQLServer service, the script works fine. I don't...
The size of my tempdb database is steadily increasing. How can I control its growth...