【IT168 专稿】在数据库服务器上，有三种硬件资源一直是影响数据库性能好坏的关键，甚至会影响到整个生产系统的使用，这三种资源分别是内存、CPU和物理IO。当数据库服务器上挂载了多个数据库的时候，极有可能发生资源的争夺，如何能保证重要数据库在 ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

Read on for more detail on SQL Server Management Studio and management improvements, Resource Governor, Change Data Capture and nonlogged inserts, Data Compression, Backup Compression, index ...

SQL Server 2008建立在之前SQL Server 版本的行业领先的性能之上，给你的公司提供了最高级的标准数据库性能。 使用事务处理性能委员会的TPC-C基准示范了SQL Server 的高性能，Microsoft是第一个发布更新的TCP-E基准结果的数据库销售商，这更精确地表现了现在公司里普遍存在的OLTP工作负载的种类。

I have been testing SQL Server 2008 and I must admit, I’ve been impressed with the new features. I’ve written about some of the new functionality in past blog entries. One feature that I had not ...

When I meet SQL Server professionals, I am always interested to find out if they have deployed the latest version of SQL Server into production yet, if they are using Enterprise Edition, and, if so, ...

SQL Server 2008 has been significantly enhanced since the previously released versions. Moreover, the product continues to support Microsoft’s data platform vision of mission-critical enterprise data ...

If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario, you have several applications, each with their own ...