Useful tips for everyday
What is the difference between real time apply and redo apply? By default, the redo data is applied from archived redo log files. When performing…
How to fix ORA-03113 end-of-file on communication channel? The proper fix is to get rid of the recovery files. You do that using RMAN, not…
How is a schema represented in a database? A schema contains schema objects, which could be tables , columns, data types, views, stored procedures, relationships,…
How to read estimated execution plan? To read the SQL Execution Plan correctly, you should know first that the flow of the execution is starting…
How do I delete extra tempdb files? Restart SQL Server Instances and then execute the following query. USE tempdb; GO. DBCC SHRINKFILE(‘tempdev2’, EMPTYFILE) GO. USE…
How to speed up the SQL update query? An update statement is a fully logged operation and thus it will certainly take considerable amount of…
What is a slow MySQL query? The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at…
How do I split a column by value? Split comma-separated value string in a column. SELECT ProductId, Name, value FROM Product CROSS APPLY STRING_SPLIT(Tags, ‘,’);…
Why SQL Server is not starting? Reason # 2:Startup parameters have incorrect file path locations. This is another common cause of SQL Server Service startup…
How do I transfer logins to another SQL Server or instance? To transfer the logins, use one of the following methods, as appropriate for your…