Useful tips for everyday
How can I change the value of a global parameter? In the side-nav, enter a name, select a data type, and specify the value of…
What is a 1 1 relationship in database? A one-to-one relationship is a link between the information in two tables, where each record in each…
How to get id of Max Value in group? I have a table and i would like to gather the id of the items from…
Why is my Windows Backup schedule not working? Many reasons could result in Windows backup schedule not working. Scheduled backup will fail when the target…
How do I use non-ASCII characters? This is easily done on a Windows platform: type the decimal ascii code (on the numeric keypad only) while…
How do you write an efficient query? 12 Tips to Write Efficient SQL Queries Create Small Batches of Data for Deletion and Updation. Use CASE…
How do I give permission to a csv file? 8 Answers Right click the folder containing the data file(s) that permission was denied to and…
What are implicit transactions in SQL Server? Implicit transaction mode in SQL Server In the implicit transaction mode, the database objects involved in the transaction…
Why is SQL Server Agent service unable to start? Basically, the SQL Server Agent service was unable to start because it can’t access the log…
What does PARSENAME do in sql? The PARSENAME function returns the specified part of an object name. The parts of an object that can be…