Category: AI

Probably a Brand-New “CityElefant”/Class 471 Unit for the Slovak Railway Company

When I was travelling to Karvina yesterday, a rather unusual train was standing at the station. It was hauled by an “Iron” locomotive of the Slovak Railway Company (hereinafter SZS) Cargo and had only one passenger coach and no freight wagons. What made it unusual was that I had never seen before a “passenger train” …

Read More Probably a Brand-New “CityElefant”/Class 471 Unit for the Slovak Railway Company

How I Solved Using SQL Methods While Working Inside a Transaction

While debugging the Ggdag website, I ran into an interesting problem. The thing is, I use transactions there, and I was also using methods from the class MSStoredProceduresI. When I tried to get the number of rows in a table, it threw this error: “ExecuteNonQuery requires the command to have a transaction when the connection …

Read More How I Solved Using SQL Methods While Working Inside a Transaction

Which is better for storing empty values in SQL Server 2012 in terms of size – an empty string or null?

Testing methodology: 2 databases were created, each with a single table containing only an int column and an NVarChar(20) column. The first one always received NULL values in the NVarChar column, while the second database received empty strings. Once again, my goal here is to save as much space as possible. And the result? The …

Read More Which is better for storing empty values in SQL Server 2012 in terms of size – an empty string or null?