Useful tips for everyday
What makes a subquery correlated? The subquery is correlated because the number that it produces depends on main. ship_date, a value that the outer SELECT…
What is a benefit of having a foreign key constraint? The FOREIGN KEY constraint is crucial to relational database design. It lets us link the…
Can you see stored procedure parameter values in extended events? One complaint I’ve received frequently is that you can’t see stored procedure parameter values in…
How long should a query last? Anything shorter than 250 usually (but not always) seems too short and anything longer than 350 usually (but not…
How is a generated column stored in PostgreSQL? A virtual generated column occupies no storage and is computed when it is read. Thus, a virtual…
How to remove specific / certain characters from text? Simply copy and paste your Text into the “Text-Area”. Online Remove Specific Characters From Text, Remove…
When to insert or update only particular record using trigger? When using triggers (and OUTPUT clause on SELECT or MERGE statements), there’s a special keyword…
Can we update view in PostgreSQL? An updatable view may contain both updatable and non-updatable columns. If you try to insert or update a non-updatable…
How to do replication on a mirrored database? Login to your principal database instance. Navigate to the Replication folder and the publication we created. Right…
How do I know if my backup is restored? Open SSMS, right click on a database then select Task -> Backup or Restore. A screen…