Viewing 15 posts - 1 through 15 (of 41 total)
Well that is mostly usual when developers are having direct write access to production databases specially the new joinees.
Any sort of script executions should be happening through the DBA's. Even...
October 29, 2019 at 3:44 pm
Probably your best bet would be to look at the SQL Instance settings of MAXDOP and Cost Threshold for Parallelism but these would be effective for all the queries.
Look...
November 28, 2018 at 3:06 am
To implement TLS or SSL encryption certificates are used. If your company has Enterprise Certificate Authority, you can request a certificate for SQL Server and then configure SQL Server to...
July 9, 2018 at 3:18 pm
July 9, 2018 at 5:41 am
Is the certificate installed on SQL Server ? If yes, then your connections will be encrypted since there is a verifiable server certificate.
Also it...
May 18, 2018 at 3:03 am
May 17, 2018 at 5:01 am
I would assume log backup file corruption. It could be either during the backup in the source or after copying to the destination.
>>Check for the log file size (sometimes...
May 16, 2018 at 9:17 am
As mentioned in earlier post, having multiple disk controllers is better for SQL Server. It is always good practice to separate your OS files, SQL Data files, Log files, TempDB...
May 16, 2018 at 8:43 am
April 5, 2018 at 4:37 am
You can check the below link which might be helpful for you in troubleshooting database mail issues.
Regarding the future date it shows - Microsoft...
April 3, 2018 at 4:40 am
That is a very large table that you intend to manage. SQL Server can definitely handle the table based on the underlying hardware thrown at it....
March 29, 2018 at 3:46 am
After having one default instance every SQL installation after that will be a named instance which will have a ' \ ' in the instance name. As suggested by March 22, 2018 at 10:19 am
March 19, 2018 at 8:04 am
Viewing 15 posts - 1 through 15 (of 41 total)