Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
We database professionals constantly strive to get every last ounce of performance improvement out of our systems. We bend over backwards to make our systems run faster and better. But while we're worrying about tweaks, we sometimes forget about...
According to a new report from research firm Gartner, the database market experienced a decline in sales in 2002, but Microsoft SQL Server experienced a substantial increase in sales and market share. In 2002, economic troubles hit the database...
Microsoft released several new articles that provide product fixes and information for SQL Server customers. Two of the fixes specifically address problems that DBAs might encounter when they install SQL Server 2000 Service Pack 3 (SP3)...
The race for supremacy in the Transaction Processing Performance Council's (TPC's) TPC-C benchmark continued as Microsoft and Hewlett-Packard (HP) posted new results yesterday in the nonclustered TPC-C category. The race has heated up in recent...
How can I track how frequently my applications use indexes on a particular table and find out which applications are using the indexes?
Tracking index usage helps you determine which indexes you need to keep, but you can't get this information...
Query Analyzer is packed with features that many people haven't experimented with. Here's an obscure capability that I didn't know existed until recently. Query Analyzer lets you set a wide variety of configuration options. However, I didn't know...