Viewing 15 posts - 2,026 through 2,040 (of 2,497 total)
Yes.
Setting the size of tempdb in SQL 2000 EM or SQL 2005 SSMS will do 2 things:
1) Increase the current size of tempdb to the values you haave given.
2) 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
June 14, 2007 at 3:26 am
Look in the system Environment variable PROCESSOR_ARCHITECTURE.
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
June 13, 2007 at 2:53 am
Once you have got your Logins known to SQL, you can detach your user databases from SQL 2000 and attach to SQL 2005 (or restore a backup to SQL 2005) and...
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
June 12, 2007 at 2:24 am
I think you need to separate the issues of transferring SQL logins from the issues of database users.
If you send me your email address, I will send you our proc...
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
June 11, 2007 at 6:12 am
There have been many tools such as LINQ in the past, that purport to make life easier for developers by avoiding the 'pain' of coding SQL. Most of these have...
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
June 11, 2007 at 6:04 am
If you installed SQL 2005 on to a W2003 server, .Net 1.1 is already there. The SQL 2005 install will install .Net 2.0 if it is not already on 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
June 11, 2007 at 5:41 am
You should only consider a in-place upgrade from SQL 2000 to SQL 2005 if all other options are impossible.
The result of an in-place upgrade is messy. You have 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
June 11, 2007 at 5:34 am
You have to specify the port number after installation completes, using SAC or other tools.
You can change the file location on the Feature screen. Highlight a component and click Browse.
Every...
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
June 1, 2007 at 3:57 am
My advice is leave master, mssqlsystemresource and distmdl files in their default locations. I have had no problems in moving model, msdb and tempdb.
SP2 changes the way SQL Server deals...
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
June 1, 2007 at 3:51 am
My advice is leave master.mdf, the mssqlsystemresource files and distmdl files in the default location.
Our SQL2005 SP1 standard was to move all these files to specific locations, with the ldf...
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
June 1, 2007 at 3:25 am
If your packages have custom tasks you will get this message. If it is a custom task problem your MSDB is probably OK, all you need to do is register...
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
June 1, 2007 at 3:12 am
I agree with 50% of what SQLBill says on this.
If you use a maintenance plan to reindex, you will see a large amount of free space at the end...
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 31, 2007 at 4:13 am
You should convert your Dev databases before your Test, and Test before Production. It is a few years since we converted from SQL7/NT4 to SQL2000/W2003, and there were 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
May 31, 2007 at 3:54 am
We store all our critical data on HDS SANs, one in GB and one in US, and these use async replication and are fully integrated into our DR plan.
On our...
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 31, 2007 at 3:32 am
Our standard build includes SP2 and hotfix rollup 3152. Agent runs fine here.
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 30, 2007 at 9:24 am
Viewing 15 posts - 2,026 through 2,040 (of 2,497 total)