Monthly Archives: February 2012

250+ SQL Queries Interview Question Answers

SQL Interview Queries Question / Questions Answers This is a never ending topic and there is no limit to questions that all depends on profile and interviewer. I am trying my level best to divide questionnaire based on Experience in Query Writing skills 5+ Years of Experience (Expert) 2-5 Years of Experience (Intermediate) 1-2 Years [...]

Deadlock Analysis – READ Deadlock from SQL ERRORLOG

How to read DEADLOCK Information in SQL Server ERRORLOG ? In our previous posts, we learned how to trace dead lock information in SQL Server Errorlog. Once the this information is logged inside SQL Server Logs, then how can we use that information for deadlock analysis. In case you want to build your test scenario [...]

Example of Deadlock | SQL Server Deadlock Script

IS there a way I can stimulate a deadlock in SQL Server, so that I can use that as an example of deadlock Let’s take an example, where we will result / cause a dead lock to SQL Serve? To stimulate the Deadlock, let’s create two tables which we are going to use as an [...]

How to backup SQL table ?

Backup SQL table, have you ever tried to backup a single SQL table inside a database? Let’s see How to backup SQL table | SQL Table Backup Restore DOES SQL Server supports table level backups ? Backup Types are dependent on SQL Server Recovery Model. Every recovery model lets you back up whole or partial [...]

SQL 2008 Restore Database

STEP by STEP GUIDE for SQL 2008 Restore Database from a FULL BACKUP | Differential backup | Transaction Log Backup and Point in Time Restore For better understanding, let’s assume, we have following backup files, where we have FULL backups , Differential backups and Transaction LOG backups. DAY Date Type Of Backup Sunday 2012-02-12 Full [...]

SQL Server Hardware Requirements

Minimum SQL Server Hardware Requirements SQL Server Operating System CPU Processor Memory RAM Storage HDD SQL Server 2012 Windows Vista SP 2 Windows 7 SP1 Windows Server 2008 SP1 1.0 GHz 512 MB 811 MB SQL Server 2008 R2 Windows Vista SP 2 Windows XP SP2 Windows Server 2003 SP2 1.0 GHz 512 MB 711 [...]

SQL Server Version Compare

SQL Server Version Compare LIST During one of my training session a college graduate asked me a question, Could you please provide me a quick comparison between the SQL Server versions. I answered him that there is no such table as there are some feature which are available to specific editions only. But he insisted [...]