Useful tips for everyday
How do I get SQL database out of recovery mode? Getting the Database Out of Restoring Mode Flush off all other users and get exclusive…
How do I upgrade SQL Server to 2017? Upgrade SQL Server Mount the iso file by right clicking on it and selecting the Mount option.…
How backup works internally in SQL Server? Q3. What is a full SQL Server database backup and explain the internal process performed? A full database…
Can you restore a SQL database without log file? Right click on databases and click on restore, select the database name from the drop down…
What does show slave status mean in MySQL? When the replica SQL thread receives an error, it reports the error first, then stops the SQL…
How do you sum query results? Add a Total row Make sure that your query is open in Datasheet view. To do so, right-click the…
How do you stop a service broker? How to enable, disable and check if Service Broker is enabled on a database To enable Service Broker…
How do I PIVOT in SQL? In Database Explorer, right-click the PurchaseOrderHeader table and select Send to and then Pivot Table in the popup menu.…
How do you return a value from a stored procedure in MySQL? To return a value from stored procedure, you need to use user defined…
What is multiple data file? The ability to have tables and charts from different data files intermixed in the Outputs Tab. The ability to have…