Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Sign up to join this community

Anybody can ask a question

Anybody can answer

The best answers are voted up and rise to the top

Explore our Questions

more tags

Active 3 Bountied Hot Week Month

0

votes

0

answers

10

views

Whats wrong in this SQL Query? I am trying to update a column value

sql-server mysql

asked 7 mins ago Ankit Kumar 101

1

vote

1

answer

20

views

VLF count suddenly growing and unable to reduce it

sql-server sql-server-2008-r2

modified 8 mins ago John aka hot2use 10.6k

4

votes

4

answers

3k

views

SSMS 2016 takes forever to bring up context menu for an index

sql-server ssms sql-server-2016

modified 26 mins ago user202230 11

2

votes

2

answers

67

views

Weird memory pressure for SQL Server 2016

sql-server sql-server-2016 memory

answered 56 mins ago John aka hot2use 10.6k

1

vote

1

answer

26

views

Is it better to have one instance of a continuously running agent job or to fire off the job multiple times throughout the day?

sql-server sql-server-2016 sql-server-agent jobs

answered 1 hour ago Tony Hinkle 5,946

19

votes

0

answers

497

views

Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY

sql-server optimization sql-server-2019

modified 2 hours ago trusha 103

1

vote

0

answers

13

views

MSSQL: Conditional noexpand hint for view that may be indexed or not

sql-server optimization materialized-view

asked 2 hours ago Ed Avis 127

0

votes

1

answer

17

views

Select images where ALL images are greater than pixel width

sql-server group-by

answered 3 hours ago Akina 10.5k

1

vote

2

answers

25

views

Permission denied when trying to install sp_blitz on in the master database in Amazon RDS

sql-server permissions amazon-rds sp-blitz

answered 3 hours ago Ramakant Dadhichi 1,960

2

votes

1

answer

24

views

sys.dm_db_file_space_usage not returning correct values in SQL 2019

sql-server dmv sql-server-2019

answered 3 hours ago Ianwork 71

2

votes

1

answer

57

views

Different execution plans in SQL Server for same query but different offset

sql-server execution-plan full-text-search sql-server-2019

modified 4 hours ago Hi4s 21

-1

votes

2

answers

28

views

SQL Server - Subquery in joins vs not

sql-server performance join query

answered 4 hours ago Tibor Karaszi 3,280

0

votes

0

answers

20

views

Entity Framework Core Linq versus raw SQL Performance

sql-server entity-framework

modified 5 hours ago liqSTAR 103

-1

votes

0

answers

32

views

Can't create availability group , big error message

sql-server availability-groups sql-server-2017 clustering

modified 6 hours ago McNets 19.6k

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled