Welcome to our blog post where we will be discussing various concepts and ideas related to SQL Server. SQL Server is a powerful relational database management system that is widely used in the industry. Whether you are a beginner or an experienced developer, there is always something new to learn in the world of SQL Server.
2007: CASE Statement in ORDER BY Clause – ORDER BY using Variable
In this article, we explore the use of the CASE statement in the ORDER BY clause of a SELECT statement. We discuss a scenario where an application was preparing a string for the ORDER BY clause and passing it as a variable to a stored procedure. We also highlight the performance implications of using EXEC versus sp_executesql for executing dynamic SQL statements.
2008: Introduction to SPARSE Columns Part 2
In this article, we delve into the concept of SPARSE columns in SQL Server. We explain how SPARSE columns are stored as XML in the database and discuss the advantages and disadvantages of using SPARSE columns. We recommend reading Part 1 of the series before continuing with this article.
2009: Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
In this article, we provide an overview of the backup and restore process in SQL Server’s full recovery model. We discuss the different types of database backups, including full, differential, and log backups. We also explain the importance of using the NORECOVERY option during the restore process to maintain database integrity.
2010: SELECT * FROM dual – Dual Equivalent
In this article, we explore the concept of the DUAL table in Oracle and its equivalent in SQL Server. We explain that the DUAL table in Oracle is used for various purposes, such as checking the content of the table. We provide a syntax example for querying the DUAL table in SQL Server.
2011: SQL SERVER – Interview Questions and Answers – Frequently Asked Questions
In this series of articles, we answer frequently asked questions related to SQL Server. We cover a wide range of topics, including basic functions for system databases, the maximum number of indexes per table, new features of SQL Server 2008 Management Studio, and more. These articles are a great resource for interview preparation or expanding your SQL Server knowledge.
2012: Example of Width Sensitive and Width Insensitive Collation
In this article, we discuss the concept of collation in SQL Server. We explain the difference between width sensitive and width insensitive collations and provide an example with a table containing two columns with different collations. This article is helpful for understanding how collation affects string comparison in SQL Server.
2012: Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video
In this video tutorial, we demonstrate how to generate a script for schema and data in SQL Server. We explain that sometimes it is necessary to move only part of a database, and backing up and restoring the entire database may not be feasible. We show you how to generate a script that includes both the schema and data, allowing you to move it to another server.
INFORMATION_SCHEMA . COLUMNS and Value Character Maximum Length -1
In this article, we address a common question regarding the value -1 in the CHARACTER_MAXIMUM_LENGTH column of the INFORMATION_SCHEMA.COLUMNS table. We explain that the length of a column can be any positive number or -1, which indicates that the column has a maximum length defined by the data type. This article provides insight into the meaning of -1 in this context.
We hope you find these articles informative and helpful in your SQL Server journey. Stay tuned for more exciting content on SQL Server concepts and ideas!