Understanding SQL Server Query Optimization – Part 3

A critical part of database design and management is index design. Index design involves balancing space requirements and the resource...

Understanding Triggers

A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...

Back to basics: Transact-SQL programming fundamentals – (Part 1)

SQL Server users use Transact-SQL programming to create sets of statements for ad-hoc execution. The aim of the Transact-SQL programming...

Back to basics: Transact-SQL programming fundamentals – (Part 2)

In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL...

Secrets of successful projects…:)

Guide to SQL Server Table Indexes – (Part 4)

Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...

Manage your SQL Server databases with SQL DMVs

Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment....

Planning for Recovery

A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...

Understanding SQL Query Optimization – (Part 1)

Most of the activity of the database server is related to queries. Because of this, query optimization is often a...

Understanding SQL Server Full-text Indexing – (Part 1)

SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....