|
Programming is thinking, not typing |
|
Bertrand Meyer's article "Making sense of agile methods" (PDF, November 2017 on author site, copy on this site)
Russian translation published in "Open systems" magazine N°2-2018 "Об Agile по гамбургскому счету"
Some citations (I completely agree according to my experience).
Everything will look fine until you suddenly discover that …
C++11 has introduced the move semantic which can also be used in containers instead of "old-school" pointers. The specific containers owning objects have been proposed earlier by third-party libraries like Boost (for example, ptr_map or ptr_vector).
The goal of the test is to compare the speed of manipulations …
SQL Server Profiler has the template "locks" that is intended especially to trace deadlock. Let's try to simulate and catch a deadlock situation.
Suppose the test database is named test. Create two tables and feed them some data.
USE test;
CREATE TABLE dbo.invoices (
id int NOT NULL,
num nvarchar …Update. Since the version 2016 SQL Server supports anonymous constraint declaration:
CREATE TABLE #temp_table (
id1 int NOT NULL,
id2 int NOT NULL,
name1 nvarchar(100),
name2 nvarchar(100),
PRIMARY KEY (id1, id2),
UNIQUE (name1, name2)
);
For earlier versions the solution is below.
Local temporary tables are isolated in the scope …
In the case of linked circular list you need to add some checks to avoid memory corruption.
Full example (compiled OK with GCC 8.x)
#include <iostream>
#include <cstdlib>
struct Node
{
Node(Node* prev, int val)
: prev(prev), next(NULL), value(val)
{ }
Node *prev, *next;
int value;
};
void clear_list(Node …Hash indexes are used as entry points for memory-optimized tables; both features were introduced in SQL Server 2014. Let's look at index performance in scenario "key-value store".
The table stores a significant volume (about 10 millions rows) of pairs key-value. The key is of integer type and …
Unfortunately, SQL Server doesn't have a function like frac to extract the fractional part of number. The method is to subtract the integer part from the origin value.
DECLARE @n1 float, @n2 float, @n3 float;
SELECT @n1 = 123.456, @n2 = 234.567, @n3 = 456.789;
SELECT @n1 - round(@n1, 0 …Collection of methods to generate random string in a single SQL statement
On SQL Server the method is limited by 100 characters because of CTE recursion level limitation. The method has the performance issues when using in loops/joins because the table always have 100 rows …
This small example shows how to synchronize the data of two tables using the MERGE statement
CREATE TABLE table1 (id int NOT NULL PRIMARY KEY, str_value nvarchar(50));
CREATE TABLE table2 (id int NOT NULL PRIMARY KEY, str_value nvarchar(50));
GO
INSERT INTO table1 (id, str_value) VALUES (1, 'Value 1 …The small test program shows how memory and file I/O operations can be accelerated using multiple threads.
The program uses