Archives: August 2013
Scalability is the ability of a system to support an increased workload by adding incremental system resources without fundamentally changing the system design or architecture. We must distinguish the scalability from reliability, because reliability is the ability of a system to manage the workload without experiencing failures or stopping altogether. Read more
Creating SQL Server upgrade paths from one version to another is a task that every database administrator is eager to undertake. However, upgrading SQL Server is not an easy task, and improper planning increases the chance of derailment and delays.
Checkout the part-3 of my five part article series on Guide to SQL Server Table Indexes here, in which you will learn about remaining index types available in SQL Server, and what are these indexes advantages and dis-advantages.
This article is published on SQL-SERVER-PERFORMANCE.COM.
Checkout the part-2 of my five part article series on Guide to SQL Server Table Indexes here, in which you will learn about the different types of indexes available in SQL Server, and what are some of these indexes advantages and dis-advantages.
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables. Full-text search is applicable in wide-range of business scenarios. You use full-text search to create queries that search for a word or phrase in a column. You can use full-text… Read more
Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases. Normalization refers to a process used to design relational database tables. Its objectives include minimizing the duplication of information within OLTP databases, as well as reducing the overall size of… Read more