Theme:
Article List

Filter by category:     Articles per page:

Rating: 2 user(s) have rated this article Average rating: 5.0
Posted by: ShivPrasad Koirala, on 9/6/2010, in category "MSSQL Server"
Views: this article has been read 139894 times
Abstract: In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
Rating: 2 user(s) have rated this article Average rating: 5.0
Posted by: Hari Mohan, on 2/15/2010, in category "MSSQL Server"
Views: this article has been read 38977 times
Abstract: This article highlights several new components and improved features in Microsoft SQL Server 2008 R2.
Rating: 2 user(s) have rated this article Average rating: 5.0
Posted by: Chandra Hundigam, on 1/16/2010, in category "MSSQL Server"
Views: this article has been read 38756 times
Abstract: Article briefs SQL injection chances in database stored procedures.
Rating: 2 user(s) have rated this article Average rating: 5.0
Posted by: Chandra Hundigam, on 9/29/2009, in category "MSSQL Server"
Views: this article has been read 123117 times
Abstract: There are many different approaches to fetch random rows from a table. This article describes different approaches and its pros and cons of usage.
Rating: 8 user(s) have rated this article Average rating: 5.0
Posted by: Hari Mohan, on 9/4/2009, in category "MSSQL Server"
Views: this article has been read 39408 times
Abstract: Deadlock is what occurs when two or more transactions are waiting on each other to release a lock. Neither can move, and so both stall.
Rating: 1 user(s) have rated this article Average rating: 5.0
Posted by: Hari Mohan, on 7/27/2009, in category "MSSQL Server"
Views: this article has been read 123419 times
Abstract: This article introduces new features in MSSQL Server 2008 and highlights the new database development additions.
Rating: 3 user(s) have rated this article Average rating: 5.0
Posted by: Chandra Hundigam, on 7/1/2009, in category "MSSQL Server"
Views: this article has been read 38651 times
Abstract: In MSSQL Server an alias data type is a special kind of data type that is created by users using the exiting base data types.
Rating: 40 user(s) have rated this article Average rating: 5.0
Posted by: Chandra Hundigam, on 6/30/2009, in category "MSSQL Server"
Views: this article has been read 95781 times
Abstract: When lots of unused space gets created by using truncate or drop operation on tables the DBCC SHRINKFILE operation becomes effective.
Translate
Search

 
Top Rated Articles
Popular Articles
Popular Links
Newsletter
Register to the site for free, and subscribe to the newsletter. Every month you will receive new articles and special content not available elsewhere on the site, right into your e-mail box!

Archived Newsletters