Good day experts,

I added a second mdf file to my database but the second file is not writing any data.

Am i missing something? i am using standard 2014 edition...

Have a look this as well https://www.sqlserverblogforum.com/dba/tempdb-database-is-full/

Glad you have fixed and used EZConnect identifier.

Hi Jeff,

Waiting for Stairway. Do you have any threshold, which should be rebuild and reorganize (OR) it depends on their own system and test case.

I could have some of VLDB...

Do you have TNS entry and have you tried to do Tnsping.

This may help: https://www.sqlserverblogforum.com/dba/test-connection-failed-because-of-an-error-in-initializing-provider-oracle-client-and-networking-components-were-not-found/

Is it possible to share the execution plan.

Have you find the code developer why it has added a maxdop hint.

It could be a PSP issue, do you capture the execution plan to compare each time of run high vs low time taken.

What is the SQL version are you using...

Hi Guys,

I have created a script to rebuild indexes which is in the attachment-

NOW - Please review the procedure and let me know if there is need for any...

Hello,

I am running a server and I was telling my colleagues that the amount of database has hardly nothing to do with the speed of the server. Basically we...

1. No, we cannot downgrade.
2.  Yes, you can from lower to higher version.

Here's my scenario:

I have only one Full backup job running on Primary Node.

When the Node fails to Secondary, backup job does nothing, but as suggested if I add "copy_only"...

Copy only full backup only allowed in Secondary.

I am not fully understand.

Which radio button you have on 'where should backup occur'?

You can look this as well. https://www.sqlserverblogforum.com/dba/tempdb-database-is-full/

OK after reading the article i pretty much understand the way the logs work...

the option to truncate the log file is deprecated after sql server 2008, so the way...