Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: datatypes

Why does Oracle consider a larger number to be smaller? [closed]

By adminPosted on February 3, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

Do varchar(max), nvarchar(max) and varbinary(max) columns affect select queries?

By adminPosted on February 2, 2023

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

By adminPosted on January 31, 2023

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

By adminPosted on January 29, 2023

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

By adminPosted on January 27, 2023

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

By adminPosted on January 26, 2023

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

By adminPosted on January 25, 2023

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

By adminPosted on January 14, 2023

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?

By adminPosted on January 14, 2023

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?

By adminPosted on January 12, 2023

Question : I sometimes encounter this SELECT statement (in JSON-related answers on stackexchanges): SELECT my_table FROM my_table; It seems to […]

  • 1
  • 2
  • 3
  • …
  • 30

Recent Posts

  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding