Tag: Database

All the articles with the tag "Database".

• 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 Query to Get Column Type

  Published:Jul 12, 2017 |  at 08:52 PM

  A SQL query to retrieve column details such as data type, max length, precision, and primary key status.

• MSSQL Query to Count Tables in a Schema

  Published:Mar 16, 2016 |  at 05:18 AM

  A simple MSSQL query to count the number of tables within a specific schema using `information_schema.tables`.