VARCHAR and NVARCHAR Data Types in SQL Server
Relational databases represent an organization’s data in tables that use columns with different...
SQL Server System Databases Maintenance
SQL Server Installation by default creates several system databases per instance to maintain and administer that instance. In this article,...
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 first read that article (if you haven’t...
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...
SQL Server Transactional Replication Issues
We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos...
How to Get SQL Server Statistics Information Using System Statistical Functions
Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
SQL Server RAISERROR Statement with Simple Examples
The SQL RAISERROR statement is used to send a custom message to the client application. It also can...
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...
Troubleshooting SQL Server Transactional Replication Issues
SQL Server Transactional Replication is one of the most common Replication techniques used to copy or distribute data across multiple...
SQL Server Transactional Replication Configuration
Transactional Replication in SQL Server is one of the most commonly used Replication techniques to...
