Viewing 15 posts - 1,186 through 1,200 (of 2,497 total)
If you can edit files yourself, then it is not a trust issue. Have you tried logging on with the SQL service account and accessing the share. 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
September 30, 2009 at 7:07 am
I would also advise you detach all your user databases before you do the upgrade, and attach them after you are happy the upgrade is successful.
If your upgrade fails 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
September 30, 2009 at 6:57 am
I work for a job search company called Totaljobs. I can tell you that we use SQL Server Full Text search as part of the way we match jobs...
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
September 30, 2009 at 3:16 am
Duplicate post. Please post all answers to http://www.sqlservercentral.com/Forums/Topic794373-338-1.aspx
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
September 30, 2009 at 3:08 am
There may be a lack of trust between the two machines. Dealing with trusts has changed a lot with W2008.
Try adding the target server to your Trusted Sites in...
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
September 30, 2009 at 3:03 am
SQL Server takes a shared schema lock when a backup is taken. This prevents the database from being dropped while the backup is running, but does not prevent any...
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
September 30, 2009 at 2:39 am
You say the server has 128 GB memory installed and you have set SQL max memory to 120 GB. You are probably asking for more memory than is available.
When...
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
September 29, 2009 at 3:15 am
Are you running 32-bit or 64-bit?
On 32-bit servers you have limited memory available to run things such as backups. This memory is also shared with other tasks, such as...
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
September 29, 2009 at 2:53 am
Disk fragmentation as seen by Windows is nowadays very rarely the disk fragmentation seen by the disk controller.
Some SANs have the concept that a LUN is a contiguous chunk 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
September 28, 2009 at 3:01 am
Microsoft say that mssqlsystemresource must be in the same folder as master for SQL 2005.
If they are in different folders and you apply SP1, then the SP1 install...
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
September 28, 2009 at 2:47 am
If testing restores in multiple scenarios shows
if one can do the recovery 100% of the time and the other can only recover 95% of the time
then you...
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
September 25, 2009 at 8:03 am
Jacob is right. I was going to post much the same, but he got there first.
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
September 25, 2009 at 6:42 am
It is important to move away from a turf war about who should do what, and focus on the business objectives.
Most businesses will have recovery objectives and SLAs. These...
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
September 25, 2009 at 6:39 am
If your ETL processing is just one query among many others on the same SQL instance, you cannot restrict it to using a single CPU.
The best 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
September 25, 2009 at 6:16 am
IMHO if you have a disk dedicated to backups you do not need to worry about fragmentation on this drive. Because backup files get created and deleted on 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
September 25, 2009 at 6:07 am
Viewing 15 posts - 1,186 through 1,200 (of 2,497 total)