I received this question from a busy professional: To reduce my political strength, my manager recruited a new employee and transferred part of the development I’d do, to him. In addition, he’s giving me dirty assignments that I’ve never done before. Are there any ideas how should I deal with this? I am not sure your premise is correct regarding...
SQL Server
Tips for using query hints in SQL Server 2019
Tips for using query hints in SQL Server 2019 If your query is very slow, try the following before using query hints: – rebuild indexes used in the query (or defragment them using DBCC INDEXDEFRAG), – update statistics on the relevant tables, – consider creating new indexes for this query, – rewrite your query to provide better execution plan. Use...
PART III: File Organization in DBMS
Hash File Organization The organization of hash files uses the hash functionality calculation in certain areas of the records. The output of the hash function determines the location of the disk block where the records will be placed. When a record is received using the hash key columns, the address is created and the entire record is imported using this...
What should you do if your boss doesn’t respond to you.
I received this question from a busy professional: What should you do if your boss doesn’t acknowledge or respond to your emails and text messages? Since I don’t know the specifics, how often you are emailing or texting, or what time of day/night it is, my answer may not fit your specific situation. But here it goes. Put yourself in...
Tips for using table hints in SQL Server 2019
Tips for using table hints in SQL Server 2019 If your query is very slow, try the following before using table hints: – rebuild indexes used in the query (or defragment them using the DBCC INDEXDEFRAG command), – update statistics on the relevant tables, – consider creating new indexes for this query, – rewrite your query to provide better execution...
AI-powered Search with spaCy – Part 17
In this part, we”ll continue with the example discussed in the previous, sixteenth part in which you took a look at how you might conduct an AI-powered, spaCy-based search to find the most relevant articles from a set of news article titles and descriptions, using the syntax-driven sentence segmentation based on merging noun chunks. In this article, you’ll continue to...
Tips for using data types in SQL Server 2019 (Part 2)
Tips for using data types in SQL Server 2019 (Part 2) Use Table data type instead of temporary tables whenever possible. A Table data type is a special data type that used for temporary storage of a set of rows. In comparison with the temporary tables, table variables have some benefits. For example, table variables are cleaned up automatically at...
PART II: File Organization in DBMS
Approaches in File Organization One approach to mapping the database to files is to use multiple files and store fixed length records only in a specific file. An alternative is to structure ours files so that we can accept multiple lengths for records; however corrected files length recordings are easier to implement than variable length files. A lot of the...
Which is the best function of HR? What is the scope for it in the future?
I received this question from a busy professional. Which is the best function of HR? What is the scope for it in the future? The best function of Human Resources is the function that is needed at the time. It is normally the department of a business or organization that deals with the hiring, administration, and training of personnel. And...
Tips for using data types in SQL Server 2019 (Part 1)
Tips for using data types in SQL Server 2019 (Part 1) Consider using Java data types. In SQL Server 2019 Java data types are currently supported for Input/Output data sets and Input/Output parameters. For example, you can execute a Java script by using the sp_execute_external_script system stored procedure. Use bigint data type, if you need to store integer data from...