Tag: SQL Server

All the articles with the tag "SQL Server".

• 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.

• SQL Server Loop

  Published:Oct 1, 2016 |  at 04:15 AM

  Learn how to create a simple loop in SQL Server to automate repetitive tasks.

• MSSQL Collation Management

  Published:Mar 2, 2016 |  at 11:32 PM

  Learn how to change the collation of a SQL Server database and its columns, ensuring consistency across tables.