Standard Members

Pro Members SQL Server Standard Members

Tips for Creating a Marketing Plan

This question came from a busy entrepreneur. · What do small business owners need to keep in mind while drafting a marketing plan? · What basics do they need to know about marketing plans? · Why are marketing plans important? One of the first things you need to keep in mind is “What are you trying to accomplish with a...

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 file and filegroups

Tips for using SQL Server 2017 file and filegroups Consider placing the log files on other physical disk arrays than those with the data files. Because logging is usually more write-intensive, it’s important that the disk arrays containing the SQL Server log files have sufficient disk I/O performance. Do not create many data and log files on the same physical...

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 17

Phase Locking (2PL) Procedure This locking procedure splits the implementation stage of a transaction in three (3) portions. In the very first (1st) portion, at the time when the transaction initiates for execution, it tries to find authorization for the locks that it have need of. The second (2nd) portion is when the transaction obtains every single lock. As soon...

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

5 Ways to Make Yourself Stand Out at Work

A busy professional asks a question regarding working relationships. I’m looking for meaningful, effective ways that employees in nearly any scenario can make themselves stand out in a good way. It goes without saying that above all, you must continue to produce high-quality work, make the most of your time at the office. We don’t want any of the below...

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 tempdb database in SQL Server 2017

Some tips for using tempdb database in SQL Server 2017 Set the reasonable size for the tempdb database and transaction log. First of all you should estimate how large your tempdb database will be. To estimate the reasonable database size, you should estimate the size of each table individually, add some additional space (10-20%) and then add the values obtained....

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 16

Equality Scheduling An equality scheduling can be of the subsequent categories: Result Equality At the time when two (2) schedules create the identical result after the implementation of the commands, they are known as result equivalent. They may perhaps give the similar outcome for certain value as well as not the identical outcomes for another group of values. That’s 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

10 Tips and Tactics for a Better Salary

A busy professional asks a question regarding negotiating for a better salary. I need some tactics to negotiating for a better salary. Whether you are negotiating in a hiring interview OR negotiating for a raise, there are several things you can do to put yourself in the winning position. Here are a few: 1. Make sure you are worth 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

Tips for using SQL Server 2017 cursors

Tips for using SQL Server 2017 cursors Use READ ONLY cursors, whenever possible, instead of updatable cursors. Because using cursors can reduce concurrency and lead to unnecessary locking, try to use READ ONLY cursors, if you do not need to update cursor result set. Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can results in some...

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 15

Transaction A transaction can be well – defined as a set of jobs. Any solo job is the least possible handling unit that cannot be further segregated anymore. Consider an instance of a simple transaction where a person is having two (2) savings account in two (2) different banks and he is transferring $ 100 from an account of ABC...

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 to Better Clarify Your Pay Structure to Client

A busy professional asks a question regarding client relationships. My client doesn’t want to pay for going over budget stating that I was unclear… was I? Prior to beginning a specific design project, I submitted a proposal to my client for her review and approval. It clearly specified the projected budget and terms. “Three concepts of the logo will be...

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