Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement SELECT * FROM MASTER..SYSPROCESSES WHERE BLOCKED != 0 Yes, I’ve found the culprit SPID that is occupying more reso...

Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a particular record. In Sql Serve...

'SQL Server Citation is a SQL Server blog by Hemantgiri S. Goswami, Surat,India. He is a SQL Server Specialist and SQL Server MVP,Author, President and Leader of Surat User Group...

This blog contains various articles on the SQL Server. Also this blog contains various interview questions on the SQL Server. Through this blog I try to make the learning of SQL Server/ BI and SQL DBA very easy and in a quick time....

Over the last couple of months I have on several occasions found myself in need of test data for demos, blogposts etc. You all know AdventureWorks, which will work for a lot of demoing stuff. But the amount of data is limited, and if you are demoing stu...

I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status. The descriptions, courtesy of BOL are: ONLINE - Database is available for ...

A table that does not have a clustered index is referred to as a Heap.  While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table. To identify whether your heap table...

Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component in the system. Database servers are particularly sensitive to disk IO speeds. For example, introducing an SVC system may speed up writes, but wil...

One common misconception about web security is that protecting important actions with CAPTCHAs can prevent XSS attacks from doing real damage.  By preventing malicious code from scripting critical tasks, the idea goes, XSS injections won’t be ...

The Environment Variable DB2_RR_TO_RS enables\disables the Repeatable Read attribute. I's enabled for DB2 performance purposes DB2 registry parameter DB2_RR_TO_RS is used to: Set a default isolation level for user tables to Read Stability (RS) iso...