How to Get SQL Percentage Calculation as Easy as Pie
Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a...
SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets
Is SQL Server PARTITION BY clause giving you a brain freeze? Beginners feel like entering a complex maze at first glance of code...
T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time
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...
The Importance of SQL Server Data Tools (SSDT)
Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and...
ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips
MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You set these permitted values during the...
VARCHAR and NVARCHAR Data Types in SQL Server
Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid...
How to Change Server Level Collation of Running SQL Server Instance
In my previous article I have explained the basics of SQL Server Collation. I would suggest you...
How to Change Database Collation in SQL Server: Step-by-Step Guide
When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and...
SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases
This post has “strings attached: for a good reason. We are going to explore deep into SQL VARCHAR, the data type that deals with...
FLOAT Data Type in SQL Server: A Practical Guide to Prevent Unexpected Mathematical Errors
Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL...
