Category Archives: SQL Development

How to use CASE in Where Condition

Posted on March 23, 2011 by uday arumilli

How to use CASE in Where Condition We had a situation in which we had to use case in where condition. This post helps in understanding “How to use CASE in Where Condition”. Lets consider a situation where we need … Continue reading →

Posted in SQL Development, SQL Scripts | Tagged , , , | Leave a comment

How SQL Server Page Allocations Works

Posted on March 11, 2011 by uday arumilli

How SQL Server Page Allocations Works? This post helps us in understanding “How SQL Server Page Allocations Works”. When I drop an object SQL Server does not immediately re-use those extents for a new object. This is because the storage … Continue reading →

Posted in SQL Development, SQL Server DBA | Tagged , , , , | Leave a comment

Ctrl N short cut is not working in SQL 2008

Posted on February 23, 2011 by uday arumilli

Ctrl N short cut is not working in SQL 2008 SQL Server 2008 got released and there are lot of new features that takes SQL Server to the next level for sure. This post helps sql server developers in solving … Continue reading →

Posted in SQL Development | Tagged , , , , | Leave a comment