Viewing 15 posts - 541 through 555 (of 2,497 total)
The Web Assistant functionality in SQL Server was removed for SQL 2008 and above. You need to find an alternative approach that gives the results you need. 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
November 27, 2013 at 3:17 am
Don't forget that when you move to SQL 2014 and start to use memory-optimised tables your max memory calculation will need to be revised.
The link suggested by Koen...
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 27, 2013 at 2:59 am
To generalise the issue, we need to look at why the policy was set.
Was it set to make money for the tow company, or was it set so that visitors...
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 27, 2013 at 2:50 am
I'd be very, very cautious with this in place upgrade
I would be even more cautious. An in-place upgrade may be an interesting training exercise, but has considerable risks 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
November 25, 2013 at 4:35 am
Amazon RDS and Amazon Redshift are both packaged database services delivered in a PaaS model.
RDS is available for a number of different DBMS (Oracle, SQL Server, etc), 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
November 25, 2013 at 3:30 am
You have also over-allocated your server memory. On a 64GB server, you should not try to get SQL to use 63GB.
There are many processes that need 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
November 14, 2013 at 2:37 am
If your plan was to install standalone SQL instances on each node and then 'upgrade' them to clustered instances, there is no supported process to make this work.
You can continue...
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 14, 2013 at 2:30 am
It is definitely good to know the implications of choosing a default database.
A few years back I worked with the Remedy help desk system. I do not know if...
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 14, 2013 at 2:17 am
From what I can see, there is nothing in the release notes about required security. The same can be said about a lot of other topics in the release...
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 11, 2013 at 5:02 am
SQL 2008 Express and above can use the same SP and CU patches as the server editions. SQL 2005 Express can only use the SP patches but not 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 11, 2013 at 4:52 am
[Quote]I need my Azure BLOB or AWS S3, etc storage to appear just like any other remote drive[/quote]
(My addition in italics)
IMHO this is one of the key items 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
November 11, 2013 at 3:02 am
Consider packaging your SQL queries in stored procedures, and not imbed the query in the report. (There are about as many people who would fight to the death 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
November 5, 2013 at 7:40 am
You need to know how the drive letters that Windows sees are mapped to your underlying storage. If your storage uses thin provisioning then you are probably wasting...
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 4, 2013 at 4:49 am
he has this attitude of "It must be SQL"
My advice is to escalate this to your management. Both you and the VM admin are working for a common customer...
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 4, 2013 at 3:40 am
You sound new to AWS. If so, then ask your AWS Account Manager for advice, this is a problem that others have come across and resolved.
When we went 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
October 29, 2013 at 9:10 am
Viewing 15 posts - 541 through 555 (of 2,497 total)