Useful tips for everyday
What does replication mean in SQL Server Azure? APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse. Replication is a…
How do I save 10000 characters in SQL Server? SQL SERVER – How to store more than 8000 characters in a column Step 1 :…
What happens when Oracle database is shut down? Immediate database shutdown proceeds with the following conditions: 1 No new connections are allowed, nor are new…
When to enable or disable jobs on failover? On all 3 instances we have the jobs AG Database Health and AG Replica Health. These jobs…
Can you pause Azure SQL Database? If you deploy an Azure SQL Database, you don’t get an option to stop it. If you do not…
How do you insert a query into a temp table? SQL queries related to “select into temp table” select insert into temp table. create a…
Why is MySQL update taking a long time? In my case a transaction turned the update statement (s) from a blazingly fast execution time to…
How to handle an error in SQL Server? In SQL Server you can take advantage of TRY…CATCH statements to handle errors. When writing code that…
Can SQL Server run on Linux? Starting with SQL Server 2017, SQL Server runs on Linux. It’s the same SQL Server database engine, with many…
When to use maxdop to improve database performance? MAXDOP was not automatically changed for existing databases created prior to September 2020. In general, if the…