Standard Members

Pro Members SQL Server Standard Members

PART I: File Organization in DBMS

Introduction A database consists of a large amount of data. The data is grouped in a table of the RDBMS and data records are assigned to each table. A user can see that the data is stored in tabular form, but in reality this large amount of data is stored in the form of files in physical memory. Overview of…...

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

Is it considered bad etiquette to ask when to leave work?

A busy professional asked me this question:   Why is it considered bad etiquette to ask when to leave work? I wouldn’t call it “bad etiquette”. But there are different ways to get the information that you need. One way, that is more professional and business goal oriented, is to simply ask about the policies and expectations. Ask about 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.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2019 Transact-SQL optimization tips (Part 2)

SQL Server 2019 Transact-SQL optimization tips (Part 2) Try to avoid using the DISTINCT clause, whenever possible. The DISTINCT clause should only be used if you know that duplicate returned rows are a possibility. Because using the DISTINCT clause will result in some performance degradation, you should use this clause only when it is necessary. Consider using a MAXDOP option…...

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

PART II: Deadlock and Starvation in DBMS

Deadlock Avoidance If a database is in a deadlock, it is always better to avoid the deadlock than to restart or abandon the database. The blocking prevention method is suitable for small databases, while the blocking prevention method is suitable for large databases. One way to avoid deadlocks is to use logic that is consistent with the application. In 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.
Log In Register
Pro Members SQL Server Standard Members

4 Job Skills Needed to Rebound from COVID-19

As most of us are in lockdown at home, we wonder what a post-coronavirus-world might look like. It is extremely unlikely that things will just go back to exactly the way they were before. Our workplaces are likely to change, and with it, the skills companies will require. Here are 4 job skills that are likely to be in high…...

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

SQL Server 2019 Transact-SQL optimization tips (Part 1)

SQL Server 2019 Transact-SQL optimization tips (Part 1) Use table variables instead of temporary tables. Table variables require less locking and logging resources than temporary tables, so table variables should be used whenever possible. Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use…...

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 15

In this part, we’ll continue with the discussion on how you might conduct an AI-powered search to discover phrases (certain sequence of tokens in a sentence) that satisfy a certain syntactic dependency pattern or several patterns at once. In the previous parts, you learned how this concept can be implemented when you are given a set of words describing 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.
Log In Register
Pro Members SQL Server Standard Members

PART I: Deadlock and Starvation in DBMS

Deadlock Definition A deadlock is a condition in which two or more transactions wait indefinitely to unlock the lock. Deadlock is considered one of the most feared complications from DBMS, as no task is complete and is pending forever. Example: The T1 transaction blocks certain rows in the student table and has to update certain rows in the classification table…....

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

Coronavirus: Is job hunting totally pointless during the coronavirus outbreak?

I go back and forth on this.  There is no “logical” reason why anyone should stop interviewing and searching for a job during this coronavirus outbreak.  We have the technology for individual and group virtual interviews.  There are various positions and ways to conduct roles, responsibilities and performance evaluations remotely.  We are in a global economy and everything that we…...

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

Tips to work with SQL Server 2019 clustering

Tips to work with SQL Server 2019 clustering Consider using SQL Server 2019 Big Data Clusters. SQL Server Big Data Clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. With Big Data Clusters you can read, write, and process big data from Transact-SQL or Spark. Set the performance boost for the foreground…...

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