crossjoin.co.uk

Data Type Conversions For SQL Server Sources And Query Folding In Power Query

It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have blogged about ...
GitHub

data-type-precedence-transact-sql.md

When an operator combines expressions of different data types, the data type with the lower precedence is first converted to the data type with the higher precedence ...
GitHub

data-type-mapping-in-itabledefinition.md

When creating tables by using the ITableDefinition::CreateTable function, the OLE DB Driver for SQL Server consumer can specify [!INCLUDEssNoVersion] data types in the pwszTypeName member of the ...
Microsoft

Working with time series data in SQL Server 2022 and Azure SQL

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...