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

Tag: instance

Too many mysql instances. How to kill?

By adminPosted on January 26, 2023

Question : I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which […]

SSMS How do I open a new Query Window using Same Connection Instance of current Window

By adminPosted on December 21, 2022

Question : Coming from Oracle I have discovered that SSMS connects slightly different than Oracle’s SQL Developer. Oracle you click […]

Availability groups multiple instance, multiple listeners [closed]

By adminPosted on December 10, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

How to determine which one is my default instance in MS SQL Server?

By adminPosted on December 9, 2022

Question : I have two instances in my server and I want to know which one of them is the […]

SQL Server Ignoring Instance name when using port number of different instance

By adminPosted on August 9, 2022

Question : I saw a strange case recently and still clueless on what should be the reasoning behind it. On […]

Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?

By adminPosted on August 2, 2022

Question : If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it […]

TSQL Solution to backup ALL databases on ALL instances of a server?

By adminPosted on July 14, 2022

Question : I’m pretty sure what I’m wanting with my current implementation is impossible, the sys.databases catalog view which is […]

Upstart script in ubuntu for mongodb

By adminPosted on June 24, 2022

Question : I am new to linux and mongodb. I’ve already installed mongodb on ubuntu but I want to run […]

How can MySQL return an empty row matching a given table’s schema, given the table name as an input string?

By adminPosted on May 29, 2022

Question : How can a query or procedure return an empty copy of a new record? Ideally suited for objects […]

How to find out the service accounts for each of my instances in the current server?

By adminPosted on May 25, 2022

Question : I have the following query that gives me one line for each sql server instance installed in the […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring
  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication

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