This article will explain about Triggers, Instead of triggers, after triggers, inserted and deleted tables.For more articles and videos visit us on http://www.questpond.com
SQL Server Interview question: - Column store indexes.
- By Shiv Prasad Koirala
- 2012-08-18
- 15914
- 0
In this article we will try to answer some important SQL Server interview question's around the most discussed feature "Column store indexes" from SQL Server 2012 interview perspective. For more articles and videos visit us on http://www.questpond.com/
In this article we will explain about page, extents, page header and row offset in SQL Server. For more articles and videos visit us on http://www.questpond.com/
In this article we will show differences between star schema and snow flake design. For more articles and videos visit us on http://questpond.com/
In this article we will explain about Sub-Queries and co-related queries. For more articles and videos visit us on http://www.questpond.com/
11 Important Database designing rules which I follow.
- By Shiv Prasad Koirala
- 2012-04-05
- 12699
- 0
In this article we will explain 11 important database designing rules. For more articles and videos visit us on www.questpond.com
SQL Server interview question:- Show SSIS, SSAS and SSRS?
- By Shiv Prasad Koirala
- 2012-02-20
- 8207
- 0
In this aricle we will explain about SSIS, SSAS and SSRS.For more articles and videos visit us on http://www.questpond.com/
In this article we will explain about essential components of SQL Server Service broker. For more articles and videos visit us on http://www.questpond.com/
In this article we will explain about Architecture of Notification Service. For more articles and videos visit us on http://www.questpond.com/
In this article we will explain stateless and stateful load balancing in SQL Server. For more articles and videos visit us on http://www.questpond.com/
SQL Server interview questions: - What is Fragmentation?
- By Shiv Prasad Koirala
- 2012-01-25
- 5762
- 0
In this article we will explain about Fragmantation in SQL Server. For articles and videos visit us on http://www.questpond.com/
In this article we will explain about Clustered index and Non-Clustered Index. For more articles and videos visit us on www.questpond.com
In this article we will explain publisher, distributor and subscriber in "Replication". For more articles and videos visit us on www.questpond.com
In this aricle we will explain different types of relationship existing in database designing.For more articles and videos visit us on www.questpond.com
This SQL Server interview questions is more of practical oriented. Below is the code to connect SQL Server, then we will try to understand the same in a more detailed manner.
