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

Tag: sql-server-2014

Update table using values from another table in SQL Server

By adminPosted on February 5, 2023

Question : I have 2 table in my database. Table #1 ————————————————————————- | name | family | phone | email […]

Who is using my worker threads? SQL Server 2014 – HADR

By adminPosted on February 5, 2023

Question : We had recently a problem on our SQL Server 2014 HADR environment, where one of the servers ran […]

How to find column which causing “Conversion failed” error

By adminPosted on February 4, 2023

Question : I’ve run into quite a lot of issues specially when it comes to conversion errors: convert(datetime, [fieldname]) or […]

Getting a list of active objects that use cursors but don’t explicitly close/deallocate them

By adminPosted on February 2, 2023

Question : Sometimes our developers will write a query that uses cursors, but doesn’t close them out explicitly. I’m trying […]

sa doesn’t have permissions to other database through synonyms with the Service Broker

By adminPosted on January 31, 2023

Question : I’ve been trying to get this Service Broker and timers thing to work for over a week straight […]

How To Grant A User In AD Groups Which Is Denied To DML Commads, To Update On A Spesific Tables

By adminPosted on January 31, 2023

Question : I have a Active Directory user account named SQLQRY in my sql server. SQLQRY is permitted only read […]

Finding the row with the latest date for each row type

By adminPosted on January 30, 2023

Question : I’ve got an SQL database (SQLAzure V12 version running on Azure) that looks like the following: DECLARE @VehicleData […]

Querying system health data becomes slow as event volume increases

By adminPosted on January 30, 2023

Question : We get the data from system health XE from SQL server and load into table for later querying. […]

What is the date time format for msdb.dbo.agent_datetime scalar value function?

By adminPosted on January 29, 2023

Question : Looking at msdb.dbo.agent_datetime scalar value function. What date / time format is this expressed in, UTC? Same question […]

Wingdings font in SSMS’s column

By adminPosted on January 29, 2023

Question : I do want to create a column which should has check marks and cross marks. Here is the […]

  • 1
  • 2
  • 3
  • …
  • 182

Recent Posts

  • Should “Long Running with Low CPU” be expected for an SPROC that performs millions of INSERTS?
  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow

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