1 2 3 > >>   Sort: Date

What Is sys.partitions?
What Is sys.partitions view in SQL Server? sys.partitions is a system view in a SQL Server Database that contains information about each data partition used by a data object in the database. Each record in the sys.partitions table represents a single data partition with the following key fields: par...
2023-07-10, 5818🔥, 1💬

💬 2023-07-10 Bernard: Give more info than copying ยต$ https://learn.microsoft.com/fr-fr/sq l/relational-databases/system-catalo g-views/sys-partitions-tr...

What Is sys.database_files?
What Is sys.database_files view in SQL Server? sys.database_files is a system view in a SQL Server Database that contains information about each physical files used by the database. Each record in the sys.database_files table represents a single SQL Server Physical File with the following key fields...
2019-07-14, 5313🔥, 0💬

SQL Server Storage Tutorials
Where to find answers for frequently asked questions (FAQ) on SQL Server Data Storage and I/O? Here is a collection of many frequently asked questions on SQL Server Data Storage and I/O with answers compiled by FYIcenter.com team: Introduction of Azure SQL Database What Is Azure SQL Database Create ...
2019-07-19, 4900🔥, 0💬

What Is sys.allocation_units
What Is sys.allocation_units view in SQL Server? sys.allocation_units is a system view in a SQL Server Database that contains information about each allocation unit of a data partition to a physical file. Each record in the sys.allocation_units table represents a single allocation of a data partitio...
2019-06-29, 4204🔥, 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, 3186🔥, 0💬

IOPS Tests on Azure SQL Database with INSERT
Where to find tutorials on IOPS Tests on Azure SQL Database with INSERT Statements? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on IOPS Tests on Azure SQL Database with INSERT Statements. What Is IOPS (I/O Operations Per Second) Table for IOPS...
2019-08-08, 2693🔥, 0💬

Page Size Varies on Azure SQL Database
What is the data page size on Azure SQL Database? To find out the data page size on Azure SQL Database, we can run the SQL script, fyi_page_insert.sql, presented in the last tutorial with different @Size on Azure SQL Database. The following table shows the summary of the test results. The PARTITION ...
2019-05-12, 2317🔥, 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, 2253🔥, 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, 1959🔥, 0💬

I/O Tests on INSERT Statements
Where to find tutorials on testing I/O Tests on INSERT Statements on SQL Server Database? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on testing I/O Tests on INSERT Statements on SQL Server Database. Use allocation_units for I/O Tests Page Siz...
2019-06-29, 1825🔥, 0💬

What Is fn_virtualfilestats()
What Is fn_virtualfilestats() function view in SQL Server? fn_virtualfilestats() is a Transact-SQL function view that returns I/O statistics for database files, including log files. In SQL Server, this information is also available from the sys.dm_io_virtual_file_stats dynamic management view. fn_vi...
2019-06-29, 1762🔥, 0💬

Use Query Editor on Azure Portal
How to use Query Editor on Azure Portal? Query Editor on Azure Portal is nice client tool that allows you to run SQL queries to your Azure SQL database. 1. Login to your Azure Web portal. 2. Search and select your Azure SQL Database name "fyi_db". You see a summary information of your database. 3. C...
2019-07-28, 1617🔥, 0💬

Page Size Varies on SQL Server 2016 Database
What is the data page size on SQL Server 2016 Database? To find out the data page size on SQL Server 2016 Database, we can run the SQL script, fyi_page_insert.sql, presented in the last tutorial with different @Size on SQL Server 2016 Database. The following table shows the summary of the test resul...
2019-05-12, 1596🔥, 0💬

Introduction of Azure SQL Database
Where to find tutorials on Introduction of Azure SQL Database? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on Introduction of Azure SQL Database. What Is Azure SQL Database Create Azure SQL Database Review Azure SQL Database Configuration Use ...
2019-07-18, 1586🔥, 0💬

Table for IOPS Tests on INSERT Statements
How to design a database table to perform IOPS tests on INSERT Statements? In order to for perform IOPS tests on INSERT Statements, we should start with a simplest table first using minimum database functionalities. Here is an example of database table, FYI_INT, with only 1 column: CREATE TABLE FYI_...
2019-08-08, 1550🔥, 0💬

What Is IOPS (I/O Operations Per Second)
What Is IOPS (I/O Operations Per Second)? IOPS (I/O Operations Per Second) is a measurement on how fast a data storage device can perform read and write operations. IOPS is not a throughput measurement, it only gives you the total number of I/O operations. Throughput can be estimated by multiplying ...
2019-08-08, 1532🔥, 0💬

Create Azure SQL Database
How to create an Azure SQL Database? If you have subscription account with Microsoft, you can follow this tutorial to create an Azure SQL Database with Azure Web portal. 1. Login to your Azure Web portal. 2. Select Create a resource in the upper left-hand corner of the Azure portal. 3. Select Databa...
2019-07-21, 1461🔥, 0💬

Verify SQL Database DTU Usage
How to verify Azure SQL Database DTU Usage? You can follow this tutorial to verify Azure SQL Database DTU usage. 1. Login to your Azure Web portal and open the Azure SQL Database, "fyi_db". 2. Click "Query editor" in the left menu and run the fyi_int_insert.sql script with @Count = 50000. 3. Wait fo...
2019-07-30, 1460🔥, 0💬

"Your services were disabled" Error
Why am I getting the "Your services were disabled" error while running a query on Azure SQL Database? You are getting the "Your services were disabled" error, because you have reached the spending limit configured on your Azure subscription. For example, let's assume that your subscription has a $1,...
2019-07-21, 1424🔥, 0💬

What Is Azure SQL Database
What Is Azure SQL Database? Azure SQL Database is the intelligent, scalable, cloud database service offered by Microsoft on their Azure cloud platform. Main features of Azure SQL Database are: Frictionless database migration with no code changes at an industry leading TCO Built-in machine learning f...
2019-07-04, 1422🔥, 0💬

Input Operation Test with INSERT Statements
How to run an input operation test with INSERT statements? You can put an INSERT statement in a WHILE loop to run an input operation test as shown in this tutorial. Create the following SQL script, fyi_int_insert.sql: -- fyi_int_insert.sql -- Copyright (c) FYIcenter.com DECLARE @Count INT SET @Count...
2019-07-30, 1403🔥, 0💬

fn_virtualfilestats() Not Useful on SQL Server 2016
Why is fn_virtualfilestats() not giving correct write counter values on SQL Server 2016? If you run the SQL script, fyi_insert_write.sql, presented in the last tutorial with different @Count and @Size on SQL Server 2016, you will see that the fn_virtualfilestats() function view is giving incorrect w...
2019-05-12, 1402🔥, 0💬

Verify Azure SQL Database Storage Usage
How to verify Azure SQL Database Storage Usage? You can follow this tutorial to verify Azure SQL Database storage usage. 1. Login to your Azure Web portal and open the Azure SQL Database, "fyi_db". 2. Click "Query editor" in the left menu and run the fyi_int_insert.sql script with @Count = 50000. It...
2019-07-30, 1395🔥, 0💬

What Is OBJECT_ID()
What Is OBJECT_ID() function in SQL Server? OBJECT_ID() is a system function in a SQL Server Database that returns the object_id value from the sys.objects table for a given object name. The following query will return the same result: SELECT OBJECT_ID('ADDRESS') AS object_id 211197 SELECT object_id...
2019-07-09, 1354🔥, 0💬

1 2 3 > >>   Sort: Date