Beginners Corner

What are Local and Global Temporary Tables in SQL Server?

by

In this article, we will talk about temporary tables in SQL Server and more specifically, we will answer the question: What are Local and Global Temporary Tables in SQL Server?   What are Temporary Tables in SQL Server? Temporary tables in SQL Server, is a special  type of database tables which once created, exist only … Read more…

What are Relational Database Management Systems (RDBMSs) and the SQL Server Data Platform?

by

In this article, in our “Beginners Corners” series of articles, you will learn what are Relational Database Management Systems (DBMSs) and the SQL Server Data Platform.   What are Relational Database Management Systems (RDBMs)? Relational Database Management Systems, also abbreviated as RDBMSs, are systems which are based on the relational model of data. The approach … Read more…

Best Way to Learn SQL Server – A Suggestion

by

Microsoft SQL Server is one of the most powerful Relational Database Management Systems (RDBMSs) in the world and it is absolutely logical the fact that many people are looking for the best way to learn SQL Server. By learning SQL Server, you acquire a competitive advantage in the job market. Read on to find out … Read more…

Locking and Blocking in SQL Server

by

This Article about Locking and Blocking in SQL Server is from my eBook “Tuning SQL Server (Second Edition)” Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More The majority of modern relational database management systems (RDBMSs) make use of lock-based concurrency. Lock-based concurrency is the approach based on which the Database Engine of a … Read more…