Useful tips for everyday
Are there multiple records in the same table? 89 records returned in the query result. Note that the data in the column on which we…
What do I need to know about DBCC checkdb? Summary: Database Console Command (DBCC) CHECKDB is frequently used by many SQL Server database administrators (DBAs)…
How many indexes do I need with MongoDB? 0 MongoDB can use an index when the queried field (s) are contained in an index. Furthermore,…
How much disk space do I need for my PostgreSQL database? IFI recommends 6TB of disk space for an on-site PostgreSQL instance. Normally, this will…
How to use SSDT as a database schema compare tool? After installation Open SSDT; Click on SQL -> Schema Compare -> New Schema Comparison. Select…
How do I copy an Azure SQL Database to another subscription? Copy to a different subscription Make sure you use a login that has the…
What is force index in MySQL? The FORCE INDEX hint acts like USE INDEX ( index_list ) , with the addition that a table scan…
How to create user with password In DB2? Procedure Create an operating system user. You must have root authority to create a user. Set the…
Which helps you to define the database structure or schema? The process of creating a database schema is called data modeling. A logical database schema…
How can create long run query alert in SQL Server? For using SQL Server Agent Alerts to monitor Long Running Transactions, following steps needs to…