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

Tag: sql-server-2012

Delete data from a specific partition in MS SQL 2012

By adminPosted on February 3, 2023

Question : I would like to delete data from a specific partition using the partition ID. I got queries to […]

Execute job every time database changes – execute job on each change-event

By adminPosted on February 3, 2023

Question : I have a transactional-replication running in my database, and I need to execute a service on my website […]

SSIS 2012 metadata not refreshing on re-deploy

By adminPosted on February 2, 2023

Question : I have three systems: DEV, UAT, PROD, all running SQL 2012 Enterprise. I have existing packages that hit […]

How to list the permissions on User-Defined Table Types?

By adminPosted on February 2, 2023

Question : I am using some user-defined table types. They are very useful. you can see information about them by […]

Index issue on upgrade from SQL Server 2000 to 2012

By adminPosted on February 1, 2023

Question : About 6 months ago, we upgraded a large .NET project from SQL server 2000 to 2012. (i know […]

Optimizing complex join predicates [closed]

By adminPosted on January 31, 2023

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

Why are virtual log files not always allocated in order?

By adminPosted on January 31, 2023

Question : Quarterly I check the VLF on all of my servers through CMS with a query from the tigertoolbox/Fixing-VLFs/ […]

How to grant permissions to allow anything inside a SQL Server schema?

By adminPosted on January 30, 2023

Question : I have a schema called training. I have a new role called training_modify. Here are the desired permissions […]

MS SQL Server Performance Issues After Enabling All CPU’s [closed]

By adminPosted on January 30, 2023

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Any possible way to encrypt SQL Server 2012 database or backup?

By adminPosted on January 30, 2023

Question : We don’t have SQL Server 2014 or later versions, so I can’t take advantage of the backup encryption […]

  • 1
  • 2
  • 3
  • …
  • 262

Recent Posts

  • Is it possible to create a PostgreSQL RLS Policy that depends on values from the table the policy applied on?
  • 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

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