Viewing 15 posts - 31 through 45 (of 572 total)
This may help you out:
https://www.sqlserverlogexplorer.com/error-5171-mdf-is-not-a-primary-database-file/
November 28, 2018 at 12:54 am
The cause of getting SQL error 824 are many. Hardware issue, Corrupt or damaged MDF/NDF file or any discrepancies in SQL file system are some of the reason of getting...
November 26, 2018 at 12:37 am
This may help you out:
http://www.macaalay.com/2011/12/19/the-easy-way-of-changing-collation-of-all-database-objects-in-sql-server/
November 23, 2018 at 5:43 am
Check this out:
https://sqlwithmanoj.com/tag/memory_optimized_data/
November 16, 2018 at 11:31 pm
Recieve Side Scaling enables the network load from a network adapter to be distributed across multiple CPUs in a multiprocessor computer. We disabled it to prevent it from...
November 16, 2018 at 11:10 pm
You can encrypt SQL database objects like functions, stored procedures, triggers using WITH ENCRYPTION option along with the CREATE script. Beaware of fact that procedures once encrypted, there is no...
November 13, 2018 at 10:54 pm
I had this issue in SQL Server 2012. I fixed my issue by enabling 'Relocate all files to folder' option under the 'File' section in Restore Database.
Or may be...
November 11, 2018 at 9:34 pm
To resolve the problem, check FTData folder path set in the registry – is the path valid, does the SQL Server Service has enough permissions on that folder, etc....
October 31, 2018 at 1:07 am
Look at this, this may help you out.
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-2017
https://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/
October 29, 2018 at 11:33 pm
Look your SQL error logs then start up your cmd prompt window and Ping -aIPADDRESSGOESHERE. You will get a result saying "pinging machine name with 32 bytes of data", find...
October 29, 2018 at 11:04 pm
Microsoft SQL error 924 occurs when an attempt is been made to access the database by another user which is set as a single-user mode. Identify the currently running session...
October 29, 2018 at 12:50 am
Look at this,It may help you out:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-replicated-databases?view=sql-server-2017
October 29, 2018 at 12:30 am
Check the settings of min and max server memory. If the value of maximum server memory is close to min server memory, then increase the max server memory value. Check...
October 23, 2018 at 6:49 am
Here is how can you monitor slow SQL running queries:
https://www.red-gate.com/simple-talk/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/
and here is how can you monitor your SQL Server database effectively:
https://www.red-gate.com/simple-talk/sql/database-administration/eight-steps-to-effective-sql-server-monitoring/
October 23, 2018 at 6:29 am
There could be various reasons of getting this error either the network connection is bad and corrupts the data sent over it or the application uses client API...
October 22, 2018 at 3:56 am
Viewing 15 posts - 31 through 45 (of 572 total)