Useful tips for everyday
What causes jump in identity column after restart? The SQL Product team makes a continuous change in the product which sometimes causes unpredictable behaviors in…
How to get only rows with same ID but different date? How can I get only rows with same id but different date. How can…
What is control file if control file is missing how you can recover? If all control files have been lost in a permanent media failure,…
How can I improve my Azure SQL Database? There are three primary options for Automatic Tuning with Azure SQL Database: CREATE INDEX: Creates new indices…
Is Tinyint the same as Boolean? The basic difference between Boolean and tinyint(1) is only in the naming convention. If we say that we need…
What is temporary files in PostgreSQL? 12. The temporary files that get created in base/pgsql_tmp during query execution will get deleted when the query is…
How to count unique distinct values based on a date? The array formula in cell D3 calculates the number of unique distinct items based on…
How do I install SQL Server on an existing Azure VM? To summarise: Log in to the Azure Portal. Add a new Azure SQL resource.…
What is beta on iPhone? What’s a beta? Betas are pre-release testing versions. Every iOS update goes through the beta phase before it’s officially launched,…
When does SSDT publish error occur in SQL Server? This happens when there exists a stored procedure (or view or constraint or other object) in…