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

Tag: sp-configure

how to temporarily change the sql server settings in order to do a task and when finished revert back?

By adminPosted on January 14, 2023

Question : when I run the script below all at once I get this error message: Msg 15281, Level 16, […]

SET NOCOUNT Error in handling SQL call after upgrade

By adminPosted on December 21, 2022

Question : We are upgrading our test environment with a new server and updated version of Microsoft SQL Server and […]

Recent Posts

  • How to query the effective permission of sql login (windows and/or sql user)?
  • Many to many link tables with history? [closed]
  • Should I repeat UNIQUE constraint on similar multi-index?
  • Accessing the Oracle cloud with MySQL workbench [closed]
  • Count missing values in each column of the table in PostgreSQL
  • How to restore postgreSQL schema dump to schema with different name
  • How to preserve ID generated from a PRIMARY KEY when moving data into a new table?
  • Why Oracle doesn’t have nolock?
  • SQL Server : speed up this query
  • How to check there is enough disk space before overwriting a DB with restore command
  • Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?
  • copyInSerializer.AddInt32(i)
  • Grant privilege to see column names in null constraint violations when inserting in views
  • Mariadb Galera cluster empty set
  • MongoDB multi-datacenter deployment and shard keys
  • Why is my SQL Server query behaving differently on UPDATE than on SELECT?
  • Postgres: trying to fix some unicode encoding issues
  • ODBC can’t connect to internal MySQL without external network
  • Slow insert in SQL Server 2008
  • Drop partition scheme with orphan indexes

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