We are developing an asp.net web application for an internal company website. The web app makes heavy use of an SQL database and I feel that future bottlenecks will come down to SQL performance. In ...

Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and ...

An opportunity to speak with Sabrena McBride, Senior Product Manager for SQL Server, provided a lot of insight into what's new in R2. Some of the highlights: Among other things, SQL Server 2008 R2 is ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...