Useful tips for everyday
Can you deny access to a database schema? Run the above in the master database and you’ve removed access to the contents of those schemas.…
When to change from a heap to a clustered index? If the table has nonclustered indexes, all the nonclustered indexes must all be recreated whenever…
How do I shrink a log file in SQL Server 2008 r2? Shrink The Database Open up Sql Management Studio. Right click the database, Tasks…
Does order matter in GROUP BY clause? No, the order doesn’t matter for the GROUP BY clause. MySQL and SQLite are the only databases I’m…
How do I copy a database from one instance to another? Copy Database From One Server to Another Server in SQL Open the SQL Server…
What should my readable secondary be in SQL AlwaysOn? With an SQL AlwaysOn, I Set my readable secondary to read intent only. When I try…
How do I enable WiredTiger in MongoDB? Procedure Start the mongod you wish to change to WiredTiger. ¶ Export data using mongodump . ¶ Create…
What do you need to know about SQL power architect? SQL Power Architect data modeling and profiling tool was created by data warehouse designers and…
How to insert on duplicate in MySQL dump? Sure, I can insert ON DUPLICATE in dump manually, but I want to automate merge process. –insert-ignore…
How does the size of a backup file depend on RMAN? The size of the backup file depends solely upon the number of blocks modified…