Azure SQL Database has feature to restore the database to point in time when the database is live. When we have to move the database to different Server we end up deleting the database from old server, we can not perform point in time restore! 104 more words
Tags » SQL Server
Problem statement. I once heard from Steven Feuerstein, an Oracle evangelist, that any given code should not be more than ten lines for easy readability and maintainability. 1,107 more words
Happens when one transaction update overwrites another, causing the update to be lost.
Reading uncommitted records.
Reading while another transaction is adding new record, result in different number of rows being returned. 18 more words
SQL Server :- Error - "Cannot resolve the collation conflict between "Latin1_General_100_BIN2" and "Latin1_General_CI_AS" in the equal to operation"
Error during SQL Server Upgrade; specifically upgrade from MS SQL Server 2016 SP1 to Sp2.
2018-05-18 22:27:31.36 spid4s Creating procedure sp_sqlagent_get_perf_counters... 2018-05-18 22:27:31.37 spid4s Error: 468, Severity: 16, State: 9. 666 more words
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when I executed this code: 196 more words
SQL OUTPUT PUZZLE | The Assignment Puzzle – ? | Advanced SQL
In this puzzle you have to go through the SQL statement given below and provide us the output without executing the SQL on SSMS or any other onsite SQL tool. 257 more words