Advertisements
  • Article Topics

  • Become a member of the SQLDBASupport community and receive notifications of new posts by email

    Join 82 other followers

  • Are you writer? Become an Author! Mail to

    amitvaid81 @ gmail dot com

  • Founder

    This is journey of a SQL DBA. I now work as a Sr. Database Architect and Solution Consultant, generally in performance tuning, clustering or high availability. The opinions expressed herein are my own personal opinions through real time experience.


    Amit Vaid

SQL Query – Find size for all tables in a Database

We have system procedure to get size information. Continue reading

Advertisements

SQL Query – Find a Column from all the Tables

Here is the query to find a particular column in all the tables for given database.
Continue reading

Single query to grant Read/Write/View permissions to all stored procs

–For SQL Server 2005 and above Continue reading

SQL Databases Last Backup Data and Time with Recovery Mode

Many times DBAs find difficulty to find out when did Last full backup or Transaction log backup completed on SQL Instance and If the SQL Instance has number of database its even more difficult to find out through SQL Enterprise Manager or Management Studio.
Continue reading

How to fix Orphaned Users in database

FIX : Error 15023: User already exists in current database

Introduction
Orphan user is a user in a SQL Server database that is not associated with a SQL Server login..

Continue reading

SP_recompile

SP_recompile needs a single parameter which is the table name after it.

ie: sp_recompile table_name Continue reading

Routine SELECT Queries

The below query to get result for SQL server Installation information Continue reading