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

Tag: keyboard-shortcuts

SSMS shortcut to comment/uncomment a specific part of the query?

By adminPosted on July 11, 2020

Question : I’m looking for an option to comment/uncomment a particular part of the query with the Slash Star Comment […]

Shortcut for ‘Select Top 1000 Rows’

By adminPosted on April 10, 2020

Question : There has to be a better way! When writing a subquery code I need all the rows listed […]

Recent Posts

  • Join 3 tables with where and sorting clauses
  • Strange performance of a top-N query with Postgres
  • How to get all the users on a database with SA access?
  • mysql threads running high issue for Percona Mysql 8.0.16
  • Design Tagging module in the database
  • Environment variable for two oracle_home
  • Improve the insertion rate of mongo sharded cluster
  • How to hint Remote Scan operator to estimate more than 10000 rows?
  • Understanding MAXDOP behaviour for queries going parallel
  • Disk space efficient foreign key index for insert intensive scientific database?
  • Refresh Materialized View impact on the DB
  • Workflow for SQL Server + Azure SQL development?
  • Execution Plan is NOT using INDEX, It uses Table Scan
  • Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?
  • Optimizing a query which runs through all hours in a day
  • Implications of adding a trigger on production database
  • End of file reached. Error 38 in SQL. Passes verification checks
  • Can not add list partitions
  • 30 days rolling sum as base for fee calculation. Faster solution
  • Add a suffix to duplicates on PostgreSQL

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