SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Zora's SQL Tips

Hi! I am Zora Stalin, an IT geek and a passionate learner of technology. Besides my job as an Information Technology Analyst, I love searching and sharing new things that excite me help for others.

Archives: October 2014

Introduction To SQL Server Joins with Example

In SQL Server database, if records of two or more tables have to be combined, then the Join clause is used. It is a means that combine same fields of the tables can be combined using their common values. There are five types of join clause available for ANSI standard…

Read more

0 comments, 1,787 reads

Posted in Zora's SQL Tips on 29 October 2014

An Introduction To SQL Server Data Mining Algorithms

What is Data Mining in General?

Data mining helps organizations having large sized database to explore their data in a simple and interactive way. It used to find patterns of the data and performs predictions on the process like a transaction on the server will succeed or not. It provides…

Read more

0 comments, 2,218 reads

Posted in Zora's SQL Tips on 15 October 2014

Introduction of Triggers in SQL Server

Triggers are the database objects that are used in relational databases. These are executed or fired automatically, when DDL or DML command statement is executed related to trigger. Triggers are used to assess or evaluate data, preserve data integrity, control server operations, used to implement business logic/rules, or to audit…

Read more

0 comments, 25,295 reads

Posted in Zora's SQL Tips on 10 October 2014

Brief Introduction of Deadlock Occurrence in SQL Server

A deadlock is defined as the situation where two or more processes permanently block each other by acquiring the lock on a resource that has already been requested by another process. This means one process is trying to lock the resource while the other one has already locked it. The…

Read more

0 comments, 1,495 reads

Posted in Zora's SQL Tips on 7 October 2014