-->
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.

Solved : Microsoft SQL Server Error 3403

From its powerful internal structure, fast performance, and reliability, SQL server is now widely accessed by several enterprise users. It is used to deal with bulk transaction processing, business programs, and content management. The Microsoft SQL server is chosen for its high level security, scalability, and performance. Sometimes, corruption in… Read more

0 comments, 348 reads

Posted in Zora's SQL Tips on 15 June 2017

Top 5 Features of SysTools SQL LDF Recovery Software - Review

An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for viewing transaction log file of SQL Server 2016, 2014, 2012, 2008 R2 database, and 2005. It is so because I personally had used this application for resolving many problems… Read more

0 comments, 347 reads

Posted in Zora's SQL Tips on 17 May 2017

Know How to Find Outdated Statistics In SQL Server Quickly

Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query. SQL Server is pretty good in estimating the statistics. But, there are some circumstances in which it does not, in that case, a better understanding of statistics is required. Moreover,… Read more

0 comments, 352 reads

Posted in Zora's SQL Tips on 3 May 2017

A Perfect Solution to Resolve SQL Server Error 211

SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a user to access the database in the more reliable and effective way. However, there are some situations such as destruction in… Read more

0 comments, 363 reads

Posted in Zora's SQL Tips on 28 March 2017

How easy to implement RLS (Row Level Security) in SQL SERVER 2016 (New Feature)

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.
Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your responsibility that one tenant’s…

Read more

0 comments, 1,189 reads

Posted in Zora's SQL Tips on 27 March 2017

SQL Server Deadlock Performance Counter

End users generally face a situation where the SQL server application gets hangs. What users generally do is restart the machine for fixing the problem and then continue with their work. This restarting activity works for two to three weeks and after that, a point comes where the system gets… Read more

0 comments, 1,778 reads

Posted in Zora's SQL Tips on 27 February 2017

Steps to Configure SQL Server to Listen On A Specific TCP Port

Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more

2 comments, 2,030 reads

Posted in Zora's SQL Tips on 18 January 2017

Learn Different Options for Importing Data Into SQL Server

Most of the time users need to import their data into SQL Server for its proper management. Select from the variation of source as well as destination data source types, choose tables for copying or even for specifying own query for data extraction and store the work as SSIS package.… Read more

0 comments, 887 reads

Posted in Zora's SQL Tips on 11 January 2017

Learn Uses of log_reuse_wait_desc In SQL Server

Overview

Many times, while working on SQL Server, the transaction log files frequently grow due to various reasons. Out of which, one such reason is that there is, already existing assigned space of the file in the SQL Server. This can be happened due to increment in the utilization of… Read more

0 comments, 566 reads

Posted in Zora's SQL Tips on 13 October 2016

Steps to Restore Database from Backup File In SQL Server

Overview

In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster, or manage large amount of database onto the SQL server. However, users generally knows the way to create a backup… Read more

0 comments, 508 reads

Posted in Zora's SQL Tips on 21 September 2016

Know How to Prevent SQL Database Corruption in An Efficient Manner

Overview

As many companies rely on SQL Server Database for the storage of their data, database administrators need to make sure that the database is made available whenever required without failure. In order to ensure that, he/she needs to make sure that the data integrity is maintained all the time… Read more

3 comments, 2,224 reads

Posted in Zora's SQL Tips on 24 August 2016

Reasons For Backup Failure In SQL Server and their Prevention

Overview:

The entire idea behind a backup, is to protect any organization from the data loss and corruption. However, the question arises what happen if user will loose the backup. Many times we still hear about businesses breaking down due to data loss. In this article we will discuss the… Read more

0 comments, 2,778 reads

Posted in Zora's SQL Tips on 30 July 2016

Know How to Handle Deadlock in SQL Server

Introduction To Deadlock

Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the resource as the other processes are preventing it from getting the resource. It is a very common issue in SQL… Read more

3 comments, 6,473 reads

Posted in Zora's SQL Tips on 4 July 2016

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It facilitates the function of data storing and retrieving by the applications which either run on the same or different platforms. The dominant reason behind the deployment of SQL Server on… Read more

0 comments, 10,224 reads

Posted in Zora's SQL Tips on 16 May 2016

SQL Server Error 3013: Restore Database is Terminating Abnormally

Overview of SQL Server Error 3013

One of the most frustrating situations that a user experiences while working with SQL Server is when errors are encountered. These errors disrupt the normal functioning of SQL Server and in worst case scenario may even lead to data loss. Sometimes, SQL Server Backup… Read more

0 comments, 3,855 reads

Posted in Zora's SQL Tips on 3 May 2016

What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?

REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL users and even administrators at times get confused about the real functioning of this command. It is to be noted that it contains the term Repair, which signifies that the… Read more

0 comments, 2,603 reads

Posted in Zora's SQL Tips on 19 April 2016

SQL Log File Corruption and Possible Recovery Methods

Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational database management system (RDMS) consisting of data definition language, data manipulation language and a data control language. The SQL database comprises of following three files:

  1. Primary Database files- Primary database file…

Read more

0 comments, 2,789 reads

Posted in Zora's SQL Tips on 21 March 2016

A Guide for Decrypting SQL Server Database Objects

Overview

The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from unauthorized access or hacker’s attacks. To make the data accessible, it needs to be decrypted with the use of key or password. It is necessary to encrypt critical SQL Server… Read more

0 comments, 1,903 reads

Posted in Zora's SQL Tips on 16 February 2016

Are SQL Server 2014 Table Variables Different From Temporary Tables?

What are the Table Variables in SQL Server?

In our previous blog we have discussed How to find free space In SQL Server database. Now, in this section we will elaborate about SQL Server 2014 Table Variables. SQL Server support features that allow users to work with temporary data… Read more

1 comments, 3,324 reads

Posted in Zora's SQL Tips on 4 February 2016

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server Database

In our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using them in SQL Server. Now, In this article we will discuss about how to check free space in sql server…

Read more

0 comments, 17,859 reads

Posted in Zora's SQL Tips on 15 January 2016

Older posts