Hottest Questions Today

0

votes

1

answer

43

views

Sql addition query

modified 19 mins ago Rob Farley 15.9k

0

votes

0

answers

12

views

Order by id is slow

asked 7 hours ago Erasus 101

-1

votes

0

answers

17

views

I want to select many columns from many tables without foreign key

mysql join select code

modified 6 hours ago Vérace - get VACCINATED NOW 26.7k

4

votes

1

answer

59

views

DBCC CHECKDB on a user database: Time-out occurred while waiting for buffer latch type 2 for page (X:XXX), database ID 2

sql-server tempdb dbcc-checkdb timeout latch

answered 14 hours ago Sean Gallardy - Mostly Retired 22.2k

1

vote

0

answers

13

views

vacuum full shrinks newly created and ordered table size

postgresql

asked 11 hours ago edib 111

0

votes

1

answer

50

views

Is it possible to force SQL Server to create a wrong view?

sql-server view

modified 17 hours ago Tibor Karaszi 12.4k

1

vote

1

answer

21

views

Postgresql 10: Bitmap Heap Scan with exact heap block

postgresql execution-plan postgresql-performance

answered 11 hours ago jjanes 30.2k

-1

votes

1

answer

35

views

Why is SQL not considered a programming language?

terminology database-theory

modified 17 hours ago J.D. 20.7k

-2

votes

1

answer

20

views

How to calculate balance from debit and credit columns for mysql

mysql phpmyadmin

answered 12 hours ago Sikander Shahzad 1

0

votes

1

answer

12

views

what does the number in the "A_ROWS" column of the execution plan shows for operation "Index scan"?

oracle performance oracle-11g-r2 execution-plan plsql

answered 18 hours ago Andrew Sayer 1,627

0

votes

1

answer

28

views

mariadb innodb file per table data location

innodb mariadb datadir

modified 12 hours ago Rick James 66.1k

0

votes

0

answers

34

views

Trying to learn SQL and need help writing a super easy query

sql-server

asked 23 hours ago T. Koral 1

0

votes

1

answer

27

views

Is it safe to concatenate SQL statement if user input is not used directly?

postgresql

modified 22 hours ago Arthur Tarasov 751

0

votes

1

answer

21

views

Effect of reindex on read/replica

postgresql

modified 12 hours ago David Browne - Microsoft 38.1k

2

votes

1

answer

28

views

Why do we need a Unique key when we have a Primary key?

mysql primary-key rdbms

modified 3 hours ago Rick James 66.1k

0

votes

1

answer

70

views

Reducing memory grant waits in development environment

sql-server sql-server-2019

modified yesterday J.D. 20.7k

0

votes

0

answers

50

views

Is there performance penalty for many partition ranges? [duplicate]

sql-server partitioning

asked yesterday Avi 266

0

votes

1

answer

21

views

SQL Server 2019 pod K8S in CrashLoopBackOff. Could not open file .../master.mdf and Access is denied. Any ideas why?

sql-server

answered 22 hours ago NorDevTone 1

1

vote

1

answer

67

views

Why is a table scan for small data so slow [duplicate]

sql-server sql-server-2019

modified yesterday J.D. 20.7k

0

votes

1

answer

26

views

Mysql grant restricted to specific hours of a day

mysql select

answered yesterday danblack 6,068

-1

votes

1

answer

33

views

Feasibility of a MSSQL Read Only Replicas as ephermal containers?

sql-server

answered 15 hours ago Sean Gallardy - Mostly Retired 22.2k

0

votes

0

answers

35

views

Is a columnstore index appropriate when all columns are (mostly) unique?

sql-server sql-server-2016 columnstore index-design

asked yesterday Clay 101

0

votes

0

answers

14

views

Get top users with user type by amount

mysql greatest-n-per-group

modified 35 mins ago noushid p 101

-3

votes

3

answers

66

views

Query performance on different servers

sql-server query-performance execution-plan

