1 2 3 4 5 6 > >>   Sort: Rank

UUID/GUID Validator
How to valid UUID/GUID strings? In order to help your programming or testing tasks, FYIcenter.com has designed this online tool for you to validate any given UUID/GUID string. All you need to do is to enter an UUID/GUID string and click the "Validate" button. Validation result will be displayed in t...
2019-07-19, 887👍, 1💬

💬 2019-07-19 Martin: As you say, the 13th hex digit specifies the version and thus must be one of the valid versions numbers 1,2,3,4 or 5. Your valid...

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, 121👍, 0💬

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, 117👍, 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, 115👍, 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, 114👍, 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, 114👍, 0💬

sqa.FYIcenter.com Links
Collections: UFT-QTP Tutorials JMeter Tutorials Test Management SQL Server Storage Online Tools QA Jobs Site Map Other Resources: Software QA Resources Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Regular Expression Link Directori...
2019-07-13, 964👍, 1💬

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

Show My IP Address and Host Name
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has designed this online tool. All you need to do is to click the "Show Me" button below. Your IP address and host name will be displayed in the result area. FYIcenter.com Lookup Result - Your IP address ...
2019-07-13, 2065👍, 2💬

💬 2019-07-13 Kiara Morris-Dadzie: please u can gave to me new card and thanks!

💬 2019-06-30 Mathemagician: -5! a-b is -5 !!!

MAC Address Validator
How to valid MAC addresses? In order to help your programming or testing tasks, FYIcenter.com has designed this online tool for you to validate any given MAC address. All you need to do is to enter a MAC address and click the "Validate" button. Validation result will be displayed in the result area....
2019-07-09, 200859👍, 18💬

💬 2019-07-09 FYIcenter.com: @Naga, we will update the tool to support "Period" notation format.

💬 2019-07-03 Naga: This tool is not validating "Period - Separated Hexadecimal notation" like below example 001.422.012.345

💬 2019-05-10 FYIcenter.com: @Gokcer, Currently this tool only validates them as hexadecimal digits. We will enhance it to respect IEEE 802 standards.

(More comments ...)

Test IP Address Generator
How to generate IP Addresses? To help you to obtain some IP addresses 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 IP addresses will be presented in...
2019-07-09, 38051👍, 4💬

💬 2019-06-29 FYIcenter.com: Okay. There is no JS injection found here!

💬 2019-06-24 9sec: nevermind

💬 2019-06-24 9sec: <script> alert("haha this website is vulnerable to js injection"</script>

(More comments ...)

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, 136👍, 0💬

What Is sys.objects
What Is sys.objects view in SQL Server? sys.objects is a system view in a SQL Server Database that contains information about each data object like a table or an index used by the database. Each record in the sys.objects table represents a single data object with the following key fields: name - sys...
2019-07-09, 125👍, 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, 116👍, 0💬

What Is a SQL Server Partition
What Is a SQL Server Partition? A SQL Server Partition represents a logical data storage space area that is used to store data for a table or other data objects. By default all records in a table are stored in a single Partition. You may configure a table as Partitioned with use multiple partitions,...
2019-07-09, 116👍, 0💬

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...
2019-07-09, 116👍, 0💬

Test Credit Card Number Generator
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing applications that take payments like an eCommerce Website. To help you to obtain some credit card numbers for testing purpose, FYIcenter.com has designed this online tool. All you need to do is to ent...
2019-07-08, 75620👍, 3💬

💬 2019-07-08 Test Test: test test

💬 2018-01-20 FYIcenter.com: That's good to know. Thanks!

💬 2018-01-16 Hugu: Great website! Helped me a lot!

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, 150👍, 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, 148👍, 0💬

Find the File IDs of a Given Table
How to find the File IDs of a Given Table If you are performing an I/O test on a specific table and want to use the fn_virtualfilestats() function to gather I/O statistics, you need to follow this tutorial to find which files is used to store a given table. To find out which files are used to store ...
2019-06-29, 134👍, 0💬

Join sys.allocation_units with fn_virtualfilestats()
How to join the sys.allocation_units system view with the fn_virtualfilestats() system function view? If you want to watch the I/O statistics of physical files related to a give table, you need to join sys.allocation_units system view with fn_virtualfilestats() as shown below: -- fyi_get_io_stats_by...
2019-06-29, 133👍, 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, 130👍, 0💬

Test Script for SELECT with CURSOR
Where can I get a SQL script to do I/O performance test with SELECT statement using CURSOR to loop through records? Here is a SQL script to do I/O performance test with SELECT statement using CURSOR to loop through records. It uses the fn_virtualfilestats() function table to calculate the I/O statis...
2019-06-11, 190👍, 0💬

Test Script for INSERT with MEMORY_OPTIMIZED
Where can I get a SQL script to do I/O performance test with INSERT statement using BIGINT with MEMORY_OPTIMIZED? Here is a SQL script to do I/O performance test with INSERT statement using BIGINT with MEMORY_OPTIMIZED. In this case, the table content should be cached in memory as much as possible. ...
2019-06-11, 169👍, 0💬

Test Script for INSERT with PRIMARY KEY
Where can I get a SQL script to do I/O performance test with INSERT statement using BIGINT with PRIMARY KEY? Here is a SQL script to do I/O performance test with INSERT statement using BIGINT with PRIMARY KEY. -- fyi_insert_primary_key.sql -- Copyright (c) FYIcenter.com DECLARE @Count INT SET @Count...
2019-06-11, 159👍, 0💬

1 2 3 4 5 6 > >>   Sort: Rank