Standard Members

Pro Members SQL Server Standard Members

Tips for using backup and restore in SQL Server 2017

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server 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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here