Viewing 15 posts - 256 through 270 (of 2,497 total)
I hope no-one minds me saying this, but 'large disks or many disks' already seems a yesterday question.
If you are in the cloud then you have the option 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
February 14, 2017 at 7:03 am
From the OP it sounds like you are uninstalling and reinstalling SQL Server on the same OS. This just seems a weird thing to do as it is hard 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
February 14, 2017 at 6:23 am
We use SoftPerfect RAM drive to host tempdb. So far we have not seen tempdb filling up but it is a risk whenever you use a ram drive to host...
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 21, 2017 at 8:54 am
Old software is going to stay old software for a long time. A few lucky organisations will be able to move their applications to new software, but most places 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
January 21, 2017 at 8:30 am
I can easily see that a SQL Server DBA used to Windows has little interest in looking at SQL Server on Linux. Nothing is broken in Windows so why...
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 11, 2017 at 3:46 am
If percussive maintenance doesn't fix the problem, gravitational maintenance is known to work.
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 31, 2016 at 12:39 pm
In all of this, always be polite and courteous with whoever you deal with. You are a professional and you need to always be seen to act like one.
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 10, 2016 at 7:00 am
What type of access are you getting for PatientOrder and TherapyAdmin? This can affect how the optimiser might access AdminObservation. Please post the plan.
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 7, 2016 at 12:36 pm
As already said, the DDL and plan is really needed to give the best answer.
However, the index suggested by Luis is guaranteed to require a clustered index lookup to satisfy...
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 7, 2016 at 12:33 pm
The vendor won't tell us a lot about their hyper-convergence solution
Have you looked at what you can do with Windows 2016. The Windows side of hyper-convergence capability has been...
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 6, 2016 at 12:49 pm
We currently use https://www.softperfect.com/products/ramdisk/ to host the Windows \Temp folder and tempdb. It should also be possible to create a RAM Drive natively within W2012 and above with...
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 5, 2016 at 3:29 pm
Why do you want to find out this information. What are you planning to do if you have these details?
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 5, 2016 at 3:19 pm
I would certainly like to see SQL Agent Jobs get a bit more development, and being able to maintain jobs at the DDL level sounds like the best way 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 5, 2016 at 2:09 pm
we will only be able to use 16 cores in SQL 2014 but in SQL 2008 we are able to use 32 processors. Is this true ?
Yes. If Windows...
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
November 23, 2016 at 3:58 am
There are plenty of people who have shown that in-place upgrade from SQL2005 to SQL2016 is not possible, but even if it was why would you want to do it?
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
November 23, 2016 at 3:29 am
Viewing 15 posts - 256 through 270 (of 2,497 total)