Types of NoSQL Databases

Types of NoSQL Databases Document Oriented DatabasesA document database is designed to store semi-structured data as documents, typically in JSON or XML format.At a collection level, this allows for putting together a diverse set of documents into a single collection. Document databases allow indexing of documents on the basis of not only its … Document Oriented Databases A… Read More »

Bharat Negi

Categories of Databases

OLTP  is a class of systems that supports or facilitates high transaction-oriented applications it is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second.

Bharat Negi

Introduction OF MongoDB

MongoDB is an open-source document database. It is developed in C++ and hence, it provides flexibility with object-oriented concepts MongoDB provides MapReduce VPI’s. There is a tool called Gird FS which is used to store huge amount of data comprising different structure Schema less is big advantage of MongoDB over RDBMS . one collection holds any no of… Read More »

Bharat Negi

MYSQL installation step on Linux using RPM packages

MySQL is one of the best RDBMS being used for developing web-based software applications. It’s very easy to learn and maintained. The purpose of writing this tutorials will help you to quick start with Mysql Download Mysql tar file from valid sources. The recommended way to install MySQL on a Linux system is via RPM Now, follow the… Read More »

Bharat Negi

Tempdb has grown and disk is almost full

Most of us must have encountered this problem when tempdb data file has grown and the disk is almost full.You can follow below steps. 1.It may be possible that by the time you have logged in into the server,those temporary objects or the queries which caused data file to grown are gone.You can try to shrink the tempdb data file… Read More »

Abhishek Sharma

Query to Check Fragmentation and rebuild index in a database

Below query checks fragmentation level (>30%) per table which has clustered or non-clustered index and provides you the query to perform ONLINE rebuild of that index.The fragmentation level of the table which has the highest number of rows is displayed on top. Use [database_name] SELECT OBJECT_SCHEMA_NAME(ind.OBJECT_ID) + ‘.’ + OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS IndexType,… Read More »

Abhishek Sharma

Find the top 2 Candidate who have the highest vote

Try this query for getting the highest two records.

Bharat Negi

Create table with compute column in SQL Server 2008

Create table with compute column. Create table Demo ( min_sal int, max_sal int, Myavg_sal as (min_sal+ max_sal)/2 )

Bharat Negi

How to move resource database

Resource Database: Resource database is available from the SQL Server 2005 and higher level versions. Resource database is read only and hidden database. Resource database contains all the system objects that shipped with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of… Read More »

Rakesh Singh

SQL Server buffer pool

The primary purpose of the SQL buffer pool is to reduce database file I/O and improve the response time for data retrieval. In SQL Server 2014, administrators can extend the buffer pool to a nonvolatile storage device such as a solid-state drive (SSD) or an SSD array. SQL Server writes only clean pages to the buffer extension in… Read More »

Abhishek Sharma