Hottest Questions Today

0

votes

1

answer

14

views

Order by starting from “the middle” in a windowing function

answered 1 hour ago Stephen Morris - Mo64 2,372

0

votes

0

answers

20

views

Can a database have an unnamed row?

database-design primary-key table

asked 6 hours ago jkbliss 1

0

votes

2

answers

31

views

Check if column has same value in any row

sql-server sql-server-2019

modified 9 hours ago J.D. 13.9k

0

votes

0

answers

13

views

Mysqld draining memory, using way more then assigned and not giving any back

mysql innodb mariadb debian

modified 7 hours ago dotSpokane 1

0

votes

1

answer

21

views

Oracle: Keeping exact db clone synced up in real time

oracle

answered 1 hour ago Phill W. 4,578

0

votes

1

answer

42

views

SQL sql subquery with SUM for totals

sql-server subquery sum

modified 8 hours ago Michael Green 20.9k

1

vote

1

answer

49

views

How to prevent/detect fetching data from another database on same server

sql-server sql-server-2019

answered 10 hours ago HandyD 8,012

4

votes

3

answers

471

views

MS SQL Server 2014: which stored procedure is my error in?

sql-server sql-server-2014 stored-procedures error-handling

answered yesterday Craig Efrein 9,241

0

votes

1

answer

22

views

How do I add a where statement at the end of query for a column that does not have a table to reference from?

postgresql column-alias

answered 14 hours ago nbk 5,642

0

votes

0

answers

27

views

While testing our workload on SQL 2019 we experience much higher CPU utilization compare to the same test on SQL 2014

performance sql-server-2019 cpu

asked 16 hours ago SQL_Guy 521

0

votes

0

answers

19

views

MongoDB - Robo3t: Failed to do query, no good nodes, Field 'cursor' must be a nested object

mongodb

modified 1 hour ago Mr. L 1

13

votes

1

answer

2k

views

Is this an error in SQL Server's documentation for ROLLBACK?

sql-server transaction rollback documentation

modified 21 hours ago Solomon Rutzky 62.1k

0

votes

0

answers

13

views

Index on json list

postgresql index json

modified 15 hours ago a_horse_with_no_name 62.5k

1

vote

0

answers

12

views

Many to many relationship, select rows based on values in list

mysql select many-to-many

asked 15 hours ago Oen44 111

2

votes

1

answer

37

views

Do SQL OS Background Tasks Yield to Normal Tasks?

sql-server performance-tuning sql-server-2019 cpu

answered 18 hours ago Stephen Morris - Mo64 2,372

0

votes

1

answer

51

views

Powershell script executed by SQL Server doesn't take effect

sql-server permissions powershell xp-cmdshell

modified 1 hour ago Francesco Mantovani 509

-1

votes

0

answers

23

views

Index with mixed int and char columns is slow

mysql index varchar

modified 20 hours ago Kohjah Breese 143

0

votes

1

answer

15

views

How to find the counts of word occurrences in a column?

postgresql

answered 20 hours ago a_horse_with_no_name 62.5k

0

votes

0

answers

19

views

How do I write a query that gives me 2 results from the same table?

mariadb

asked 20 hours ago Adam 1

0

votes

2

answers

21

views

Finding “one of” entries to a composite key/index

mysql index composite-types

answered 22 hours ago Akina 14.5k

1

vote

1

answer

21

views

Select distance between cities in two directions

sql-server t-sql sql-server-2014

modified 23 hours ago J.D. 13.9k

0

votes

0

answers

18

views

Track usage of views and set up logging

sql-server t-sql

21 hours ago

0

votes

1

answer

24

views

How do I identify functional dependencies and normalize a table based on the attributes?

normalization dependencies

modified 21 hours ago Renzo 3,747

5

votes

1

answer

358

views

What happens when you change a heap into a clustered table in SQL Server?

sql-server clustered-index heap

