Useful tips for everyday
In what order are SQL results returned if there is no ORDER BY clause? 3 Answers. If you don’t specify an ORDER BY , then…
Can you do data analysis with SQL? Structured Query Language (SQL) has been around for decades. It is a programming language used for managing the…
How to get the last N Records in MongoDB? If you use the auto created _id field it has a date embedded in it so…
What are the different options that you can use to filter records? Select from the following types of filters: Common filters: To filter for specific…
How do you reduce MDF tempdb? To remove additional files in tempdb, use the ALTER DATABASE command by using the REMOVE FILE option. Use the…
Can you UNION multiple tables? In a UNION statement, you need not select from different tables. You can select results from different subsets of the…
What is sequential value? Generating sequential values is a common database application development problem. Each sequence is a uniquely named database object that can be…
How do you declare a date variable in shell script? To get the date in bash shell and add a date, you can use the…
What is MySQL query log? The general query log is a general record of what mysqld is doing. The server writes information to this log…
How to create own dynamic type or dynamic object? There, is for example, ViewBag property of ControllerBase class and we can dynamically get/set values and…