Viewing 15 posts - 2,431 through 2,445 (of 2,497 total)
I completely agree with Brian.
There are a number of issues here...
1) Comparisom with other vendor's release stategy.
My main experience is with DB2. When IBM are near to making a new...
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, 2004 at 4:04 am
I would set the database offline. Even a single user connected would stop the DETACH working.
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 23, 2004 at 5:06 am
Use the same process as you would on a normal SQL Server database.
Connect to the MSDE instance in Enterprise Manager, right-click and select Properties, then set the required memory on...
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 23, 2004 at 4:57 am
The System Monitor disk counters can give misleading results with SQL Server.
SQL continually monitors how long it takes for a disk read request to complete. If I-O time is slow, SQL will...
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 21, 2004 at 8:25 am
There is very little on newsgroups or in Microsoft documentation about how W2000 or W2003 manages disk I-O. Certainly this is true when compared to mainframe z/OS, where ther 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
April 20, 2004 at 8:26 am
It is not possible to give generic advice about placing TempDB data and logs on the same controller. You will have to test this using your own hardware.
However, you can...
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 20, 2004 at 8:02 am
You should work with your SAN vendor in deciding which type of RAID to use. We are installing some HDS 9970v SANs, and have confidence in Hitachi's recommendation of formatting...
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 20, 2004 at 7:28 am
xp_Stopmail is fine to do on the command line, but beware of including it in an application.
One of our developers thought it would be 'safer' to wrap a xp_sendmail within...
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 14, 2004 at 6:32 am
You definitely need to troubleshoot MAPI problems by being logged on using the SQL Server service account. Anything else is normally a waste of time.
As to the question 'Why now?',...
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 14, 2004 at 3:48 am
The evaluation was done before I joined the organisation. We have done mini-evaluations since then, and confirmed that no other Windows-based replication tool offers superior facilities to D-T. Some match...
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 8, 2004 at 6:57 am
We are currently using Double-Take in production to replicate both databases and application files for Active/Passive failover. Our average latency between our current main and DR sites about 10 km...
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 8, 2004 at 4:55 am
As suggested, you can use TargetServersRole, but with modified permissions. This will allow users access to all jobs. If you give them the ability to add/change/delete jobs, this will apply...
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 7, 2004 at 2:58 am
If your database files took up 30GB of disk space when you made the backup, then you will need 30GB of spare disk space when you do the restore. 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 30, 2004 at 1:30 am
If you define an ID column in your table you can load your data using DTS. All that should be needed is for the DTS package to name all 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 22, 2004 at 8:21 am
The behaviour is NOT guaranteed. You need to understand what is meant by 'order' in a relational database, and how this interacts with a DTS load.
The physical order in which...
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 22, 2004 at 3:00 am
Viewing 15 posts - 2,431 through 2,445 (of 2,497 total)