Viewing 15 posts - 616 through 630 (of 2,497 total)
It is supported, but as a guy called Paul once said 'All things are possible, but not all things are advisable'.
There are no data integrity or performance reasons for moving...
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
May 20, 2013 at 6:18 am
Microsoft have made a problem for themselves with the Virtualisation Tax (aka Software Assurance) you have to pay when running SQL Server in the Cloud.
I must stress this...
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
May 20, 2013 at 5:25 am
This has details about installing and using LocalDB http://msdn.microsoft.com/en-us/library/hh510202.aspx
Ther are no documented restrictions I have sen on connecting to databases created before SQL2012, so you should be OK to use...
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
May 14, 2013 at 8:05 am
You should not put any user tables or other items in the master database. Use your own database for your own items.
Also it is worth looking at SQL 2012...
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
May 14, 2013 at 2:48 am
IE tends to work with Report Manager, but most other browsers do not. Some browsers will show the Report Manager window but will not render a report.
Microsoft has no...
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
May 14, 2013 at 2:43 am
It is worth looking at Ola Hallengren's index maintenance routines at http://ola.hallengren.com/.
This checks statistics so that only those indexes that need rebuilding get processed. This can cut...
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
May 14, 2013 at 2:23 am
All I can say is that I have done this many times and it should work.
If you want to use Filestream you will need to install KB 937444,...
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
May 13, 2013 at 3:16 am
Take a look at this link, it covers a lot of the background about using AWE: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management
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
May 8, 2013 at 2:51 am
You cannot put a table into P2P until it exists on all P2P nodes. This means you must run the table create script on all the nodes, and 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
May 7, 2013 at 4:58 am
You need to install .Net 3.5 SP1 on Windows 8 before you can install any version of SQL Server. You need the special install media for Windows 8 found...
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
May 7, 2013 at 4:42 am
We run all our production web and SQL servers virtualised and get good performance out of them. You just need to make sure the virtual servers have access 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
May 7, 2013 at 3:51 am
If you are just doing a lift and shift, then the starting point for the new box is to make it the same capability as the old box.
CPU...
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
April 30, 2013 at 3:51 am
If your reseller is a Microsoft Gold partner then Microsoft accept full liability for any advice they give.
This was something said to me by someone who has work with MS...
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
April 30, 2013 at 3:01 am
Also, remember that if you create a SQL SP WITH ENCRYPTION, anybody who can get access to the SP can decrypt it. You may as well keep the SP...
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
April 29, 2013 at 3:19 am
If you buy your licenses via a Microsoft licensed reseller, then talk to them. Their advice should be free as part of their service to you.
They may not always...
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
April 29, 2013 at 2:52 am
Viewing 15 posts - 616 through 630 (of 2,497 total)