Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Tag: datatypes
Do varchar(max), nvarchar(max) and varbinary(max) columns affect select queries?
Question : Consider this table: create table Books ( Id bigint not null primary key identity(1, 1), UniqueToken varchar(100) not […]
Postgres metadata: get a list of all MATERIALIZED VIEW columns, with data type, INCLUDING array columns
Question : I need to get metadata about all MATERIALIZED VIEW columns, including their data type. I can do this […]
Low cardinality fields: integer or string
Question : A Ticket has the statuses: new in_progress on_hold closed I could make ticket.status a string (on_hold) or an […]
Oracle integer to number conversion
Question : According to the Oracle documentation, creating a table with a column of ANSI type INT, Oracle will convert […]
Shredding Query Plan XML For Potential Skewed Estimates – Data Type Conversions
Question : I’m using the below T-SQL to check for root level estimate skews in execution plans by pulling the […]
Designing a user authenication (Roles & Rights) module
Question : I am trying to model a User Authentication module for a MS SQL Server database that will be […]
Excel Import ID, Data Type Double
Question : I get a file from another department that contains an id column. The id column is mostly numbers, […]
What is a valid use case for using TIME WITH TIME ZONE?
Question : Along the lines of this related question: What is a valid use case for using TIMESTAMP WITHOUT TIME […]
What type of rows does `SELECT my_table FROM my_table` return?
Question : I sometimes encounter this SELECT statement (in JSON-related answers on stackexchanges): SELECT my_table FROM my_table; It seems to […]