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

Tag: index-design

Schema required to find a record in a table with null values

By adminPosted on April 12, 2022

Question : I have the following table. ID Country City Street No 1 UK 2 2 Lon 3 Oxf 19 […]

Is it needed to add additional column to make this clustered index unique?

By adminPosted on March 9, 2021

Question : I have a table as listed below in SQL Server 2012. There is a clustered index on RequisitionID […]

Recent Posts

  • PostGIS Intersects Query takes lot of time to get the result
  • How do you run T-SQL commands on multiple servers from one place?
  • MongoDB Primary Member of Replica Set High Memory Usage
  • Understanding Variations on Multiple Joins
  • Help Improving My Database Design
  • barcode inventory design – transaction or master?
  • Clustered indexed fields hash matching. Does it matter?
  • Can’t connect to SQL Server through SSMS remotely
  • Problem with data insertion in Oracle table from SQL Server table
  • MySQL Database Archive
  • Two “Connect SQL” permissions in SQL Server 2012
  • How to improve INSERT speed in large table that has unique constraint
  • MySQL/MariaDB data directory backup
  • How to get goup concat of count value using sub query
  • Index Seeks cost of OR operator
  • Oracle SQL create view privileges
  • Can I get results from a Postgres query that I got disconnected from?
  • How do I return all column values for the recently inserted row/rows?
  • SQL Server: performance of IDENTITY vs INT as primary key
  • Database for opening times of locations

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