Viewing 15 posts - 1,231 through 1,245 (of 2,497 total)
When you are doing this type of test, it is important to simulate what you will have in Production.
If you are running your queries on a single core development server...
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
August 10, 2009 at 3:57 am
One of the aspects of MAXDOP that is missed by many people is that MAXDOP applies to each portion of the plan, not to the overall statement.
For example, look at...
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
August 10, 2009 at 3:46 am
Even if you are using Enterprise Edition for development purposes only, you need a vaild license.
If you have a TechNet license, or the appropriate level of MSDN license, 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
August 7, 2009 at 2:01 am
There are some things to consider..
1) Task Manager on a 32-bit server cannot show memory use above the 4GB line. Even if your SQL instance has 20GB AWE memory...
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
August 6, 2009 at 9:59 am
You can play with the installation rules and get Enterprise Edition installed on XP. Personally I cannot see any point in doing this apart from showing that it 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
August 6, 2009 at 9:50 am
In the UK there are many small loyalty schemes, and 2 big ones - Nectar and Tesco. Both of these span multiple companies that have no common ownership. ...
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
August 6, 2009 at 9:41 am
When you enable Service Broker you are enabling it for User processes. The End Points you set up are User end points. It is always enabled for System...
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
August 3, 2009 at 3:45 am
Using SAN snapshotting may be your best way, but there is another approach that would work.
You could keep your reporting server reasonably up to date by shipping database backups. ...
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
August 3, 2009 at 3:37 am
I agree with Lowell and RBerryYoung.
What you want to do is like asking for a single paragraph to be written in English and German that means exactly 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
July 30, 2009 at 6:54 am
Get expert help. 40TB is a leading edge system and very few people will have the experience to give you useful advice. You will find problems at 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
July 30, 2009 at 6:42 am
I have experience of a similar situation but using HDS kit.
It can work very well providing the data and log volumes are in the same synchronisation set. In HDS...
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
July 29, 2009 at 6:10 am
There are no additional security concerns about putting Developer Edition on to a Workstation compared to having SQL Express or SQL Embedded Edition on the Workstation, and these latter two...
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
July 29, 2009 at 6:02 am
Youi may find SQL FineBuild helpful. You can gt this either by following the link below or direct from CodePlex.
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
July 29, 2009 at 5:52 am
SSAS in 32-bit mode looks at the physical memory available on the box as reported by Windows, and limits its use within that. Therefore it will give you an...
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
July 28, 2009 at 6:02 am
There are 32-bit and 64-bit version of all of SQL Server 2000, 2005 and 2008.
The 64-bit version of SQL Server 2000 is for database services only, most other components run...
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
July 23, 2009 at 2:33 am
Viewing 15 posts - 1,231 through 1,245 (of 2,497 total)