Viewing 15 posts - 1,426 through 1,440 (of 2,497 total)
Yes, you can have 1 instance with AWE and 1 without. You should try various combinations to see what works best for 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
March 17, 2009 at 9:10 am
Asking for 3.5 GB for each instance is probably more memory than is available. You will need to experiment with values between 3GB and 3.5 GB to see what...
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
March 17, 2009 at 6:01 am
You will need to have the /PAE and /3GB switch in boot.ini and AWE active on SQL Server in order to get the memory use you want.
I think most 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
March 17, 2009 at 4:19 am
Things are being put into tempdb because SQL Server needs to put them there. The trick is finding out what is triggering this behaviour. Did the hardware also...
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
March 17, 2009 at 4:10 am
At my old place the system DBs were on different disks to the user DBs. The user DB disks were replicated but the system DB disks were not.
Each server had...
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
March 16, 2009 at 6:57 am
It is worth looking at what patches are being applied. You can normally patch Windows on a server by server basis without risk to this type of environment. ...
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
March 16, 2009 at 6:02 am
This sounds like a relatively high-risk approach to your company's storage requirements. Document your concerns. Try to give required read and write I-Os per second, average and peak...
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
March 16, 2009 at 5:48 am
The underlying application sounds a good candidate for sparse columns in SQL Server 2008.
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
March 16, 2009 at 5:41 am
You can write a custom iFilter to limit the scope of Full Test search.
The job of the iFilter is to take the original document and strip away the documnt formatting...
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
March 16, 2009 at 4:50 am
The best advice is to go for 64-bit and SQL Server 2008 on Windows 2008. This will give you an operating platform that will stay current technology 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
March 16, 2009 at 4:40 am
My old place used this approach, and it worked fine.
The full setup they had was:
1) Server 1 in DC1 in UK, all drives attached to SAN1
2) SAN 1 replicating 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
March 16, 2009 at 4:33 am
I cannot answer your RS query, but I can give some general advice about in-place upgrades from SQL 2000 to SQL 2005.
A significant number of upgrades will fail during 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
March 12, 2009 at 8:27 am
You can run your DTS packages unchanged on SQL Server 2008. There are a lot of advantages to be gained from migrating them to SSIS, but I'll leave those...
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
March 10, 2009 at 4:18 am
See the post from Piotr Rodak at http://www.sqlservercentral.com/Forums/Topic541937-146-1.aspx
I was going to write something similar, but Piotr has said just about all you need. Work out what users 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
March 10, 2009 at 4:06 am
If you want to give access to SQL Server for a group of users, the best way is to get the users added to a Windows group and then give...
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
March 10, 2009 at 3:56 am
Viewing 15 posts - 1,426 through 1,440 (of 2,497 total)