Viewing 15 posts - 1 through 15 (of 859 total)
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...
July 10, 2020 at 12:36 pm
Have a look this as well https://www.sqlserverblogforum.com/dba/tempdb-database-is-full/
July 2, 2020 at 4:47 am
Glad you have fixed and used EZConnect identifier.
January 14, 2020 at 5:12 pm
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...
January 14, 2020 at 5:09 pm
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/
January 14, 2020 at 1:50 pm
Is it possible to share the execution plan.
Have you find the code developer why it has added a maxdop hint.
January 14, 2020 at 1:46 pm
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...
January 14, 2020 at 12:19 pm
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...
January 14, 2020 at 10:21 am
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...
January 13, 2020 at 11:04 am
December 27, 2019 at 12:20 pm
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"...
December 21, 2019 at 12:55 pm
Copy only full backup only allowed in Secondary.
December 19, 2019 at 4:31 pm
I am not fully understand.
Which radio button you have on 'where should backup occur'?
December 19, 2019 at 11:30 am
My tempdb id getting full frequerntly , i need to find the spid which is causing tempdb full?
You can look this as well. https://www.sqlserverblogforum.com/dba/tempdb-database-is-full/
December 12, 2019 at 4:50 pm
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...
December 12, 2019 at 10:48 am