The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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

1

answer

186

views

sqlserver lsalert job does not update it's out-of-sync counter

sql-server sql-server-2008 log-shipping standby

modified 1 hour ago mustaccio 12.5k

0

votes

1

answer

88

views

How can I monitor current IOPs usage in SQL server

sql-server

modified 1 hour ago Community♦ 1

0

votes

1

answer

4

views

Computed Column Operand type clash on Date Column When Checking For Null

sql-server t-sql table computed-column

modified 3 hours ago Dan Guzman 16.2k

2

votes

1

answer

83

views

SQL server slow query

sql-server query-performance optimization execution-plan

modified 3 hours ago Community♦ 1

0

votes

1

answer

44

views

Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?

sql-server sql-server-2008-r2 query-performance optimization hints

answered 7 hours ago David Browne - Microsoft 16.3k

1

vote

1

answer

210

views

NULL Agent Timing Out

sql-server replication

modified 7 hours ago Community♦ 1

3

votes

3

answers

109

views

SQL log file 2TB is not enough, now what?

sql-server transaction-log

modified 8 hours ago AMtwo 5,361

0

votes

1

answer

91

views

How to create SQL Server Agent Queued jobs?

sql-server perfmon

modified 8 hours ago Community♦ 1

4

votes

1

answer

271

views

Handling 'Variable not found' in a tokenised job step

sql-server sql-server-agent powershell

modified 11 hours ago Community♦ 1

0

votes

1

answer

20

views

GROUP BY with date ranges when values change but then change back

sql-server t-sql query gaps-and-islands

modified 13 hours ago Michael Green 16.6k

1

vote

1

answer

95

views

SSRS 2016 report is failing with 'EXCELOPENXML' render format error

sql-server ssrs

modified 13 hours ago Community♦ 1

0

votes

1

answer

27

views

Create a user on database A with a procedure from database B (with EXECUTE AS)

sql-server stored-procedures permissions security sql-server-2017

modified 15 hours ago Shekar Kola 965

-1

votes

2

answers

492

views

Appending a Unique “transaction id” to Audit table with Audit trigger

sql-server trigger

modified 16 hours ago Community♦ 1

0

votes

1

answer

94

views

User guest does not have permission to run DBCC checkprimaryfile (SMSS)

sql-server ssms

modified yesterday Community♦ 1

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled