SQL Query Optimization FAQ Part 1 (The SQL Plan) This tutorial will explain what is SQL Plan and also As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan etc. As we understand the logic of these operator
Posted : Feb/03/2010 By:
pankaj Category:
SQL Server Total Views :
79 Vote Up:
0 Vote Down:
0 Triggers Tutorial When an action has been performed on a table, such as adding a new record, changing (editing/updating) an existing record, or deleting a (or some) records, the table produces a notification. We say that the table fires an
Posted : Oct/07/2009 By:
pankaj Category:
SQL Server Total Views :
64 Vote Up:
0 Vote Down:
0 Logical Conjunctions and Disjunctions So far, we have stated the conditions one at a time. This made their interpretation easier. Sometimes, you will need to test a condition that depends on another. Boolean algebra allows you to combine two conditions and us
Posted : Oct/07/2009 By:
pankaj Category:
SQL Server Total Views :
61 Vote Up:
0 Vote Down:
0 Data Import/Export One of the techniques used to get data into one or more tables consists of importing already existing data from another database or from any other recognizable data file. Microsoft SQL Server provides various techniques a
Posted : Oct/07/2009 By:
pankaj Category:
SQL Server Total Views :
55 Vote Up:
0 Vote Down:
0 SQL Server - Views Tutorial In SQL Server, a view is a pre-written query that is stored on the database. A view consists of a SELECT statement, and when you run the view, you see the results of it like you would when opening a table. Some people lik
Posted : Oct/07/2009 By:
pankaj Category:
SQL Server Total Views :
68 Vote Up:
0 Vote Down:
0