Snippet

Size all tables in volume

by

DECLARE @name VARCHAR(128) DECLARE @myList TABLE ([row] int, [id] int,[Name] VARCHAR(128)) ; DECLARE @myResult TABLE ([row] int, [Name] VARCHAR(128), [Value] VARCHAR(128)) ; INSERT INTO @myList ([row], [id], [name]) SELECT row_number() OVER(ORDER BY o.name), o.id, o.name FROM dbo.sysobjects o join sys.all_objects syso on o.id = syso.object_id where o.name like ‘f_uks_%’ and type_desc = ‘USER_TABLE’ DECLARE @total … Read more

Project Status

by

Create Table CREATE TABLE [dbo].[d_status]( [id] [int] IDENTITY(1,1) NOT NULL, [source_id] [int] NULL, [parent_code] varchar NOT NULL, [linked_id] [int] NULL, [created_date] [datetime] NULL, [modified_date] [datetime] NULL, [authored_by] varchar NULL, [sort_order] [int] NULL, [item_status] [int] NULL, [item_code] varchar NOT NULL, [item_desc] varchar NULL, [item_label] varchar NOT NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (STATISTICS_NORECOMPUTE = … Read more

Item status

by

Please see above a new Table for Status Firstly, is this in the correct schema ? as it is set to manage the status category of each of the d_dimension tables The layout is of my own devising, but is set to be the way I would create any entity/dimension and is of a form … Read more

Tables

by

Listings To assemble the sequence of historic entries for a property, you should find all historic entries sharing thesame UARN and sort them into ascending List Alteration Date. Entries that are alterations have HistoricFrom and To Dates. Entries that revise alterations will not. You can then add the current entry for the sameUARN to complete … Read more

SQL/MySQL/SQLite/NoSQL

by

MySQL is a fully featured RDBMS. An example would be enterprise system or websites. SQLite is also a RDBMS but a lightweight one, it doesn’t require it’s own process, clustering or user management unlike MySQL or others RDBMS. SQLite consist of a single file and a library to make your application interact with it. The … Read more

API

by

7 skills and experience to look for in API developers 1. Cross-platform development 2. API design 3. Front-end development 4. Different coding languages 5. Integration knowledge 6. API orchestration skills 7. Programming tools (Postman)