Viewing 15 posts - 1,171 through 1,185 (of 2,497 total)
Don't just look at the headilne price for 3Party backup tools. As you say, paying on a per-server basis could cost you $20,000. If you have a few...
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 8, 2009 at 5:47 am
See Brad McGehee's post at http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx this has some good background material.
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 8, 2009 at 3:12 am
As a minimum, you need to set NTFS security on the Filestream storage location so that only the SQL Server service account can delete files.
If you are not going 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
October 7, 2009 at 4:15 am
What you are doing is putting the string 'C:\test.doc' into the column DATA. You need to put the document into this column.
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 7, 2009 at 2:12 am
Running x64 means that Task Manager will always mis-represent the amount of memory used by 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
October 6, 2009 at 3:55 am
If you have AWE turned on, then any memory allocated by the AWE API is termed a 'private memory space' by Windows, and is not shown in Task Manager.
In 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
October 6, 2009 at 3:21 am
You may find SQL Server FineBuild useful. The Reference manual has about 50 pages of post-install configuration work that is worth doing.
The aims to get you going with 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
October 6, 2009 at 3:12 am
George has the right solution for removing an unwanted log file. Use Shrinkfile with the Emptyfile option. You will only be able to empty the log file 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
October 5, 2009 at 2:40 am
I also agree with Jeff. When you get files into the GB range then Filestream is the only way to go.
Google 'To Blob or not to Blob', a good...
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 5, 2009 at 2:32 am
I agree that a restore process that does not work is not worth having.
My main pioint is that we should not assume that because method A has proven...
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 2, 2009 at 8:16 am
Gail is right. If you have very little space on your server you have a problem. Doing repeated shrink operations is a bit like trying to empty 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
October 2, 2009 at 3:51 am
2GB ram is very little memory to run SQL Server. If this is a production machine I recommend you get more memory as it is relatively cheap.
My recommemdation 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
October 2, 2009 at 3:43 am
If your server has 6GB memory, then probably the best option is to use both the /PAE and /3GB switches in boot.ini, and turn on AWE in SQL Server.
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
October 2, 2009 at 3:31 am
It is easy to take a feature present in one DBMS that does not exist in another and say that the first is the better system. All of 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
October 1, 2009 at 3:28 am
You will find that applying maintenance for SQL Server 2005 and 2008 will use a LOT of space on the sytem drive. Most of this goes into the Global...
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
September 30, 2009 at 9:01 am
Viewing 15 posts - 1,171 through 1,185 (of 2,497 total)