Uses of HIVE 1. The Apache Hive distributed storage. 2. Hive provides tools to enable easy data extract/transform/load (ETL) 3. It provides the structure on a variety of data formats. 4. By using Hive, we can access files stored in Hadoop Distributed File System (HDFS is used to querying and managing large datasets residing in) or in other… Read More »

What is Hive in Hadoop?

Apache Hive is a data warehouse system for Hadoop, which enables data summarization, querying, and analysis of data by using HiveQL (a query language similar to SQL). Hive can be used to interactively explore your data or to create reusable batch processing jobs. After you define the structure, you can use Hive to query that data without knowledge… Read More »

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 »

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, AS IndexName, indexstats.index_type_desc AS IndexType,… Read More »

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 »