SQL Server

Pro Members SQL Server Standard Members

AI-powered Search with spaCy – Part 6

Summarizing all those examples you have seen in the previous articles in this series, you should have already a good grasp of how the most common types of request sentences might be processed to extract the phrase that is most relevant for feeding a search engine. Just to recap, you have seen examples that rely on using linguistic features extracted...

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

When to Explore

This question came from a professional. If you are the boss and one of your employees calls in the morning and says that they “didn’t feel good” when they woke up that morning so they’re taking a sick day, would you accept that excuse as given or would you probe for a more detailed answer? There are some reasons 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

Some tips for using SQL Server 2019 cursors

Some tips for using SQL Server 2019 cursors Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can results in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, if you need to perform row-by-row operations. Use READ ONLY cursors, whenever possible, instead of updatable cursors. Because using cursors 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

Prior to DBMS, Database Approach, Data Model — Part 2

Necessary Concepts of Database What is a Database? A database is a set of related data used to support the events of a given company. A database can be considered as a data warehouse once defined as well as accessible by several users. Database Properties The database has the subsequent features: It is an illustration of few aspect 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
Already a member? Log in here
Pro Members SQL Server Standard Members

Three Things Missing From Your Job Search

This question came from a job seeker. I was recently fired from a company. What things do I need for a job search? Everyone realizes the need for a resume and they may even remember to update their LinkedIn profiles and contacts. They may even meet with recruiters for assistance. But rarely to people take all the necessary 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

Some tips for using SQL Server 2019 triggers

Some tips for using SQL Server 2019 triggers Try to minimize the number of rows affected in a trigger. The more number of rows affected in a trigger, the more time a trigger takes to run. So, try to reduce the number of rows affected in a trigger. Consider disabling trigger’s recursion. Triggers are said to be recursive when a...

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

AI-powered Search with spaCy – Part 5

So far, you have seen examples that rely on linguistic features associated with individual words in a sentence, when extracting the most descriptive phrase from that sentence. Very often however, you might need to extract the entire chunks to work with. For example, in the following sentence: “How to use Oracle Database 19c from a Python script.”, you might want...

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

What’s the Simplest Way to Do Market Research?

This question came from a busy business owner. What’s the simplest way to do market research? Hello, I want to sell certain electronic devices and I just want know the basics steps if I do market research before launching them. Appreciate if someone could share the best practices on how to get started doing market research. We will guide you...

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 constraints in SQL Server 2019

Tips for using constraints in SQL Server 2019 Avoid using CHECK_CONSTRAINTS hint with bulk copy program. Using this hint can significantly degrade performance of the bulk copy operation, because for each row loaded the CHECK constraints defined on the destination table will be executed. Without the CHECK_CONSTRAINTS hint, any CHECK constraints will be ignored. Consider using the NOT FOR REPLICATION...

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

Prior to DBMS, Database Approach, Data Model — Part 6

Organisation Based on Number of Users A DATABASE MANAGEMENT SYSTEM (DBMS) can be organisation based on the user number it can support. It can be a single-user database system, that assists only one user at a time, or a multi-user database system, that can assists several users simultaneously. Organisation Based on Database Distribution There are four key distribution systems for...

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