Ameer Khan

What is linked server?Linked Servers allows you to connect to other database instances on the same server or on another machine or remote servers.It allows SQL Server to execute SQL scripts against OLE DB data sources on remote servers using OLE DB providers.The remote servers can be SQL Server, Oracle, Mysql etc. which means those… Continue Reading

How to take SQL server database backup without data? Version: Sql server 2012 There are different method available to achieve this goal. Such as..Script out the source database and then run the script against an empty target database to create all database objects that are in the source databaseRight click on the database -> select… Continue Reading

SQL Server is a relational database management system designed for large-scale transactions, e-commerce applications, data mining, and so on. Moreover, it is widely used on Business platforms for data analysis, data integration and processing components as it keeps all records fast, flexible and secure. The SQL server database contains three files i.e. First, database file… Continue Reading

To find out all the procedures of a database:- SHOW PROCEDURE STATUS WHERE Db = ‘thirstydb’; To set a new definer:-mysql> UPDATE `mysql`.`proc` p SET definer = ‘thirstydev@%’ WHERE definer=’thirstylive@localhost’ AND db=’devthirstydb’;Query OK, 0 rows affected (0.02 sec)Rows matched: 0  Changed: 0  Warnings: 0 mysql> UPDATE `mysql`.`proc` p SET definer = ‘thirstydev@%’ WHERE definer=’thirstylive@%’ AND… Continue Reading

The users can manually rename the physical files according to choice using the Transact-SQL commands in the following manner: Firstly, we will create a database “new_db” using SQL query. Naturally, the physical files will be named as “new_db.mdf”. Our main aim is to rename SQL Server physical files from “new_db.mdf” to “old_db.mdf”. Follow the below… Continue Reading

When a user is backing up a database or restoration procedure is in process, most of the SQL users faces an error i.e. SQL error 3271. This a type of error encounters when a system is performing an I/O operation. The main reason behind this error message is related to I/O operation that displays a… Continue Reading

Command:-mysqldump -u[user] -p[password] –add-drop-table –no-data [DATABASE] | grep ^DROP | mysql -u[user] -p[password] [DATABASE] Here test is the database name. I’m going to drop all the tables from this database.Example:-mysqldump -uroot -predhat –add-drop-table –no-data test | grep ^DROP | mysql -uroot -predhat test Continue Reading

MS SQL Server supports Large Object (LOB) data types for storing a large amount of data. Such data types includes Binary LOB (BLOB), Character LOB (CLOB) and Double-byte Character LOB (DBCCLOB) as well. They use a unique structure which is distinct from normal data types. In certain situations, Microsoft SQL server unable to access LOB… Continue Reading

SELECT    t.NAME AS TableName,    i.name as indexName,    sum(p.rows) as RowCounts,    sum(a.total_pages) as TotalPages,    sum(a.used_pages) as UsedPages,    sum(a.data_pages) as DataPages,    (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,    (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,    (sum(a.data_pages) * 8) / 1024 as DataSpaceMBFROM    sys.tables tINNER JOIN     … Continue Reading

What is hadoop?Hadoop is an open-source framework to store and process Big Data in a distributed environment. It contains two modulesone is MapReduce and another is Hadoop Distributed File System (HDFS). •MapReduce: It is a parallel programming model for processing large amounts of structured, semi-structured, andunstructured data on large clusters of commodity hardware. •HDFS:Hadoop Distributed… Continue Reading