Advanced Table Articles
Sometimes our support people will ask that you script a table for them so that they can recreate the data in their environments and test to make sure things...
Fri, 23 Apr, 2021 at 5:15 PM
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
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
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
Finding the system codes in our online help might be faster than looking them up in SQL server with this query: Select type, [Parent SysCodeID], [Parent Sy...
Tue, 19 Jan, 2021 at 1:44 PM
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 lines...
Sat, 20 Jun, 2020 at 6:40 AM
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
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
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
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