Viewing 15 posts - 376 through 390 (of 2,497 total)
You need to talk to your license reseller to work out the most business-effective and cost-effective design.
You need to talk to your license reseller to work out the most business-effective...
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, 2014 at 8:01 am
If you are running in AWS then disabling TCP Offload can give a performance benefit - it certainly did for my employer.
SQL FineBuild will by default disable TCP...
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, 2014 at 5:46 am
See https://sqlserverfinebuild.codeplex.com/wikipage?title=Windows%20Memory%20Switches for suggestions of what switches you should use.
As Gail says, most of these settings only give a benefit in a small number of situations.
The UserVa value is only...
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, 2014 at 4:14 am
The image you show is 'standard' when you use high DPI settings within Windows 🙁
A Microsoft GUI is typically designed with fixed field lengths that are measured 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
December 1, 2014 at 3:59 am
It can be easy to get stuck in making sure that a process works, and lose sight of the reason you are doing the work.
In general eliminating fragmentation is 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 14, 2014 at 8:41 am
The Devs seem to be asking you to prove that the CPU hogs are a problem to SQL Server. I would try to turn that round, and get 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
November 14, 2014 at 8:13 am
I don't think I've seen a link to Ola's maintenance solution on this thread, so https://ola.hallengren.com/.
His processes are first-rate and regularly maintained to cope with new features and problems.
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 14, 2014 at 2:25 am
I think Steve is on the best track. You need to look at three things: 1) Total size of the objects you need to copy; 2) Rate of change...
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, 2014 at 5:08 am
Maybe we should stop thinking of employees as 'Resources' and start thinking of them as 'Domain Experts'.
All employees gain expertise of their work domain as they perform their jobs. ...
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, 2014 at 3:41 am
Are your database files hosted on Cluster Shared Volumes (CSV) or traditional cluster disks.
If they are on CSVs you should see no outage at failover. If they are on...
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 27, 2014 at 10:50 am
You do not get the space back because you are not blowing up a balloon.
A data file is a rigid container, not a flexible one. 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 13, 2014 at 6:24 am
Jeff's reply + 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
October 13, 2014 at 4:56 am
Is TCP Offload disabled on the Hyper-V host and on all guest machines?
TCP offload was originally designed to improve performance by forcing the network adaptor to do some...
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 13, 2014 at 4:52 am
Before you do a shrink and a index defrag, ask yourself what has to happen while the index is running. Work through in your own mind what space 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 7, 2014 at 3:01 am
SQL Server is a great product, but the licensing cost of recent versions has forced us to loo at what else is on the market.
Amazon Redshift provides much the same...
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, 2014 at 3:47 am
Viewing 15 posts - 376 through 390 (of 2,497 total)