Advanced Table Articles

Scripting Data in a QES table
Sometimes our support personalle will ask that you script a table for them so that they can recreate the data in their environments and test to make sure th...
Fri, 19 Jun, 2020 at 10:59 AM
What to do if the main administrator user name or password is lost
Open the HZS_System database in SQL Server Management studio with an administrator account and open the HZS_User table by right clicking as choosing "E...
Fri, 19 Jun, 2020 at 11:02 AM
Complete delete of test results for a particular test
THIS IS FOR YOUR TEST AND PILOT SYSTEMS ONLY - DO NOT RUN THIS IN YOUR LIVE ENVIRONMENT AS IT WILL CAUSE RESULTS TESTING DATA LOSS!!! A customer had setup ...
Fri, 19 Jun, 2020 at 11:04 AM
Missing Indexes SQL suggests to create
Please note that understanding indexes is very important before implementing any suggestions that these queries show.   Performance can be degraded by addin...
Fri, 19 Jun, 2020 at 11:06 AM
System Codes as of Jan 14, 2019
Finding the system codes in our online help might be faster than looking them up in SQL server with this query: select * from HQMS_SysCodes Results: S...
Sat, 20 Jun, 2020 at 6:34 AM
SQL Queries we like to use
We have put together a number of queries that we use frequently for data analysis and we'd like to share them with you! There may be remarked out line...
Sat, 20 Jun, 2020 at 6:40 AM
Query to show table disk size in SQL
SELECT     t.NAME AS TableName,     s.Name AS SchemaName,     p.rows AS RowCounts,     SUM(a.total_pages) * 8 AS TotalSpaceKB,     CAST(ROUND(((SUM(a.t...
Sat, 20 Jun, 2020 at 6:43 AM
Table details - Listing the tables in QES and their functional types
Run the following query in SQL Management Studio: SELECT objtype, objname, name, value FROM fn_listextendedproperty (NULL, 'schema', 'dbo&#...
Tue, 23 Jun, 2020 at 12:06 PM
How to translate values in the QES tables
When looking at the HQMS_Results, HQMS_serialLotAttributes and other tables that store the Value field that users enter in results into you need to do a bi...
Sat, 20 Jun, 2020 at 6:48 AM
Listing the tables in QES and their functional types
Run the following query in SQL Management Studio:   SELECT objtype, objname, name, value FROM fn_listextendedproperty (NULL, 'schema', 'dbo...
Sat, 20 Jun, 2020 at 6:49 AM