Useful tips for everyday
What are fixed server roles in SQL Server? Members of the securityadmin fixed server role manage logins and their properties. They can GRANT , DENY…
What is the main advantage of B-tree over binary search tree? The major advantage of the B+ tree (and B-trees in general) over binary search…
Can a PostgreSQL backup be restore on another server? Postgresql – backup database and restore on different owner? I did backup on database on different…
How do I restart Lsnrctl? To restart the listener use lsnrctl reload as shown below instead of lsnrctl stop and lsnrctl start. realod will read…
How do you clean PGAdmin? You can manually execute a “vacuum” process to clean all tables using pgAdmin. Open pgAdmin. Right click on the APM…
What is static data management? A static database management system (static DBMS) is an information-based relationship structured to facilitate update and retrieval in terms of…
When to reduce the cxpacket wait type in SQL Server? Occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the…
What is the difference between count (*) and Count 1 in Oracle? COUNT(*) or COUNT(1) The difference is simple: COUNT(*) counts the number of rows…
How do you calculate server requirements? You can also use tools like Calculator.net to calculate your monthly bandwidth usage and speed requirements….1) Estimate Your Bandwidth…
How do I change the Script language in SSIS? From the menu bar Tools>Options: In the Options dialog box, select Integration Services Designers under the…