Check our collection of high-quality articles on a variety of SQL Server topics. The collection is being regularly updated with new articles.
In this article, we will be discussing about the “Divide by zero error encountered” error message in SQL Server. About the “Divide by zero error encountered” error message Well, as the error message says, whenever we have a division within a SQL query and the denominator has the value of zero (0) we get this … Read more…
In this article, we provide a list of commonly used string functions in SQL Server. By combining these functions, it is possible to easily manipulate strings. For each function, we provide useful examples, that can help you better understand these functions’ usage. REPLICATE This function given a string and an integer N, it repeats … Read more…
This article, discusses about the SQL Server 2005 Surface Area Configuration Tool. What is SQL Server 2005 Surface Area Configuration Tool? An important security improvement in Microsoft SQL Server 2005 is that various of its features that could be potentially susceptible to security risks are turned off by default. One of these features is … Read more…
Hi friends, this article discusses the “Backup Compression” feature in SQL Server. About Backup Compression in SQL Server How many times have we backed up a database and then we have tried to minimize the size of the backup set by compressing it with an archiving utility? I am quite sure that such cases … Read more…
In this article, we will talk about Row Constructors in SQL Server, which was originally shipped with SQL Server 2008. Inserting Records to a Table Prior to the Row Constructors Feature There are many cases were we just want to insert some data to a table. The traditional ways of doing that in SQL … Read more…
In this article, we will be discussing about Table-Valued Parameters (TVPs) in SQL Server 2008 and later. Support of Table-Valued Parameters is another great new feature in SQL Server 2008 and later. I am sure that all of us had to make a stored procedure or function call in SQL Server many times. In the … Read more…
In this article, we will compare DATETIME2 vs DATETIME in SQL Server, discuss about their precision and see some examples. About DATETIME2 in SQL Server The DATETIME2 is a data type in SQL Server, that was originally included in SQL Server 2008. We all know of the existence of the DATETIME. So, what is … Read more…
In this article, we will be discussing about, the MERGE Statement in SQL Server. The MERGE Statement is a T-SQL enhancement, which was originally shipped with SQL Server 2008. What is the MERGE Statement in SQL Server? So what actually is the MERGE Statement? When and how should it be used? The MERGE Statement … Read more…
About the char data type to a datetime data type conversion error There are some times where database applications give the following error when trying to convert strings to the datetime format in SQL Server: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. How … Read more…