Viewing 15 posts - 1,276 through 1,290 (of 2,497 total)
The root cause may be that bot instances are trying to listen on port 1433.
One way to diagnose if this is a likely cause is:
a) Can you connect to instance...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 26, 2009 at 3:12 am
do they really need that space?
As a PS, my main Vista partition at home has on it Vista, Office, and not a lot else. As far as I...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 26, 2009 at 3:03 am
should I/could I uninstall SP2 or hotfixes once SP3 is installed successfully
Each Service Pack and CU is cumulative. It always includes all the fixes that were included in the...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 26, 2009 at 2:51 am
What I have done with the space estimates for SQL Server is:
1) Look at what space gets used on the RTM install
2) Look at what additional space is used by...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 26, 2009 at 2:43 am
Regarding permanent space on the C: drive, just about all you can do is save a few 10MBs by deleting log files, etc.
I recommend moving the Windows /Temp folder to...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 25, 2009 at 9:18 am
I would not be surprised to see almost 4.7 GB in total added to C: drive for the RTM installs for the 3 instances you mention, plus almost 2.6 GB...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 25, 2009 at 5:44 am
Personally, I would use P Jone's suggestion.
As he says, this way you guarantee that taking a backup is not affected by network issues. The copy step could get affected...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 25, 2009 at 3:02 am
Another advantage of DTSBackup2000 is that it retains all your annotations and object layout within your package.
As far as I know, it is the only automated method that...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 25, 2009 at 2:45 am
GAC is "Global Assembly Cache"
Thanks
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 24, 2009 at 6:21 am
To some extent it does not matter how the OP was interpreted.
To me the key thing is that if the person who said they had lock escalation problems...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 24, 2009 at 6:20 am
You say you are getting many complaints of lock escalation.
How do the people who complain know that the problem is lock escalation? If they do not have access to...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 24, 2009 at 3:33 am
Google can help you find many scripts that can do this for you.
Also, the FineBuild product on CodePlex has a spScriptJobs stored procedure which you can use.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 24, 2009 at 3:21 am
You can run DTS packages completely unchanged in SQL Server 2005 and 2008, in both 32-bit and 64-bit editions.
You need to install the 'DTS Designer' component from the SQL Server...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 24, 2009 at 3:17 am
The SQL Server install places a large number of items into the Global Authorization Cache (GAC) which can only exist on the system drive. There are other files (such...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 23, 2009 at 4:32 am
People who read the editorial generally are aware that they are running database software and that it is likely to need patching.
There are countless applications out in the wild where...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 22, 2009 at 3:11 am
Viewing 15 posts - 1,276 through 1,290 (of 2,497 total)