Blocking means that one query (Query1) is locking resources that another query (Query2) is waiting to use. Blocking can seriously affect response time and throughput. Response time measures how long it takes for a user who issues a query to get a...
New features extend SQL Server's performance & scalability...
To deploy or not to deploy — that's the question foremost in
the minds of IS planners as they begin to evaluate the second beta of Windows NT 5.0. When is it safe to migrate? How do you weigh the risks associated with a major new operating system...
SQL Server database administrators can now turn to several new resources. Check out the Web site (http://www.sqlmag.com) for Windows NT Magazine's forthcoming sister publication SQL Server Magazine. Also, in June Microsoft posted updated Intel and...
ProsSQL Server 7.0 is feature packed. Let's look at some of the most significant features you can expect to see in this latest release...
SQL Server 6.5 manages table space using 16KB extents. Because...
It was bound to happen: Lotus decided that the free lunch is over for users...