Viewing 15 posts - 1,516 through 1,530 (of 2,497 total)
Take a look at FineBuild for SQL Server 2008 http://sqlserverfinebuild.codeplex.com/releases/view/47333
SQL Server FineBuild gives 1-click installation and best-practice configuration of SQL Server. It gives everyone a rock-solid foundation for exploiting...
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
January 29, 2009 at 3:17 am
A SharePoint database is just a database. You need to do all the normal maintenance that is needed on any database.
The KB article mentioned above confirms 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
January 27, 2009 at 2:52 am
There are three things to consider with this. You should read what Books Online (BOL) has to say about all of these, as well as the posts in...
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
January 26, 2009 at 3:07 am
It is important that you setup the database to automatically shrink itself.
This is BAD advice. You should never shrink your database on a regular basis. If you do:
1)...
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
January 26, 2009 at 2:42 am
This sounds like you only have the client tools media in your install folder. Alternatively, if both the server and tools media were copied to the same folder 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
January 23, 2009 at 2:27 am
Using detach and attach for user databases is a good idea. Even if you do an upgrade in place it is good to detach the user databases before 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
January 22, 2009 at 2:56 am
If your server is 32-bit, make sure you have AWE enabled. If you are not sure how to do this, look in Books Online (BOL).
If you are running 64-bit...
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
January 21, 2009 at 4:02 am
Good practice for doing upgrades in a Production environment is to take an image of the relevant disks before starting the upgrade. That way if the upgrade fails 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
January 21, 2009 at 3:57 am
I noticed in the OP that you only had SQL 2005 Tools installed.
SQL 2005 install media is delivered on 2 CDs, one for server components and one just for 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
January 21, 2009 at 3:51 am
There can be lots of rubbish stored on ther system drive that can be deleted. As a start, look in:
Windows /Temp folder
Each user's /Temp folder (in their user profile)
Each...
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
January 21, 2009 at 3:40 am
All things are possible, but not all things are beneficial
Paul, early ADs
It may be possible to move the system databases, but for most of them it is not beneficial....
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
January 19, 2009 at 5:36 am
For me, the issue to the airport operator being at the mercy of what the government provides in terms of staff is a cop-out. The airport is an entrepot...
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
January 19, 2009 at 5:18 am
SQL Server FineBuild has a load of scripts you can use for this export and import. Feel free to raid the code for anything you need.
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
January 19, 2009 at 5:06 am
I like being in different places, but I feel the increasing hassle of getting there is a big discouragement.
For me, airports offer about the worst customer service on the planet....
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
January 19, 2009 at 4:17 am
tosscrosby (1/8/2009)
why use the -g switch as opposed to simply setting a lower fixed amount for SQL within EM?
Having put my brain into gear, reducing SQL max memory is 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
January 9, 2009 at 2:28 am
Viewing 15 posts - 1,516 through 1,530 (of 2,497 total)