Pro Members

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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register