Author Archives: uday arumilli

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

Automating SQL Server instance and Database Inventory preparation

Posted on January 4, 2011 by uday arumilli

Automating SQL Server instance and Database Inventory preparation In our environment we have a requirement for Automating SQL Server instance and Database Inventory preparation. We tried different methods and came-up with the T-SQL scripts that helped us in creating the environment … Continue reading →

Posted in SQL Server DBA | Tagged , , , , | 2 Comments