Useful tips for everyday
What are the permissions of sqlagentoperatorrole member? SQLAgentOperatorRole members have additional permissions on local jobs and schedules. They can execute, stop, or start all local…
What is in-memory database SQL? In-memory OLTP is a database technology available in SQL Server and SQL Database for optimizing performance of transaction processing, data…
How do you clean data from a database? Here are 5 ways to keep your database clean and in compliance. 1) Identify Duplicates. Once you…
How do I create a search query in Access? To create a simple one-table query: Select the Create tab on the Ribbon, and locate the…
Why use outer apply instead of left join? OUTER APPLY resembles LEFT JOIN, but has an ability to join table-evaluated functions with SQL Tables. OUTER…
How do you create a file with date and time? You should use double quotes and need to evaluate date +”%F” using command substitution. Double…
On which types of resources can SQL Server acquire locks? It controls locks on tables, on the pages of a table, on index keys, and…
How to avoid code repetition? How to remove duplicate code? The same method, create the same Local Variable and reuse it. The same class, create…
What are supertypes and subtypes? A supertype is a generic entity type that has a relationship with one or more subtypes. A subtype is a…
What is the last DML statement processed during a commit transaction? COMMIT; Commits all actions performed by the first DML statement (the DELETE statement) and…