Viewing 15 posts - 1,141 through 1,155 (of 2,497 total)
It has worked OK for me. It also works OK on W2008 R2.
You need to install Visual Studio 2003 SP1 (as documented in BOL) and SQL 2005...
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
November 12, 2009 at 6:07 am
I would be interested in knowing what the so-called JCL limitation is. With over 20 years mainframe experience it would be a new one for me (unless it is...
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
November 12, 2009 at 5:07 am
My experience is that if you have a transaction table that is significantly smaller than the master table and the master table is into the many millions of rows, then...
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
November 11, 2009 at 4:04 am
I agree that you absolutely must test this upgrade. If you just run it in production without any previous testing you should expect that your applications will not work...
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
November 9, 2009 at 5:58 am
It is not in itself wrong to have different fix levels for different components of SQL Server. If a new CU is issued and it contains no fixes 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
November 9, 2009 at 5:49 am
As Gift Peddie says, this is a known UI bug that should not occur more than once on a given machine. I have not done a SQL 2008 install...
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
November 9, 2009 at 5:42 am
My experience is that most standard interview questions, no matter what they are 'designed' to do, just arbitarily eliminate x% of applicants using a reason that could stand up 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
November 9, 2009 at 5:39 am
As I said in a previous post, the business expect IT to provide the most cost-effective service, and is not interested in our turf wars. Backup technology is moving...
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
November 6, 2009 at 2:40 am
I agree the right way to do this is to make SQL Server dependant on the SAN connectivity service. But if the SAN service reports it is started before...
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
November 4, 2009 at 4:25 am
You will have to build the two environments and try out your queries.
If you are going to make a purchasing decision as a result of the tests you should make...
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
November 4, 2009 at 4:12 am
If you want someone without sysadmin rights to use xp_cmdshell in SQL 2000, you need to set up a proxy account.
Books Online (BOL) gives good details on how...
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
November 3, 2009 at 2:37 am
Running the SP install with parameters /quiet and /allinstances should update all the SQL 2005 instances, plus the tools, on your server.
The same parameters apply for a Cumulative Update installation....
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
October 30, 2009 at 5:17 am
Security has changed in Windows 2008 and above. The problem you are seeing is not caused by SQL Server, but be Windows 2008.
You used to be able to add...
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
October 30, 2009 at 5:00 am
The post mentioning data type differences is right. This is a documented feature of SQL 2005 and above.
The best way to find if this affects you is to look...
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
October 29, 2009 at 5:01 am
What is in the install logs? These are normally found in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Logs
You get one folder in \Logs for every time you run SETUP, so look...
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
October 28, 2009 at 5:13 am
Viewing 15 posts - 1,141 through 1,155 (of 2,497 total)