modified yesterday David Browne - Microsoft 31.7k

0

votes

1

answer

11

views

How to get percentage after grouping?

mysql hadoop

answered 19 hours ago Jask 1

0

votes

1

answer

48

views

SELECT DISTINCT in extra space data from a single column ( no duplicates )

sql-server duplication distinct

answered 7 hours ago HandyD 8,012

0

votes

1

answer

23

views

MySQL return rows ONLY if ALL the rows in another table have a specified value

mysql mysql-5.7

modified 16 hours ago JYOTI RAJAI 701

0

votes

1

answer

27

views

Postgresql 13 pg_dump utility - pass a password through the Lazarus app in Windows

postgresql backup pg-dump

modified 2 hours ago noszone 1

0

votes

2

answers

42

views

Best way to determine Dev/Test/Prod environment in MS SQL Server 2012+?

sql-server

answered 21 hours ago Jonathan Fite 6,855

0

votes

0

answers

18

views

Cannot use 'STWithin' as it can't be found for type 'Microsoft.SqlServer.Types.SqlGeography' (SQL Server V14)

sql-server spatial

asked yesterday Columbo 123

2

votes

0

answers

23

views

Autotask 'auto optimizer stats collection' and scheduler jobs logging

oracle statistics

asked yesterday Seb 21

0

votes

1

answer

41

views

I am wanting to use UDTT in my database, but we have CLR turned off, and according to the docs for create type, all types require a CLR assembly

sql-server sql-clr user-defined-type user-defined-table-type

modified yesterday David Browne - Microsoft 31.7k

0

votes

1

answer

11

views

MySQL - Call a View inside a Stored Procedure

mysql

answered yesterday Phill W. 4,578

0

votes

0

answers

13

views

How to setup replication of 150Gb mysql database

mysql mariadb

modified 22 hours ago yujin1st 101

0

votes

0

answers

33

views

Convert a numeric number to a letter PostgreSQL

postgresql postgresql-performance dynamic-sql

modified yesterday Lennart 19.6k

0

votes

1

answer

15

views

MySql ORDER BY slow with join, fast as 2 queries

mysql query-performance order-by

answered yesterday Akina 14.5k

-2

votes

1

answer

24

views

Iterate through a list of strings In SQL scriipt

oracle scripting sqlplus

answered yesterday EdStevens 1,631

0

votes

1

answer

21

views

Transaction Log backup in MSSQL's HADR

sql-server

answered yesterday David Browne - Microsoft 31.7k

3

votes

2

answers

109

views

Query 2 tables without a join

postgresql

answered 2 days ago Quassnoi 321

0

votes

1

answer

17

views

Upgrading Operating System only. OS 2016 - 2019

sql-server-2017 upgrade windows-server windows-server-2019

answered yesterday Martin Cairney 377

2

votes

3

answers

92

views

Urgent help with TempDB log file growth mystery

sql-server performance sql-server-2014 transaction-log tempdb

modified 20 hours ago Aleksey Vitsko 3,141

0

votes

0

answers

42

views

Sql Server can't stop

sql-server

yesterday

2

votes

0

answers

30

views

Researching Performance Degradation on AO Secondary using MultipleActiveResultSets (MARS)

sql-server-2016 availability-groups

modified yesterday Craig Efrein 9,241

0

votes

2

answers

19

views

Passing parameters in MySql procedure with prepare execute

mysql stored-procedures sql-injection

modified yesterday Bill Karwin 5,946

1

vote

4

answers

94

views

Why can't you add an Identity to an existing colum in SQL Server?

sql-server alter-table identity

modified yesterday Charlieface 804

1

vote

1

answer

26

views

How is data of multi valued attribute say phone number of person relation is stored in table?

sql-server database-design restore

modified yesterday J.D. 13.9k

0

votes

0

answers

15

views

connect to remote PostgresDB through VPN

postgresql vpn

asked yesterday boldnik 101

Top Questions

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