Changing SQL Server Agent Jobs Ownership: Who should own SQL Server Agent Jobs

I writing this blog post as a result of the following two questions, which I’ve been asked by one of...

Availability databases in unhealthy data synchronization state (Error: 35285, Severity: 16, State: 1.)

After power surge last night, I realized few availability databases (also known as a “database replica”) have an unhealthy data...

Verify a success of database backups

One of the most important tasks on a DBA’s to-do list is backing up databases on a regular basis. This...

Tables without Clustered Indexes?

Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...

Different approaches of counting number of rows in a table

Today, I received an email from the developer asking if there is a better way instead of the COUNT (*) Transact-SQL...

Rebuild all indexes on all tables in the SQL Server database

One of the key tasks of a DBA is to maintain the database indexes and make sure they are not...

Removing part of string before and after specific character using Transact-SQL string functions

Problem
Today, one of the developers come to me and asked me the question that is there any T-SQL function that...

Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution

You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...

Transact-SQL query to obtain basic information about partitioned tables

Here is the simple query that returns basic information about all tables in a database that are partitioned:

SELECT SCHEMA_NAME([schema_id]) AS...

Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance

We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables....