Useful tips for everyday
Can I do a select in a trigger? The trigger event that initiates the trigger action can be an INSERT, DELETE, UPDATE, or a SELECT…
How do you make a symmetric key? To create identical symmetric keys on two different servers In Object Explorer, connect to an instance of Database…
What should be included in data dictionary? Data dictionary contents can vary but typically include some or all of the following: A listing of data…
How do you sample in SQL? sampling SQL databases sort by the field and use the SQL ‘LIMIT’ option to select the desired number of…
How can I tell if SQL 2014 Reporting Services is installed? To verify that the report server is installed and running Run the Reporting Services…
How do I give permission in SQL? Right-click on the table and select Properties. Click on Permissions option from Table Properties dialog box. Click on…
How to avoid concurrent update / insert in StackOverflow? By holding the proper lock for the duration of the transaction, I’ve got the holy grail.…
Why is my database backup plan not deleting old files? If the database backup maintenance plan involves multiple databases, it is possible that some old…
Does SSD improve SQL performance? Solid state drives (SSDs) can significantly enhance the ability to consume large amounts of data rapidly, enabling performance to make…
What is Filestream SQL? FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. FILESTREAM integrates the…