SQL Server

Pro Members SQL Server Standard Members

How to Increase Productivity During Certain Times of the Day

What of people who are only productive during certain times of day? Should time management be considered in terms of productivity? Absolutely! Many of us have blocks of time or selective times during the day that we are most productive. For example, many people are more creative in the morning hours. Some people like to exercise in the morning before...

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 indexes in SQL Server 2017 (Part 2)

Tips for using indexes in SQL Server 2017 (Part 2) If you create a composite (multi-column) index, try to order the columns in the key so that the WHERE clauses of the frequently used queries match the column(s) that are leftmost in the index. The order of the columns in a composite (multi-column) index is very important. The index will...

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

Database and Hashing Technique – Part 4

Advantages of Database Management System (DBMS) Utilizing a Database Management System (DBMS) to manage data has numerous points of interest: Decrease of Redundancy: This is maybe the hugest favorable advantage of utilizing Database Management System (DBMS). Repetition is the issue of storing similar data in more than one place. Redundancy makes a few issues like requiring additional storage space, entering...

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

Should Overtime Be Avoided At All Costs?

Should overtime be avoided at all costs? In what situations do you recommend working overtime? In my opinion, it would be COSTLY to avoid overtime at all costs. Business Cycles In a realistic business environment, there will be both busy and slow seasons. Because of this natural cycle, it would not be a good business decision to make blanket statements...

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 indexes in SQL Server 2017 (Part 1)

Tips for using indexes in SQL Server 2017 (Part 1) Create a clustered index for each table. If you create a table without clustered index, the data rows will not be stored in any particular order. This structure is called a heap. Every time data is inserted into this table, the row will be added to the end of 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

Database and Hashing Technique – Part 3

CHARACTERISTICS OF DATABASE Simultaneous Use – A database system enables multiple clients to get access to the database simultaneously. Answering various questions from various clients with the similar (base) data is a focal part of an information system. Such simultaneous utilization of data expands the economy of a system. A case of simultaneous utilization is the tour and travel database...

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 Do You Manage to Stay Focused at Work When You Have Other Problems?

How do you manage to stay focused at work when you know that you have big problems at home? That is certainly a difficult situation. And it would depend upon the seriousness of the problem. Difficult but not serious If a problem is difficult but not serious, then decompartmentalize the situation by doing the following: 1. Identify the tasks that...

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 temporary tables in SQL Server 2017

Tips for using temporary tables in SQL Server 2017 Consider creating indexes on the very large temporary tables. The temporary tables provides much more efficient way to access their data in comparison with general tables, but if you work with very large temporary tables, using indexes can greatly improve performance. Use Table data type instead of temporary tables whenever possible....

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