Tips for using backup and restore in SQL Server 2017 Consider storing the backup files on physical disks on another computer. Storing the backup files on the same computer where the databases stores may cause problem with restoring databases if the physical disks were damaged. Try to separate your database to different files and filegroups to backing up only appropriate...
Standard Members
A Holistic View of Database Management System (DBMS) – Part 14
Techniques of Hashing Bucket: The hash file stocks the data in bucket like format and it is well thought out like a unit of storage. The bucket classically stocks one (1) whole disk block, which in turn can stock one (1) or more (N) data records. · Hashing function: A hashing function h is a plotting function which plots every...
Some tips for using XML in SQL Server 2017
Some tips for using XML in SQL Server 2017 Consider using the XML data type. This data type is used to store XML documents in table columns or Transact-SQL variables. The XML data type can be used in variables, columns, or in stored procedure and function parameters. Use the XQuery value() method instead of the query() method when you want...
A Holistic View of Database Management System (DBMS) – Part 13
Indexing It is already known that the data is kept in the format of records. Every single record has a key value that assists it to be identified exclusively as and when required. Indexing is a data organization method to competently recover the records from the database files created based on a number of columns or attributes on which the...
Should I Give an Acquaintance a Recommendation?
A busy professional asks a question regarding his co-working relationships. Should I give an acquaintance a recommendation? Someone I met twice has asked me for a written recommendation for a new job. I don’t know this person. He seems to have good reasons why he doesn’t have any close contacts to ask (either due to firms/departments have merged/acquired/vanished/outsourced or difficult...
Tips for using SQL Server 2017 triggers
Tips for using SQL Server 2017 triggers Try to use CHECK constraints instead of triggers whenever possible. Constraints are much more efficient than triggers and can boost performance. Constraints are also more consistent and reliable in comparison with triggers, because you can make errors when you write your own code to perform the same actions as the constraints. So, you...
A Holistic View of Database Management System (DBMS) – Part 12
File Arrangement The relative information as well as data is kept jointly in file formats. A file can be referred as a series of records warehoused in binary setup. A disk drive is configured into a number of blocks which can stock records. File records are mapped to those particular disk blocks. File Organization The file organization describes by what...
How Do You Handle a Manager Who is Bullying?
A busy professional asks a question regarding his co-working relationships. How do you handle when a manager is bullying an employee? I have a friend who is being bullied by their manager. The manager has stripped them of all responsibility and excludes them from meetings. The manager has also called them names during conference calls where everybody can hear and...
Tips for using constraints in SQL Server 2017
Tips for using constraints in SQL Server 2017 Use cascading referential integrity constraints instead of triggers whenever possible. For example, if you need to make cascading deletes or updates, specify the ON DELETE or ON UPDATE clause in the REFERENCES clause of the CREATE TABLE or ALTER TABLE statement. The cascading referential integrity constraints are much more efficient than triggers...
A Holistic View of Database Management System (DBMS) – Part 11
STORAGE MECHANISM The databases are kept in file formats, which have records in it. In physical level, the real data is kept in electro – magnetic format on some device. These storage procedures can be approximately classified into three (3) kinds: · Primary Storage: The memory storing device which is straightly available to the Central Processing Units (CPUs) are known...