Useful tips for everyday
Why is an error log useful? In computer science, an error log is a record of critical errors that are encountered by the application, operating…
Can a TRUNCATE table be rolled back? TRUNCATE command can be rolled back if it is used inside a TRANSACTION. As TRUNCATE is a DDL…
What can I use extended events data for? Extended Events supports using event data outside a process. This data is typically used by: Tracing tools,…
Can we connect SQL Server with other servers? To create a linked server to another instance of SQL Server Using SQL Server Management Studio. In…
Are temp tables in memory? This all means that temporary tables behave like any other sort of base table in that they are logged, and…
How do you combine results of two queries into a single dataset? Click the tab for the first select query that you want to combine…
How to change a JSON field in PostgreSQL? Updated: Added function for replacing an existing json field’s key by another given key. Can be in…
What are indexed views in SQL Server? SQL Server Views are virtual tables that are used to retrieve a set of data from one or…
How to change the theme of your website? How to Change a WordPress Theme (Without Breaking Your Website) To successfully and safely change your WordPress…
How do I put single quotes around text in SQL? SQL SERVER – How to insert a string value with an apostrophe (single quote) in…