SQL Server Storage Tutorials

Q

Where to find answers for frequently asked questions (FAQ) on SQL Server Data Storage and I/O?

✍: FYIcenter.com

A

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 Azure SQL Database

Review Azure SQL Database Configuration

Use Query Editor on Azure Portal

Azure SQL Database Related Terminology

IOPS Tests on Azure SQL Database with INSERT

What Is IOPS (I/O Operations Per Second)

Table for IOPS Tests on INSERT Statements

Input Operation Test with INSERT Statements

Verify Azure SQL Database Storage Usage

Verify SQL Database DTU Usage

Input Operation Test with BIGINT Data Type

Input Operation Test with UUID Data Type

Input Operation Test with VARCHAR Data Type

Input Operation Test with Large Records

Performance Impact of Higher Azure Service Tier

"Execution Timeout Expired" Error on Azure Portal

"Your services were disabled" Error

SQL Server System Views and Functions

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()

I/O Tests on INSERT Statements

Use allocation_units for I/O Tests

Page Size Varies on Azure SQL Database

Page Size Varies on SQL Server 2016 Database

Use fn_virtualfilestats() for I/O Tests

fn_virtualfilestats() Not Useful on Azure SQL

fn_virtualfilestats() Not Useful on SQL Server 2016

Test Script for INSERT with BIGINT

Test Script for INSERT with PRIMARY KEY

Test Script for INSERT with MEMORY_OPTIMIZED

I/O Tests on SELECT Statements

Test Script for SELECT with CURSOR

No Reads on SELECT with CURSOR on SQL Server 2016

No Reads on SELECT with CURSOR on Azure SQL Database

Test Script for SELECT with BIGINT

SELECT with BIGINT on SQL Server 2016

SELECT with BIGINT on Azure SQL Database

Test Script for SELECT with PRIMARY KEY

SELECT with PRIMARY KEY on SQL Server 2016

SELECT with PRIMARY KEY on Azure SQL Database

Test Script for SELECT with MEMORY_OPTIMIZED

SELECT with MEMORY_OPTIMIZED Table on SQL Server 2016

SELECT Test Summary on SQL Server 2016

⇒ Introduction of Azure SQL Database

2019-07-19, 7383🔥, 0💬

💬 2025-06-10 shouldhavesleptmore: Yeah, this is a good tool.

💬 2024-10-05 red hacker: FD00:6512:DDD3::9JH2::CA6B

💬 2024-09-10 ali: 2a03:2880:f203:e5:face:b00c:0:4420]: 443

(More comments ...)

Test ISBN Number Generator
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter.com has designed this online tool. All you need to do is to enter the number of data items you need in the form below, and click the "Generate" button. The generated ISBN numbers will be presented in... 2021-08-25, ≈19🔥, 2💬

💬 2021-08-25 Xuan Ng: Thanks, it's good for me

💬 2020-09-30 Emmanuel Mwadime: It was good

ISBN Number Validator
How to valid ISBN numbers? In order to help your programming or testing tasks, FYIcenter.com has designed this online tool for you to validate any given ISBN number. All you need to do is to enter an ISBN number and click the "Validate" button. Validation result will be displayed in the result area.... 2019-03-26, ∼7641🔥, 2💬

💬 2019-03-04 meaningful comments.: meaningful comments.

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, ∼7384🔥, 0💬

sqa.FYIcenter.com Links
Collections: Selenium Tutorials UFT-QTP Tutorials JMeter Tutorials Test Management SQL Server Storage Online Tools Other Resources: SQA (Software QA) Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Regular Expression Link Directories... 2025-04-03, ∼6647🔥, 1💬

💬 2019-01-16 Gffg: Online test tools --> try!

Test UUID/GUID Generator
How to generate UUID/GUID strings? To help you to obtain some UUID/GUID strings for testing purpose, FYIcenter.com has designed this online tool. All you need to do is to enter the number of data items you need in the form below, and click the "Generate" button. The generated UUID/GUID strings will ... 2018-10-19, ∼4768🔥, 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, ∼2293🔥, 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, ∼2283🔥, 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, ∼2134🔥, 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, ∼1974🔥, 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.