SQL Server

Pro Members SQL Server Standard Members

Database Development Life Cycle, Normalization, Errors and Security of Database – Part 1

DATABASE DEVELOPMENT LIFE CYCLE (DDLC) The Database Development Cycle (DDLC) is a process of planning, applying, as well as preserving a database system to meet the tactical or operative information necessities of an enterprise or organization like – • Enhanced customer support as well as customer fulfillment. • Enhanced production managing. • Enhanced inventory managing. • More precise sales predictions…....

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Should I Lie About the Reason I Got Fired?

This question came from a business professional. I got fired for poor performance. Should I lie about the reason of it in my next job interviews? Firstly – I would not recommend “lying” in a job interview. The truth will most likely be discovered. And then you will be “caught in a lie” and therefore, seen as untrustworthy and unreliable…....

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 CLR Problems

Troubleshooting SQL Server 2017 CLR Problems If you have problems with SQL Server 2017 Common Language Runtime (CLR) objects, review this troubleshooting checklist to find potential solutions. 1. You may receive error 701 when you use a CLR table-valued function (TVF) together with the CROSS APPLY operator in a query. The error 701 indicates that there is insufficient system memory…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Parsing Intents and Their Targets into SQL Queries with spaCy: Part 2

In the previous article of this series, you learned that spaCy allows you to train its parser to be specific to your domain, which can be useful if you, for example, are developing a conversational application. In the example given in the article, you were guided through the steps of preparing training examples for the parser and then training the…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 3

SQL (Structured Query Language) – Indexes Indexes are special search tables that allow the database search engine to speed up data recovery. In short, an index is a pointer to the data in a table. An index in a database is very much related to an index which is present at the end of any book. For example, if you…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Should I Fire an Employee Who Reports Sick About 2 Days Per Month?

This question came from a business professional. “I have an employee who usually reports sick about 2 days per month, but he is a good worker. Should I fire him?” You have mentioned that he is a good worker, so I am not sure I understand the real concern here. If this employee meets and exceeds expectations, then why automatically…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting xml problems in SQL Server 2017

Troubleshooting xml problems in SQL Server 2017 If you have problems with SQL Server 2017 XML, review this troubleshooting checklist to find potential solutions. 1. The error 432 occurs when you try to use the Xml data type methods in check constraints. This error indicates that Xml data type methods are not supported in check constraints anymore. You should drop…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 2

IBM DB2 Latest version 11.1. Developed in 1983. The language used is the C, C ++ assembler to write it. It is compatible with multiple versions of Windows, UNIX as well as Linux. Some functions are the following: It is very easy to install and configure, and the data is easily accessible. An individual can store the enormous amount of…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2017 triggers

Troubleshooting problems with SQL Server 2017 triggers If you have problems with SQL Server 2017 triggers, review this troubleshooting checklist to find potential solutions. 1. Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command. Additionally, you may receive the following error messages: “Cannot continue the execution because the session is in the kill state.”…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Parsing Intents and Their Targets into SQL Queries with spaCy: Part 1

People use natural languages to communicate with each other. To efficiently interact with a machine, good knowledge of programming languages is required. Natural Language Processing (NLP) is here to enable human-machine communications through natural languages. This is however, a very general notion of what NLP is. Intuitively, it may seem that an NLP-enabled application understands human speech natively, like a…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register