answered 7 hours ago mikkel 33

0

votes

0

answers

21

views

Joining in NoSQL to get chat messages for a user

mongodb nosql cassandra

modified yesterday Jacqueline 1

2

votes

1

answer

38

views

Selecting gives one row, updating affects 2

mysql unique-constraint upsert

modified 20 hours ago Paul White♦ 65.1k

0

votes

0

answers

13

views

Select a dynamic list of columns in Postgres

postgresql dynamic-sql

modified yesterday a_horse_with_no_name 68.3k

5

votes

1

answer

124

views

sp_BlitzIndex missing index gone after removing unused indexes

sp-blitzindex

answered 2 days ago Brent Ozar 41k

1

vote

1

answer

30

views

Should I partition a database file for performance improvement if a file sits on RAID?

sql-server database-design t-sql raid

answered 2 days ago David Browne - Microsoft 38.1k

0

votes

2

answers

17

views

SQL Query to remove associated records that all don't meet certain condition

sql-server query

modified yesterday Andriy M 20.9k

0

votes

1

answer

25

views

What is the most efficient method to copy a linked server table into a SQL Server Database?

sql-server

yesterday user3115933 111

1

vote

0

answers

22

views

How to count number of occurrences of each key in a MongoDB collection efficiently (one pass?)?

mongodb aggregate count

modified yesterday rickhg12hs 111

0

votes

1

answer

38

views

Delete a record if it exists in SQL SERVER 2018

sql-server

answered 2 days ago Dan Guzman 23.4k

2

votes

1

answer

17

views

Set DB to single-user mode, now I cannot open it in SMSS

sql-server-2016 ssms

answered yesterday chris 11

-1

votes

0

answers

26

views

Conditional Logic in a Table Trigger Best Practices

sql-server t-sql trigger

asked 2 days ago Tim 153

0

votes

3

answers

151

views

Will I need to fix fragmentation after shrinking a database full of only HEAPs?

sql-server fragmentation

modified Jan 20 at 11:33 Erik Darling 32.4k

-1

votes

1

answer

31

views

Efficiently storing polled objects in SQL

postgresql database-design

modified 2 days ago Amirfel 3

1

vote

0

answers

36

views

Postgres violates primary key constraint

postgresql

modified 2 days ago Erwin Brandstetter 144k

0

votes

0

answers

37

views

Mysql resetted after upgrading from 80025 to 80027

mysql ubuntu upgrade

asked 2 days ago Elikill58 103

0

votes

0

answers

47

views

Maxdop setting in SQL Server 2014 during index rebuild offline and online

sql-server index sql-server-2014

2 days ago

0

votes

1

answer

18

views

How to update a column with multiple row values for each group?

postgresql database-design postgresql-performance bulk-insert upsert

answered 2 days ago Gerard H. Pille 2,767

-1

votes

1

answer

20

views

ola hallengren on Azure SQL

azure ola-hallengren

answered 2 days ago MBuschi 2,915

1

vote

0

answers

34

views

Grant CREATE CREATE schema to user in SQL Server?

sql-server

2 days ago

0

votes

1

answer

34

views

Immutable dynamic sql functions

postgresql functions dynamic-sql postgresql-11

modified yesterday Erwin Brandstetter 144k

0

votes

0

answers

11

views

What is MySQL doing? There are no active queries and full utilization of disk

mysql mariadb amazon-rds

modified 12 hours ago Rick James 66.1k

0

votes

1

answer

47

views

sp_Blitz shows "write_conflict" from In-memory OLTP

sql-server sql-server-2019 sp-blitz

modified Jan 20 at 17:18 David Browne - Microsoft 38.1k

0

votes

1

answer

35

views

SqlPackage Import - How to chose vCore purchase model?

azure-sql-database azure sqlpackage

answered 2 days ago Arvind Shyamsundar 76

Top Questions

Looking for more? Browse the complete list of questions, or popular tags. Help us answer unanswered questions.