One of the DBAs from the recently asked me if I know any easier way to create a table from another table without generating a CREATE TABLE script.
Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.
It is totally possible to Insert Multiple Values into Multiple Tables in a Single Statement. Let us learn how we can do that in today’s video.
Enabling Priority Boost does not mean that you get performance from your SQL Server. It may be quite opposite. SQL in Sixty Seconds.
You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.