Last week, I encouraged you to identify and address the root causes of performance problems instead of addressing superficial symptoms. I used this question, found on the SQL Server newsgroups, to set the stage for advice on targeting problems...
SQL Server Magazine UPDATE—brought to you by SQL Server Magazine and SQL Server Magazine Connections...
I recently ran across the following question on the Microsoft SQL Server newsgroup: "Which should give better SQL Server performance: a server with a single-processor 1.6GHz Pentium 4 processor with 1GB of RAM or a server with dual 700MHz Pentium...
Microsoft announced that the beta version of Microsoft Office Visio 2003 will be available later this year. Visio 2003 features improved diagramming functions and libraries of shapes. Microsoft has also integrated Visio with XML to let the product...
Planning an upgrade? Don't start out in a hole by implementing an aging OS
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...
SQL Server Magazine UPDATE—brought to you by SQL Server Magazine and SQL Server Magazine Connections...
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)...