SQL Server System Views and Functions

Q

Where to find tutorials on using SQL Server System Views and Functions related to data storage and I/O?

✍: FYIcenter.com

A

Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on using SQL Server System Views and Functions related to data storage and I/O.

What Is a SQL Server File

What Is sys.database_files?

What Is a SQL Server Filegroup

What Is sys.filegroups?

List All Files in a Filegroup

What Is sys.objects

What Is OBJECT_ID()

What Is a SQL Server Partition

What Is sys.partitions?

What Is sys.allocation_units

Find the File IDs of a Given Table

What Is fn_virtualfilestats()

Join sys.allocation_units with fn_virtualfilestats()

⇒ What Is a SQL Server File

⇐ "Your services were disabled" Error

⇑⇑ SQL Server Storage Tutorials

2019-07-14, ∼2476🔥, 0💬

"Execution Timeout Expired" Error on Azure Portal
Why am I getting the "Execution Timeout Expired" error when using the "Query Editor" on Azure Portal? If you are running a query or a script that runs more than 5 minutes in the Query Editor on Azure Portal, you will get the "Execution Timeout Expired" error, because Query Editor has 5-minute timeou... 2019-07-21, ∼4535🔥, 0💬

List All Files in a Filegroup
How to List All physical Files in a logical Filegroup? In a large SQL Server Database, you may have multiple logical Filegroups. And a Filegroup may have multiple physical Files. To list all physical Files in a logical Filegroup, you need to join two system tables, sys.filegroups and sys.database_fi... 2019-07-09, ∼3979🔥, 0💬

What Is a SQL Server File
What Is a SQL Server File? A SQL Server File represents a physical file provided by the operating system to store information for a SQL Server Database. Every SQL Server Database uses 3 types of physical files: 1. Primary File - The primary data file contains the startup information for the database... 2019-07-14, ∼3929🔥, 0💬

What Is sys.filegroups?
What Is sys.filegroups view in SQL Server? sys.filegroups is a system view in a SQL Server Database that contains information about each logical filegroups used by the database. Each record in the sys.filegroups table represents a single SQL Server Logical Filegroup with the following key fields: na... 2019-07-14, ∼3611🔥, 0💬

Input Operation Test with VARCHAR Data Type
How to run an input operation test with INSERT statements on VARCHAR data type? If you want to test the INSERT statement performance with a variable record size using the VARCHAR data type, you can follow this tutorial. The VARCHAR data type uses a storage size of string length plus 2 extra bytes. C... 2019-07-21, ∼2626🔥, 0💬

SQL Server System Views and Functions
Where to find tutorials on using SQL Server System Views and Functions related to data storage and I/O? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on using SQL Server System Views and Functions related to data storage and I/O. What Is a SQL S... 2019-07-14, ∼2477🔥, 0💬

Performance Impact of Higher Azure Service Tier
What is the Performance Impact of Higher Azure Service Tier? If you want to see the performance impact of Azure Service tier, you can re-run the same test script, fyi_block_insert.sql, on another Azure SQL Database with higher service tier. For example, run fyi_block_insert.sql, on a Azure SQL Datab... 2019-07-21, ∼2441🔥, 0💬

What Is a SQL Server Filegroup
What Is a SQL Server Filegroup? A SQL Server Filegroup represents a logical group of one or multiple physical Files. Each Filegroup will be used as a single logical unit to allocate storage space for database tables. A SQL Server Database must have one Filegroup defined as the Default Filegroup, or ... 2019-07-14, ∼2432🔥, 0💬

Input Operation Test with Large Records
How to run an input operation test with INSERT statements with Large Records? If you want to test the INSERT statement performance with large record sizes, we need to use a table with multiple columns, since one column of VARCHAR is limited to 8000 characters. Create the following SQL script, fyi_bl... 2019-07-21, ∼2383🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.