Alexander Chigrik

Here are sixteen useful tips that you can use to ensure your SQL Server 6.5 databases are performing in the most efficient manner possible. 1. Set a reasonable size for your database. Because SQL Server 6.5 database cannot automatically grow, you should estimate how big the database will be. To derive a reasonable estimate for […]

Here are thirteen little known tips that you can use to optimize your Windows servers to perform in the most efficient manner possible. 1. Set a reasonable size for your PAGEFILE.SYS file(s). Microsoft recommends that the Windows NT PAGEFILE.SYS file(s) be set to physical RAM + 12 MB for the initial size and physical RAM […]

General Concepts Declaring a Cursor SQL-92 Syntax Transact-SQL Extended Syntax Opening a Cursor Fetching a Cursor Closing a Cursor Deallocating a Cursor Cursor Optimization Tips Literature General concepts In this article, I want to tell you how to create and use server side cursors and how you can optimize a cursor performance. Cursor is a […]

Here are fourteen little known tips that you can use to ensure your SQL Server 2000 databases are performing in the most efficient manner possible. 1. For very large databases, use distributed partitioned views to partition tables horizontally across multiple servers. This is a new SQL Server 2000 feature, which is available when using SQL […]

Here are seven little known tips that you can use to ensure your databases are performing in the most efficient manner possible. 1. Turn off the ‘auto create statistics’ database option. When this database option is set to true, statistics are automatically created on columns used in a predicate. By default, this database option is […]

Here are nine “secret” tips that you can use to ensure your SQL Server environment is performing in the most efficient manner possible. 1. If your SQL Server has a lot of memory available and there are many queries running concurrently on the server, you can increase the ‘min memory per query’ option to improve […]

General concepts Restrictions Example Literature General concepts Microsoft SQL Server 7.0/2000 allows you to validate data for merge replication. You can specify rowcount only validation or rowcount and checksum validation of the article’s data. When you choose rowcount only validation, then SQL Server calculates a rowcount at the publisher level, then compares the result to […]

Introduction General concepts Replication topologies Replication types Replication agents Checking necessary conditions Step by step example Backup and restore strategies Literature   Introduction In this article, I want to tell you about some general Microsoft SQL Server replication’s topics: replication topologies, replication types, and replication agents. I will also discuss Merge replication: how to check […]

Introduction General concepts Replication topologies Replication types Replication agents Checking necessary conditions Step by step example Backup and restore strategies Literature   Introduction In this article, I want to tell you about some general Microsoft SQL Server replication topics: replication topologies, replication types, and replication agents. I will also discuss Snapshot replication: how to check […]

Introduction Undocumented system tables syscursorcolumns syscursorrefs syscursors syscursortables sysfiles1 sysfulltextnotify syslocks sysproperties sysxlogins Introduction In this article, I want to tell you about undocumented system tables shipped with SQL Server 2000. These tables are used by some system stored procedures and stored in the master database (only sysfiles1, sysproperties and sysfulltextnotify system tables are stored […]

Introduction Undocumented system tables syscursorcolumns syscursorrefs syscursors syscursortables sysfiles1 sysxlogins Introduction In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only sysfiles1 system table is stored in each database). Undocumented system tables […]

General concepts Optimization tips Literature   General concepts There are no devices and segments in SQL Server 7.0 and SQL Server 2000, as in SQL Server 6.5. Now databases reside on operating-system files. There are three types of such files: primary secondary log Each database consists of at least two files: one is a primary […]