Viewing 15 posts - 811 through 825 (of 2,497 total)
It can be good to decouple the DTS to SSIS upgrade from the SQL 2000 to SQL 2008 upgrade.
If you install the 'SQL 2005 Backward Compatibility' component for...
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
January 3, 2012 at 4:06 am
I agree with Elliott. Once you have the OS running, then SQL Server should neither know or care if the processor is AMD or INTEL.
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 21, 2011 at 3:27 am
Be aware that you cannot have a SQL Server Indexed View of an Oracle table. You must first import the data into a standard SQL Server table.
After you 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
December 21, 2011 at 3:23 am
You could also take a look at a Technet subscription. The Professional Download-only subscription costs about GBP £250 in year 1, and about GBP 200 to renew. 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
December 21, 2011 at 3:14 am
Merge Replication can be great when you get it to work smoothly, but getting it to work can be more hassle than some organisations will put up with. 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
December 21, 2011 at 3:03 am
The SQL Express install media does not include components that must be installed before the SQL install. The server edition media does include these components.
Before installing SQL 2008 Express...
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 20, 2011 at 6:02 am
How fast is your server? If you are running a guest machine with minimal CPU, memory and slow disk access you can get all sorts of problems when 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
December 20, 2011 at 5:40 am
If you can set things up so that all your writes go to one server, you will have a MUCH simpler environment. One of the pains of Merge Replication...
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 20, 2011 at 4:48 am
The DBA of a production system will have rights to see all atabase objects.
If you use 'encrypted' stored procedures and functions, the DBA will not be able to view 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
December 19, 2011 at 10:01 am
You can do this...
BEGIN TRANSACTION
LOCK TABLE...
SELECT...
UPDATE...
COMMIT
This is a VERY bad way to use a database (SQL or DB2). Your planned approach does not make best use of DB2 facilities,...
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 19, 2011 at 9:53 am
If you have 8 CPU sockets and each socket has a CPU with 1 core plus hyperthreading, then you must be running on old kit.
You will find it cheaper 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
December 19, 2011 at 9:50 am
Service SIDs have been around since Windows 2008 but I have found very little information about them.
What I do know is that the SQL install will create the Service SIDs...
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 19, 2011 at 8:31 am
When you get everything working again, it is time to think about what your objectives were in doing this work.
There are no integrity or performance advantages in moving master, model...
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 19, 2011 at 8:12 am
If you have 2007-vintage hardware and run Windows 2008 R2 on it then you may find little change in performance.
But if you have 2007-vintage hardware then it is at 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
December 19, 2011 at 7:22 am
I have not done this type of license upgrade, but what you said looks reasonable: take backups, shut down SQL, apply OS license change, reboot, start up as normal.
I would...
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 19, 2011 at 7:14 am
Viewing 15 posts - 811 through 825 (of 2,497 total)