SQL Server BIT Data Type – An Ultimate Guide

Total: 2 Average: 3

Introduction to Bit Data type

The data type represents an attribute that stores integer, character, data time, binary data. Suppose you have a web application for recording the users’ feedback for various questions. It contains multiple dichotomous questions and a few textbox-based questions, such as remarks. On the backend, these responses get stored in an SQL table.

Read More

9 Best Practices for Writing SQL Queries

Total: 1 Average: 5

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many ways to execute a SQL query to get desired results on your database.

However, not all SQL queries are created equal. Most can be optimized to follow the best practice. This article focuses on the ways of queries optimizing. After reading, you will know all the dos and don’ts of writing SQL queries.

Read More

Installing and Configuring SQL Server Express Edition

Total: 1 Average: 5

SQL Server is Microsoft’s premier database management system that we can use to develop relational databases. It also offers support for graph databases. Depending on the services offered, SQL Server comes in various editions, such as Enterprise, Standard, Personal, Developer, Express, etc.

In this article, we’ll deal with the SQL Server Express Edition, a free edition of SQL server commonly used for developing desktop, web, and small-scale server applications. We’ll clarify how to download, install, and configure it. Along the way, we’ll also illustrate how to install and use SQL Server Management Studio which is an easy-to-use GUI-based tool for managing SQL Server databases.

Read More

SQL FOREIGN KEY: The Ultimate, Easy Guide for Newbies

Total: 1 Average: 5

Newbie? Then an SQL foreign key may be foreign to you.

You may have heard different opinions about SQL foreign keys. If you haven’t, soon you will. Or your experience will affect your view. The main thing to know is, foreign keys are a must in relational databases.

Yet, some developers may remove or ignore foreign keys when facing some complications. So, what to do? To use the foreign key or not to use it? Will there be times when you won’t need to use them?

This guide is for you to see how important this thing is. You will also know some gotchas in code and learn how to fix them. Besides, of course, we’ll use practical examples. There’s nothing you can’t handle.

Read More

Renaming Indexes with sp_rename Procedure

Total: 2 Average: 5

Not so long ago, I was working on a project where we needed to change the data type of a table. The table had millions of rows, and we decided to create a separate table using the existing table definition and insert the rows into that table. After exporting data into the new table, we renamed the old table, constraint, and indexes using the sp_rename stored procedure.

The current article is dedicated to the ways of renaming indexes. 

Read More

Learn to Multicast Data Using SSIS Packages

Total: 1 Average: 5

This article describes configuring the job of multicasting data with the help of SSIS (SQL Server Integration Services) Packages. Also, it highlights the importance of Multicast Transformation in SSIS for sending data to multiple destinations as per requirement.

Additionally, we are going to explain the benefits of multicasting data and provide some professional tips.

Read More

How to Count the Number of Rows in SQL Server Table

Total: 1 Average: 5

Recently, I was working on a database performance improvement project. One stored procedure there was causing issues. In its code, a query populated the Count of the rows and stored the value in a local variable. That query was scanning a large table. Due to that, resource utilization became significantly higher. To fix the issue, we removed the faulty code and used the SQL Server catalog views to generate the Count of rows of the table.

Read More