Tag Archives: sql server

SQL DBA INTERVIEW QUESTIONS WITH ANSWERS – 1

Posted on November 7, 2014 by uday arumilli

SQL DBA Interview Questions with Answers – 1 SQL DBA Interview Questions with Answers Q. What are the common issues a SQL DBA should deal with as a part of DBA daily job? Ans: Backup Failure Restore Failure Log Full Issues … Continue reading →

Posted in Interview Q&A, SQL Server DBA | Tagged , , , , , , , | 48 Comments

Deploying SSIS package using Deployment Manifest with screenshots

Posted on July 25, 2013 by uday arumilli

The post Deploying SSIS package using Deployment Manifest with screenshots can help you to deploy SSIS package using deployment manifest. To demonstrate this I have created a simple ETL package to load data from a Flat file to SQL Server … Continue reading →

Posted in MSBI, SQL Server DBA, SSIS | Tagged , , , , , , , , , | 11 Comments

SP_SPACEUSED is giving wrong counts

Posted on July 12, 2013 by uday arumilli

SP_SPACEUSED is giving wrong counts !!! SP_SPACEUSED: is a system stored procedure and used to capture number of rows, total size, data and index size information. Sometimes SP_SPACEUSED may give incorrect information or SP_SPACEUSED  give wrong counts. Below are some … Continue reading →

Posted in SQL Development | Tagged , , , , , , , , | 1 Comment