Data Analytics and Data Management

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

We want to use SQL Mail over the Internet. What problems might we...

NULL meansnull value; it's not the same as zero or blank. NULL means that the users made no entry and often implies missing...

My server has 1.5GB of physical memory, and I've assigned 1.3GB (650,000 2KB pages in sp_configure memory) to SQL Server. I've allocated 100MB of RAM to tempdb. Does that 100MB come from the memory I've already allocated to SQL Server...