Work with data

SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets 

SQL Server, Work with data

Is SQL Server PARTITION BY clause giving you a brain freeze?  Beginners feel like entering a...
Read More

T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time 

SQL Server, Work with data

Is it a big deal to choose between CHAR and VARCHAR? What if your choice between CHAR vs. VARCHAR results in a nightmare of query...
Read More

The Importance of SQL Server Data Tools (SSDT)

Database administration, Tools & technologies, Work with data

Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features. In this article, we...
Read More

ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips

Database administration, MySQL, Work with data

MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You...
Read More

VARCHAR and NVARCHAR Data Types in SQL Server

Database administration, Work with data

Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid...
Read More

How to Change Server Level Collation of Running SQL Server Instance

Database administration, Work with data

In my previous article I have explained the basics of SQL Server Collation. I would suggest you first read that article (if you haven’t...
Read More

How to Change Database Collation in SQL Server: Step-by-Step Guide

Database administration, SQL Server, Work with data

When you develop an application or write a code in the SQL database system, it is crucial to...
Read More

SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases

Database administration, Work with data

This post has “strings attached: for a good reason. We are going to explore deep into SQL VARCHAR, the data type that deals with...
Read More

FLOAT Data Type in SQL Server: A Practical Guide to Prevent Unexpected Mathematical Errors

Database administration, Work with data

Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL FLOAT data type, you may have come...
Read More

Storing Binary Data Types in SQL Server

Database administration, Work with data

Introduction Daily work rarely requires storing binary data directly to database columns. However,...
Read More
Close