dba-developer Image

dba-developer

question
Jeff Moden avatar image
Jeff Moden commented Default

max degree of parallelism

dba sqlserver dba-developer sql2016

0 Likes

0Answers

1 Comment

question
mrelfinal avatar image
mrelfinal asked Default

Preguntas para un DBA (help)

dba dba-developer

0 Likes

0Answers

0 Comments

question
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered Default

The waiting tasks in activity monitor shows there are 4 tasks always in waiting states.

sql performance dba dba-developer waits

1 Like

1Answer

0 Comments

question
trangle avatar image
trangle answered Default

Which are different between XSN in dm_tran_active_snapshot_database_transactions and dm_tran_version_store?

t-sql sql server 2012 dba-developer

1 Like

2Answers

0 Comments

question
sajikumar.vk avatar image
sajikumar.vk answered Default

DeadLock Issue

dba sqlserver2012 deadlock dba-developer

0 Likes

5Answers

1 Comment

question
anthony.green avatar image
anthony.green answered Default

restrict the access of the user if he is accessing the SQL server from Microsoft office

sql-server-2008 sql sql server 2012 dba-developer

0 Likes

1Answer

0 Comments

question
Sathyanath avatar image
Sathyanath asked Default

BCP Error SQLState = S1000, NativeError = 0 , Unable to open BCP host data-file

sql-server-2008-r2 sql server 2012 dba sql query dba-developer

0 Likes

0Answers

0 Comments

question
Sathyanath avatar image
Sathyanath published Default

Column level decryption returns NULL value at my destination DB, am using export/import to transfer my encrypted data between servers

sql ssis sql-server-2012 dba dba-developer

0 Likes

0Answers

0 Comments

question
hanife464464 avatar image
hanife464464 asked Default

Can you please suggest few of the techniques/procedures that we should do on database to run the system without any harm and to save from danger situations and to identify it before as like prior intimation?

sql-server-2008 database dba administration dba-developer

0 Likes

0Answers

0 Comments

question
Oleg avatar image
Oleg commented Default

Could you help me on creating a better maintenance plan

dba maintenance-plans dba-developer ola-hallengren

1 Like

0Answers

2 Comments

question
ThomasRushton avatar image
ThomasRushton answered Default

SQL server becomes slower when i copy backup files to another server

sql-server performance dba network dba-developer

1 Like

3Answers

1 Comment

question
cornpoppy avatar image
cornpoppy edited Default

Any ideas on why Query-two would run so slow ?

dba query-results query-plan dba-developer query-tuning

0 Likes

1Answer

0 Comments

question
DazyParker avatar image
DazyParker answered Default

Error message in restoring database

backup dba restore dba-developer error-log

This question has an accepted answer. Accepted

0 Likes

3Answers

0 Comments

question
cornpoppy avatar image
cornpoppy edited Default

SQL server maintenance plan Cannot rebuild clustered index offline?

sql-server-2012 dba maintenance-plans dba-developer

0 Likes

1Answer

0 Comments

question
Wilfred van Dijk avatar image
Wilfred van Dijk answered Default

Database maintenance plan update statistics error

sql-server dba maintenance-plans dba-developer

0 Likes

1Answer

0 Comments

21 Posts
2 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.