(c) 1999-2011 EMS Database Management Solutions, Inc. All rights reserved.http://www.sqlmanager.net/ru/articles/mssqlSQL Server Articlesru1440http://www.sqlmanager.net/ru/articles/mssql/1736http://www.sqlmanager.net/ru/articles/mssql/1736The article discusses the methods of measuring and identifying I/O related performance information for your SQL Server database instances.http://www.sqlmanager.net/ru/articles/mssql/1681http://www.sqlmanager.net/ru/articles/mssql/1681Validating foreign keys requires additional work for data modification operations and can lead to deadlocks in certain scenarios. There are, however, ways you can work around this contention and eliminate the possibility of the deadlocks.http://www.sqlmanager.net/ru/articles/mssql/1601http://www.sqlmanager.net/ru/articles/mssql/1601MERGE is a new statement introduced in the SQL:2003 standard for performing multiple DML (Data Manipulation Language) statements against a target table at once. In this article we’ll look into ways to take advantage of this powerful addition to SQL.http://www.sqlmanager.net/ru/articles/mssql/1548http://www.sqlmanager.net/ru/articles/mssql/1548The article discusses the replication with different versions of SQL Server.http://www.sqlmanager.net/ru/articles/mssql/1533http://www.sqlmanager.net/ru/articles/mssql/1533Read the following article for an overview of the benefits, new features and improvements to expect with SQL Server 2008 R2.http://www.sqlmanager.net/ru/articles/mssql/1527http://www.sqlmanager.net/ru/articles/mssql/1527This article discusses the use of various techniques to reduce the negative impact of the data locking issues.http://www.sqlmanager.net/ru/articles/mssql/1518http://www.sqlmanager.net/ru/articles/mssql/1518Don’t create too many files in your database in an effort to improve performancehttp://www.sqlmanager.net/ru/articles/mssql/1500http://www.sqlmanager.net/ru/articles/mssql/1500SQL Server 2008 Express provides developers with high-end database features that enables developers to create powerful databases for Windows and the Web.http://www.sqlmanager.net/ru/articles/mssql/1407http://www.sqlmanager.net/ru/articles/mssql/1407My boss, Mauricio, has been on me for months asking me to list the top 10 features of SQL Server 2008. I have been stalling. I think every single feature in the product is compelling, and inevitably I am going to leave something out and will hear about ithttp://www.sqlmanager.net/ru/articles/mssql/1389http://www.sqlmanager.net/ru/articles/mssql/1389Once again, Microsoft has released a new version of SQL Server that promises to improve life for database administrators. The latest version is SQL Server 2008, and it offers a large variety of new features and functionality that will make the administrathttp://www.sqlmanager.net/ru/articles/mssql/655http://www.sqlmanager.net/ru/articles/mssql/655http://www.sqlmanager.net/ru/articles/mssql/589http://www.sqlmanager.net/ru/articles/mssql/589There are plenty of good sources of information about how to deploy SQL Server in a secure fashion.