Viewing 15 posts - 661 through 675 (of 2,497 total)
I am not sure there is a best practice on this any more. Back in SQL 2000 and NT4 days people normally installed programs in a separate drive 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
March 13, 2013 at 4:29 am
Are you at the latest fix level? For SQL 2000 this is SP4 plus http://support.microsoft.com/kb/983811. However, I have no idea if this will solve your problem.
Try exporting 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 13, 2013 at 4:02 am
You might like to look at http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20AWE%20Property for more details of how the AWE property works.
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 13, 2013 at 3:41 am
My thoughts, FWIIW...
Any type of deployment needs a business case. For some cases a virtualised solution will be the cheapest and easiest to manage, while for others a physical...
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 11, 2013 at 5:22 am
This can be done,but you need to develop your own code to do this.
Some of the best online job boards (such as the Totaljobs Group boards) use this type 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 11, 2013 at 5:06 am
Michael had the answer. Put the SQL Cluster offline using the cluster administrator. This will stop the SQL services.
You can then close down the cluster. Shut down...
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 11, 2013 at 4:49 am
Best Practice advice is do not mode master, model or the resource database. There are no performance or data integrity reasons to move these databases, so all you are...
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 11, 2013 at 4:44 am
What you are talking about is known as 'Transitive Predicate Closure' or 'Transitive Closure'.
SQL Server knows how to do this for certain predicate operations, but not for all of them....
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
February 27, 2013 at 3:38 am
I had never heard of TF 2371 until seeing your post. From looking at http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx it seems to me that TF 2371 would be useful in the following situations:
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
February 27, 2013 at 3:28 am
Consumers view ads as a distraction or obstruction which prevents or delays their enjoyment of content. Any other interpretation is just wishful thinking.
Totally agree!!
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
February 26, 2013 at 7:33 am
As always, you need to look at your RTO (Recovery Time Objective), your RPO (Recovery Point Objective) and the value to the business of lost time or data. It...
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
February 26, 2013 at 4:48 am
You might want to look at SQL FineBuild. This can help you simplify and standardise your command line installs of SQL Server.
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
February 26, 2013 at 4:38 am
All of my organisation's database servers are running in AWS and therefore virtual. We use both SQL P2P and standard transactional replication in just the same way as we...
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
February 26, 2013 at 4:35 am
I think targeted advertising is OK providing that the end user is made explicitly aware of what the targeting preferences are.
Taking the Orbitz example, it could be argued that targeting...
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
February 26, 2013 at 4:32 am
It looks like you have got all your drives mapped as separate partitions on a single Windows volume.
You need to rebuild this so that each drive letter has its own...
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
February 19, 2013 at 2:45 am
Viewing 15 posts - 661 through 675 (of 2,497 total)