Posted by jpluimers on 2019/11/29
Endlich eine Sinnvolle Definition der 3 Leistungsarten: Wirk-, Blind- und Scheinleistung auch für Nicht-Elektroniker
[WayBack] leistungen.gif (746×746)
Source [WayBack] MTM-Mess- & Stromversorgungstechnik e.U.: Bibliothek – Elektro Humor
Via [WayBack] Erich K – Google+
–jeroen
Posted in Development, Electronics Development, Fun, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2019/11/29
[WayBack] ‘No’ your way to trust workshop slide deck:
Published on
via: [WayBack] Facilitated my ‘No’ your way to trust workshop today at Agile and Beyond #aab18 Happy that it was well received by the audience of … mostly speakers … – Marjan Venema – Google+
–jeroen
Posted in Conference Topics, Conferences, Event, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2019/11/29
Learn how to make a grill that you can carry in your pocket! Perfect for camping or hiking trips!
Source: [WayBack] How to make a pocket grill | DIY projects for everyone!
Via: [WayBack] There are lots of portable grills out there for camping and other outdoor adventures, but we’ve discovered that ‘portable’ usually means ‘luggable’. But… – The Owner-Builder Network – Google+
–jeroen
Posted in LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2019/11/28
[WayBack] sql server – I need a slow query on AdventureWorks (SQL 2005) – Stack Overflow:
Medium slow:
SELECT * FROM Sales.SalesOrderDetail s INNER JOIN Production.Product p ON s.ProductID = p.ProductIDVery slow:
SELECT * FROM Production.TransactionHistory th INNER JOIN Production.TransactionHistoryArchive tha ON th.Quantity = tha.Quantity
It is based on the output of [WayBack] sql server – Query to list number of records in each table in a database – Stack Overflow, which originally ommited tables starting with dt (as those were be used for the “Database Diagram” in the SQL Server 7/2000 era using tables like dtProperties), but which I adopted using:
object_id <= 255 as a criterion for SQL Server System Objects.The query below does not support SQL Server 2000, where you would have to use things like objectproperty, but since by now even the [WayBack] documentation has been retired on the Microsoft site, you need to read [WayBack] Get list of tables but not include system tables (SQL Server 2K)? – Stack Overflow
In the end, it filters out tables like dbo.sysdiagrams that are generated by SQL Server Management Studio (SSMS), which are SSMS System Tables, but technically not SQL Server System Tables.
select
s.name as SchemaName,
t.name as TableName,
i.name as indexName,
p.rows,
sum(a.total_pages) as TotalPages,
sum(a.used_pages) as UsedPages,
sum(a.data_pages) as DataPages,
(sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,
(sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,
(sum(a.data_pages) * 8) / 1024 as DataSpaceMB
from
sys.tables t
inner join
sys.schemas s on t.schema_id = s.schema_id
inner join
sys.indexes i on t.object_id = i.object_id
inner join
sys.partitions p on i.object_id = p.object_id and i.index_id = p.index_id
inner join
sys.allocation_units a on p.partition_id = a.container_id
where
t.is_ms_shipped = 0 -- not internal to SQL Server
and
(not exists (
select ep.major_id
from sys.extended_properties ep
where
ep.major_id = t.object_id and
ep.minor_id = 0 and
ep.class = 1 and
ep.name = N'microsoft_database_tools_support'
)
) -- not internal to SQL Server Management Studio
and
i.index_id <= 1
group by
s.name, t.name, i.object_id, i.index_id, i.name, p.rows
order by
s.name, t.name
The counts for the [WayBack] GitHub version of AdventureWorks is this:
Posted in Database Development, Development, Software Development, SQL Server | Leave a Comment »
Posted by jpluimers on 2019/11/28
A nice question and even nicer answer at [WayBack] delphi – Why is list of type TObjectList freed automatically after iteration? – Stack Overflow.
It comes down to the Spring4D collection classes expecting to be accessed using interface references because they descend from TInterfacedObject which also favours interface references over object references.
If you access them solely using object references, they start out with a reference count of 0 (zero). If an operation then first increases that to 1 (one), then decreases it back to 0 (zero), the collection instance gets freed.
A few nice tips and (sometimes opposing) opinions from the question/answer thread and the referencing G+ thread [WayBack] What do you think, +Stefan Glienke? ##Spring4D – Agustin Ortu – Google+ make them well worth reading.
Some:
TObjectList<TFuu>.Create, you should use TCollections.CreateObjectList<TFuu>.Spring.Collections in your uses clauseTCollections only return interface references and – more importantly – allow for code folding starting with Spring4D 1.2.TInterfacedObject because the reference counting can kick in and destroy your instance anywhere (or manually call _AddRef/_Release).System.Generics.Collections–jeroen
Posted in Conference Topics, Conferences, Delphi, Development, Event, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 