SQL Server

Pro Members SQL Server Standard Members

Database Management System at a Glance – Part 1

Definition of Database The Database is an interdependent collection of data that is used to retrieve, insert, and delete data efficiently. It is also used to organize data in the form of a table, chart, views and reports, etc. For example: The university Database organizes data about the administrator, employees, students and teachers etc. With the Database, you can easily...

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 should I do if I’m realizing being a product manager is not for me?

What should I do if I’m realizing being a product manager is not for me? Discovering early that you’re not doing what you enjoy (or aren’t succeeding at it) is probably a gift. Two possible situations: You know what you’d like to do (or try) next. Have a frank but humble discussion with your current manager about it. If there’s...

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 User-Defined Functions in SQL Server 2019

Tips for using User-Defined Functions in SQL Server 2019 Try to use Scalar UDF Inlining feature. SQL Server 2019 supports Scalar UDF Inlining. This feature automatically transforms scalar UDFs into relational expressions and embeds them in the calling SQL query. This transformation improves the performance of workloads that take advantage of scalar UDFs. A Scalar UDF can be inline when...

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 7

Continuing with the examples in the previous articles in this series, let’s take a closer look at the structure of a sentence that might be submitted by a user when he or she want to learn something. For example, it might be the following sentence: “How to create a Wikipedia page”. You already know that it might be preprocess as...

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 Do I Change an Employee’s Attitude About Work-Hours?

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management, and work-life balance strategies. I have an employee who starts work at 7 am and...

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 full-text search in SQL Server 2019

Tips for using full-text search in SQL Server 2019 Make full-text index population during periods of low database access. Because full-text index population takes some time, these updates should be scheduled during CPU idle time and slow production periods. Reduce the full-text unique key size. To create a full-text index, the table to be indexed must have a unique index....

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 Do I Leave A Company When It Seems Like The Company Will Crumble When I Leave?

This question came from a busy professional. How do I tell my boss I am leaving (when it seems like the company will crumble when I leave)? I admire your loyalty to your boss, but the bottom line is that it should be strictly a business and professional decision. Consider the following: No one is truly indispensable Company survived before...

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