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: November 2014

SQL Server - Clustered Indexes and Non Clustered Indexes

To understand the concept of Clustered and Non Clustered indexes, it is important to understand the definition and functionalities of indexes first. An Index is a structure related to a view or table that speeds up the processes by quick retrieval of integrated rows from view or table.

There are…

Read more

1 comments, 1,427 reads

Posted in Zora's SQL Tips on 28 November 2014

SQL Server Disaster Recovery Planning

While administrating SQL Server database, one of the important part is to prepare a plan to work against potential disasters. A tried-and-tested design for backup and restore plays a major role in recovering database post disaster. However, some additional measures are to taken to ensure that system and database are…

Read more

0 comments, 7,119 reads

Posted in Zora's SQL Tips on 16 November 2014

Introduction to SQL Server Functions With Example

SQL Server have functions which can be defined simply as database object or set of SQL statements which accept only input parameters, perform actions like calculations, and return value as a result. This result can be a single value and is scalar. Functions cannot be used to Update, Delete or…

Read more

0 comments, 9,372 reads

Posted in Zora's SQL Tips on 12 November 2014