Being a .Net developer, the most useful feature i found was the Error Handling or Exception Handling technique.When it comes to programming languages , all popular OOP languages have TRY()…Catch() method to handle an exception. In Sql Server 2005...
Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. It helps us to split the larger tables and data in to smaller parts. In a few word this means that you can...
Hi this is first post for INDEXES in SQL Server. In this we learn about indexes , how SQL use indexes and all. If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes...