Useful tips for everyday
Do you have to update the schema when you move an object? Moving an object such as a table or synonym will not automatically update…
How do I allow RDP only from certain IP addresses? In order to restrict RDP to specific IP addresses, Go to the control panel->Administrative Tools.…
How many column indexes can I create in MySQL? MySQL can create composite indexes (that is, indexes on multiple columns). An index may consist of…
Do you need to export column headers in BCP? I’m exporting query data to a flat text file using bcp. I need to export column…
How to change InnoDB _ log _ file _ size value in MySQL? Open the MySQL configuration file my.cnf in a text editor. In this…
Which clause is used with update command? In order to modify data in a table, we’ll use an Update statement, a DML (data manipulation language)…
How to restore SQL Server 2008 R2 databases? Follow below mentioned steps to take backup from source database (i.e. SQL Server 2008 R2): 1) Change…
How do I skip the first 10 rows in SQL Server? The following shows the syntax of the SQL FETCH clause: OFFSET offset_rows { ROW…
Can I remove mysqld log? Each log file may be handled daily, weekly, monthly, or when it grows too large. – close any existing binlog…
Can you query a mirrored database? 1 Answer. In database mirroring you can query the mirrored database only if you create snapshots of that database.…