Author Archives: uday arumilli

Dynamic Management Views in Sql Server

Dynamic Management Views in Sql Server Introduction: The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what’s going on inside SQL Server. They can provide information on what’s currently happening inside the … Continue reading

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

SQL Server files and File Groups

SQL Server files and File Groups This is to understand SQL Server files and File Groups. It’s ironic that the Relational Database Management System (RDBMS) was invented to implement data structures in something other than files. The irony is that … Continue reading

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

SQL Server Isolation Levels and Locks

SQL Server Isolation Levels and Locks We will learn about SQL Server Isolation Levels and Locks. Isolation levels come into play when you need to isolate a resource for a transaction and protect that resource from other transactions. The protection … Continue reading

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