Standard Members

Pro Members SQL Server Standard Members

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
Already a member? Log in here
Pro Members SQL Server Standard Members

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
Already a member? Log in here
Pro Members SQL Server Standard Members

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
Already a member? Log in here
Pro Members SQL Server Standard Members

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
Already a member? Log in here
Pro Members SQL Server Standard Members

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
Already a member? Log in here
Pro Members SQL Server Standard Members

Some tips for using DBCC commands in SQL Server 2017

Some tips for using DBCC commands in SQL Server 2017 Use the DBCC SHOW_STATISTICS command to displays the current distribution statistics for the specified target on the specified table. You can use this DBCC command to see how distributed the data is and whether the index is really a good candidate or not. Avoid using the DBCC SHOWCONTIG command. This...

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
Oracle Pro Members Standard Members

Machine Learning with R from a SQL Environment

Using R with Oracle Database Setting Up Your Working Environment Before you can start using Oracle R Also, to follow along with the article examples, you will need a SQL tool to interact with your Oracle database, such as Oracle SQL Developer or Oracle SQL Plus. Deploying R Scripts to Oracle Database Using the following code, you store an R...

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 Delegating Work

In the past few weeks, several busy professionals have asked questions about how to best delegate work. This article contains the answers to their various questions. Is there a right time for one to delegate and at what point should an entrepreneur feel comfortable enough to delegate? When it comes to delegating tasks, what advice can you give to get...

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

Some tips for using jobs in SQL Server 2017 Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs and locate any problems. Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can...

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) Should a Project be Monitored on an Ongoing Basis?

How should a project manager monitor projects on an ongoing basis? The short answer is “YES” Step to Project Management Every step of the project and project management process needs to be monitored on an ongoing basis. Here are some steps to project management: Project Initiation. Project Planning. Project Execution. Project Monitoring and Control. Project Closure. Each step has its...

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