Pro Members

Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

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...

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.
Log In Register
Pro Members SQL Server Standard Members

AI-powered Search with spaCy – Part 16

In this part, we”ll take a look at how you might conduct an AI-powered search to extract a quick answer from a set of news article titles, using the syntax-driven sentence segmentation and syntactic dependency parsing features of spaCy. In particular, you’ll learn how you can get an answer to your business question immediately using news headlines analysis and natural...

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.
Log In Register