Viewing 15 posts - 1,006 through 1,020 (of 2,497 total)
our servers are only 1 year old. So donot have other option.
You always have an option.
At the very minimum, you should do a risk assessment of an in-place upgrade. ...
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 21, 2010 at 3:42 am
SSRS is not cluster aware. Further, you cannot install a SSRS instance with the same name as the SQL DB instance, it must have a different name.
The /ACTION=InstallFailoverCluster process...
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 16, 2010 at 3:24 am
Outside of the SQL Server world, deduplication of data in backups is big business. It is the way that large organisations are making $M savings on storage costs.
But this...
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 16, 2010 at 3:15 am
You do this via Management Studio.
For xp_cmdshell, right-click on your instance name in the Object Explorer window and select Properties. You specify the xp_cmdshell settings on the Security tab.
For...
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 16, 2010 at 2:35 am
One possible scenario: Somewhere in your system the password of a domain account is saved, and a process is trying to do work using this account and password. 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 15, 2010 at 2:54 am
I was going to say raise this as a problem with Microsoft, then I saw you had moved the servers from another node and hoped you had cleaned out all...
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 14, 2010 at 6:55 am
I would definitely ask WHY the SQL Agent tasks are prohibited. The answer needs to be more than 'the auditor said so', as this just shows the auditor probably...
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 14, 2010 at 6:50 am
Is there some other way other than using vm ware Kindly specify with necessary step documents.
I suggest you get Perry's documents, they look very comprehensive.
If you want 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 9, 2010 at 3:26 am
There are no short-cuts to knowing what is the best configuration for your installation. You need to try things out to gain experience of what works best, or hire...
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 9, 2010 at 2:52 am
There is an INSTANCEID parameter that is supposedly usable to set your own value for .1, .2, etc. The drawback is you only have one value per run of...
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 1, 2010 at 3:27 am
The auto-restart feature in Agent is to allow Agent to restart on unexpected failures. It is not needed to get Agent to restart after a Cluster failover. 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 1, 2010 at 2:57 am
There are numerous people who have reported they cannot install .Net 3.5 SP1 on top of a .Net 2.0 installation. Typically this can happen if there has been a...
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
May 25, 2010 at 3:41 am
One aspect you need to consider is DR. We used to hold user documents outside the database in the file system, but as the document count grew to a...
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
May 25, 2010 at 3:26 am
SSIS and SSAS are normally kept together on the same server if you are using SSIS to access SSAS.
Are you really asking about Reporting Services (SSRS)?
If you are...
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
May 25, 2010 at 2:42 am
In your situation I would warn my management of the risks and unknowns, and try to manage their expectations.
IMHO you have too many variables to predict performance, CPU and I/O...
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
May 24, 2010 at 9:46 am
Viewing 15 posts - 1,006 through 1,020 (of 2,497 total)