Useful tips for everyday
Which backup type is only available when the recovery model is set to full? Types of backups you can run when the data is in…
Can I restore master database? The SQL Server master database cannot be restored like other user or system databases because SQL Server cannot execute without…
How to increase shared buffer size in PostgreSQL? PostgreSQL allocation for the default shared_buffers is extremely low and we need to increase it to allow…
Why does MySQL hang when using TRUNCATE TABLE? The TRUNCATE may hang, because other processes could use this table, so to check run in shell:…
How do I open a .GZ file? How to open GZ files Download and save the GZ file to your computer. Launch WinZip and open…
Why hyper-v VM in saved state? During the backup of a Hyper-V host system, its Hyper-v guests can enter into a save state mode resulting…
How can insert stored procedure output to a table in SQL Server? Insert results of a stored procedure into a temporary table SELECT * INTO…
How do I fix parameter sniffing in SQL Server? Workarounds for SQL Server Parameter Sniffing Create SQL Server Stored Procedures using the WITH RECOMPILE Option.…
How do I fix SQL database in recovery pending mode? Methods to Fix Recovery Pending in SQL Server Database Issue Mark Database in Emergency Mode…
How do I find a query in a query store? If you input the query test you want to search into the search bar (boxed…