Viewing 15 posts - 646 through 660 (of 2,497 total)
The SQL Experss media does not include any of the pre-requisite software components needed for SQL Server. You have to deral with this yourself.
Are you checking for and installing...
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 3, 2013 at 3:28 am
SQL 2008 R2 introduces support for Second Level Adderss Translation (SLAT). If you run it on Windows 2008 R2, you should see about a 5% performance improvement over running...
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 3, 2013 at 3:19 am
SP4 can be applied on top of SP2. You do not have to install SP3 first.
After you have installed SP4, you should also install the Security Update that was...
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 3, 2013 at 2:56 am
If you are designing a multi-TB database and do not understand all the design issues you need to pay to outside help. Period.
When processing a database of this size,...
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 2, 2013 at 4:19 am
I work with some non-profit organisations that use MailChimp for their mailings.
My employer sends out a few million mails per day and uses PowerMTA to process this workload.
The more mails...
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 2, 2013 at 4:13 am
The organisation I work for reckons that if its systems were down for 5 consecutive days its business would be destroyed. Maybe we would not be bankrupt, but 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
April 2, 2013 at 3:02 am
Just to make life interesting, you cannot use the .Net 3.5 install media that is included with SQL Server to install .Net 3.5 on Windows 8 or Windows 2012.
You need...
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 2, 2013 at 2:51 am
There is no 'best' method to replicate a database based on its size. There may be a 'best' method depending on what the business requirements are.
If this 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
April 2, 2013 at 2:40 am
If you want to enable the T1118 flag in SQL Express there is nothing stopping you from doing so.
However, because SQL Express (SQL2008 upwards) has a maximum database size 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 28, 2013 at 3:45 am
You say you have restored the SQL 2005 ReportServer db and ReportServerTempdb to your SQL 2008 R2 system and are using those with the SQL 2008 R2 binaries.
If so, I...
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 26, 2013 at 8:21 am
If you put the maximum possible on a separate drive on a SQL install, you will end up with about 3GB on the system drive and about 800MB on your...
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 26, 2013 at 8:18 am
It looks like you have done your homework.
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 5:47 am
The majority of the disk IO is to the GAC. This always exists onthe C: drive.
In any event, the IO to the OS and SQL binaries is in single...
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 5:44 am
One aspect is that you need to do all changes that affect a SQL 2012 box from SQL 2012 Management Studio. If you use SQL 2008 R2 SSMS, then...
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 5:18 am
If this is a Primary Key, then it is by definition a unique key. You need to consider your reasons for re-ordering the columns in this key, as 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
March 13, 2013 at 4:55 am
Viewing 15 posts - 646 through 660 (of 2,497 total)