Tag: SQL Server

All the articles with the tag "SQL Server".

• Understanding SQL Server ID Jumps

  Published:Jun 20, 2025 |  at 10:00 PM

  This article explains why identity column values in SQL Server may jump by large numbers, especially after restarts, and how to control this behaviour using configuration options introduced in SQL Server 2012 and later.

• Getting Started with LocalDB: Tips and Tricks

  Published:Jun 4, 2025 |  at 09:48 PM

  Learn what LocalDB is, how to manage it with SqlLocalDB.exe, configure connection strings, and locate database files for development.

• Running SQL Server in Docker

  Published:Dec 9, 2024 |  at 02:18 AM

  A comprehensive guide on running SQL Server in a Docker container, including setup, backup, and restore instructions.

• Which Tables Are Taking Up How Much Space

  Published:Dec 18, 2021 |  at 06:49 AM

  A query to determine which tables in a SQL Server database are taking up the most space, including the space used by indexes and data.

• Setting Up SQL Server Data Folder

  Published:Mar 24, 2021 |  at 02:16 AM

  A guide to setting up the SQL Server data folder and configuring user permissions for optimal SQL server performance.

• MSSQL Table to XML

  Published:Sep 28, 2017 |  at 09:22 AM

  A simple SQL query to convert a table to XML format in SQL Server.