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

Ask Question

more tags

Active 2 Bountied Hot Week Month

1

vote

1

answer

20

views

Excluding log shipped DB from current database maintenance plan (Ola's solution)

sql-server log-shipping ola-hallengren maintenance-plans

modified 4 hours ago Paul White♦ 57.7k

0

votes

1

answer

22

views

Does SQL Server Support Parallel Bulk Inserts From Multiple Connections?

sql-server sql-server-2008 sql-server-2017 concurrency bulk-insert

modified 4 hours ago Paul White♦ 57.7k

0

votes

1

answer

29

views

Why is a Shared lock blocking on an IX lock when Read Committed Snapshot is enabled?

sql-server deadlock deadlock-graph

modified 4 hours ago Paul White♦ 57.7k

0

votes

1

answer

61

views

Omiting schema names to manage access to SQL Server databases more flexibly

sql-server application-design

modified 5 hours ago Paul White♦ 57.7k

0

votes

0

answers

17

views

Sql error number: 1236. Error Message: A transport-level error has occurred when receiving results from the server

sql-server network

asked 6 hours ago Vuong Nguyen 1

0

votes

1

answer

39

views

How to plan bring down the space used by databases to as low as possible

sql-server database-design sql-server-2014 compression

answered 9 hours ago SqlWorldWide 10.4k

5

votes

1

answer

362

views

Should Full Text Filter Daemon Service be a cluster resource?

sql-server sql-server-2016 full-text-search clustering failover

modified 10 hours ago Magier 4,433

0

votes

0

answers

9

views

Compare a document against millions of other documents to find similar documents

sql-server sql-server-2016 mongodb elasticsearch document-oriented

modified 12 hours ago Max Vernon♦ 62.6k

6

votes

0

answers

156

views

Changing collation of SQL Database in Production environment to minimize downtime

sql-server transactional-replication collation

modified 13 hours ago Avaruu5alus 1

2

votes

1

answer

59

views

Trigger to prevent update if existing value is higher than inserted value

sql-server sql-server-2014 trigger

modified 14 hours ago Solomon Rutzky 60.5k

1

vote

1

answer

64

views

PowerBI Service Account granting duplicate execute permissions on stored procedure almost constantly

sql-server sql-server-2014 permissions powerbi powerbi-report-server

modified 15 hours ago Max Vernon♦ 62.6k

4

votes

1

answer

395

views

Handling 'Variable not found' in a tokenised job step

sql-server sql-server-agent powershell

modified 15 hours ago Community♦ 1

2

votes

3

answers

302

views

Query to categorize rows based on a “time” column without using a CASE expression

sql-server t-sql performance optimization query-performance

modified 15 hours ago Max Vernon♦ 62.6k

3

votes

1

answer

442

views

Memory usage grows on SQL Server Analysis Services 2012 until cubes fail to process

sql-server

answered 16 hours ago mv ٠〳comment ٠〳answer 472

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled