Category Archives: Popular

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 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 [...]

50 Database Optimization TIPS

Database Optimization TIPS helps any system to perform work efficiently and quickly. SQL Server Performance tuning is very wide subject and there are a lot of different pieces to troubleshoot a poor performing application. Connectivity / Network Server Hardware Operating System SQL Server Database Query The basic principle of Optimization / Tuning is Profile First [...]

How to Monitor SQL Server Backups ?

In my last post, “10 SQL Server Disaster Recovery Solutions”  I discussed about 10 solutions which were available for SQL Server and discussed about SQL Server Database backup which most basic form of disaster recovery for SQL Server and one that was being practiced in every situation. If SQL Server database backups are too much [...]

10 SQL Server Disaster Recovery Solutions

What is SQL Server Disaster? Disaster is an event that makes continuation of normal functions impossible. In business terms, any incident which result affects business or stops business transactions is a disaster for example Orders can not be placed, think about Amazon where every business transaction is online and customer is unable to place an [...]