Useful tips for everyday
How do I truncate a SQL server log file? Truncate the transaction log Right-click the database and select Properties -> Options. Set the recovery model…
How to do a backup in SQL Server management studio? Enter a valid path and file name in the File name text box and use…
How can check high memory utilization process in SQL Server? You can monitor memory use at the database level as follows. Launch SQL Server Management…
How to resolve blocking problems that are caused by Lock? If the lock that’s blocking other users is anything other than a TAB (table-level) lock…
What is meant by quiesce? : to become quiet, calm, or silent. What does it mean to quiesce a database? to pause/alter To Quiesce means…
Which model is ER diagram? ER Model stands for Entity Relationship Model is a high-level conceptual data model diagram. ER model helps to systematically analyze…
How do you merge rows in access? Press and hold the “Ctrl” key on your keyboard, and then click the second of the two fields…
Where can I find SQL Server installation files? To find the installation location of a particular instance, navigate to the following location in the Windows…
What data types are suitable for SQL databases? SQL Server supports the following data type’s categories: Exact numeric: bit, tinyint, smallint, int, bigint, decimal, numeric,…
Should primary key always be integer? It is usually recommended to use integer primary keys as these are the fastest way to determine relations. e.g.…