Enable contrast version

Tutor profile: Paul B.

Inactive
Paul B.
Tutored through college, work at a fortune 20 company in software engineering
Tutor Satisfaction Guarantee

Questions

Subject: SQL Programming

TutorMe
Question:

How can you improve the performance of a SQL query?

Inactive
Paul B.
Answer:

1. Don't Select *(all), only request the columns you need 2. Use with ur and for fetch only at the end of your query if real time results are not needed and you aren't going to update the database. 3. When joining large tables create temp tables of only the columns you need, cutting down not needed data and columns can dramatically speed up queries along with creating tables no one else is looking at.

Subject: Java Programming

TutorMe
Question:

What is the Java collections framework?

Inactive
Paul B.
Answer:

The Java collections framework is used to define, create and manipulate different grouping structures in java such as lists, arrays, dictionaries(key value pairs), ect.

Subject: Information Technology

TutorMe
Question:

What are the 3 best software tools that come with a windows PC for diagnosing and solving issues? Why?

Inactive
Paul B.
Answer:

1. Task Manager- Shows active processes and individual performance metrics for them, shows basic hardware performance, statistics and settings and finally gives detailed history on user software usage and services currently being used. 2. Device Manager- Shows all (properly) connected hardware and their properties along with the ability to check for driver updates (commonly solving issues) 3. Command Prompt/Power Shell- Execute many useful diagnostic and maintenance commands along with scripts for advanced users (Power Shell is a more advanced command prompt)

Contact tutor

Send a message explaining your
needs and Paul will reply soon.
Contact Paul

Request lesson

Ready now? Request a lesson.
Start Lesson

FAQs

What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Lesson" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.