We have a number of services that are hosted with cloud providers – from this site’s hosting to our virtual event platform and others, it’s interesting to see cloud evolve and provide some killer support for deploying cool solutions. One of the things that we’ve been seeing more and more though is a “yeah, us too!” type of approach to […]
SQL Server
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Database and Hashing Technique – Part 2
Database: It is a collection of related tables or relations. Consider the subsequent collection of tables or relations: Table – 1 Customer_ID Name Age 001 X 12 009 B 13 100 A 14 Table – 2 Customer_ID Account_No 001 S100 009 S200 100 CA200 Table – 3 Account_No Type S100 Savings S200 Savings CA200 Current Account Table – 4 Type...
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
Register
Already a member? Log in here
Which Is Better: Overtime or Multiple Shifts?
Do you think working in shifts would be more productive for the business than using one employee for a longer more permanent duration? What does “productive” really mean? Before we can explore that questions, we need to agree upon what “more productive for the business” really means. In regards to company productions, it is the combination of cost and time....
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
Register
Already a member? Log in here
Tips for using linked servers in SQL Server 2017
Tips for using linked servers in SQL Server 2017 Ensure that the connection between the linked servers is fast. Ideally, the linked servers should be in the same subnet. Try to avoid using distribution transaction or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution transactions, whenever possible. One of the first steps to...
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
Register
Already a member? Log in here
Database and Hashing Technique – Part 1
HASH FILES ORGANIZATION Hashing (hash addressing) is a procedure for giving quick direct access to a particular record based on a given estimation of some field. When two (2) or more (n) key values hash to a similar disk address, at that time it cause an impact. The hash function ought to convey the area of the key conceivably equitably...
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
Register
Already a member? Log in here
Should Communication with Employees Outside of Work-Hours Be Allowed
Should communication with employees outside the working hours be allowed? Is it ok to have WhatsApp chat groups where team leaders can request specific information for other team members at all times? Major Faulty Premise One major fault with this question is the assumption that individuals “have to” answer every call, email, text message or any other communication “immediately”. Not...
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
Register
Already a member? Log in here