Viewing 15 posts - 1,546 through 1,560 (of 2,497 total)
This topic was discussed a few times at PASS, and the people who author SQL Server and the most experienced people in the user community are clearly saying you can...
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
December 1, 2008 at 3:04 am
For SQL Server 2005, the server components and the client tools are on separate CDs. Try installing the tools using the Tools CD.
If you are installing from a DVD,...
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 27, 2008 at 6:29 am
I agree that the PASS keynotes are often just marketing. And too often the marketing is aimed at senior managers rather than technical staff.
When I see 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
November 26, 2008 at 3:00 am
Most people recommend leaving 1 to 2 GB outside SQL Server for Windows use, but the amount you really need to allow is site dependant.
Assuming you do not have any...
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 25, 2008 at 5:03 am
If you cannot get your query to work, try the following troubleshooting:
1) You are running a Windows command - bcp - so try running this outside SQL Server. If...
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 25, 2008 at 4:46 am
My mainframe experience does not cover VSE, but I notice you are getting some good advice from people who do have these skills. What you want to do 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 25, 2008 at 4:27 am
If your Senior DBA has asked you to do this, it is worth discusing the issue with that person. Although you can use the BOL references to tell you...
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 25, 2008 at 4:19 am
The in-place upgrade can sometimes fail after it has disabled SQL Server 2000 and before SQL Server 2005 is working. If this hapens you will have to uninstall SQL...
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 24, 2008 at 4:56 am
The question was 'What are included columns in SQL Server 2008'. I don't see that the status of included columns in SQL Server 2005 is relevant to the question.
If...
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 13, 2008 at 2:29 am
SQLServerFineBuild contains SPs to script out SQL Agent jobs and scripts to reload them. It also has SPs to script table, views, SPs, Users, etc. Even if you...
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, 2008 at 3:43 am
Why worry about fingerprints when you can use DNA. Scientists tell us that every person's DNA is unique, so here we have an infallible way of proving identity and...
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, 2008 at 3:35 am
As George pointed out, by 'default' location I mean the original location they are placed in by the SQL Server install.
Regarding msdb, if your installation has a lot of CRUD...
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 10, 2008 at 5:34 am
IBM publish all the DB2 manuals online. It can be a pain to find them, but Google knows most of the places...
The best practice documentation and research...
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 10, 2008 at 5:28 am
SQL Server 2000 really needs to run using an account with local admin rights in Windows. Although there is a theoretical possibility of running it with less rights, there...
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 10, 2008 at 5:19 am
The Readme file for SQL Server 2005 says how much space will be used on the system drive, and how much will be used for the program files if you...
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 10, 2008 at 5:11 am
Viewing 15 posts - 1,546 through 1,560 (of 2,497 total)