Viewing 15 posts - 976 through 990 (of 2,497 total)
does cost of threshold mean the time taken to complete the query when ran in serial
Sort of... The optimizer tries to work out how long the query would take...
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 16, 2010 at 8:47 am
Paul, thanks for the clarification.
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 16, 2010 at 6:39 am
One good practice for a DR is that any task should be able to be done by someone outside the team that normally looks after the service. This means...
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 16, 2010 at 4:06 am
It is established best practice in the security world that the people who grant rights to a given object should be different to the people who allow people to use...
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 16, 2010 at 3:52 am
Another aspect of MAXDOP is that it applies to each portion of the execution plan, not to the whole plan.
If you are doing a SELECT from a single table using...
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 16, 2010 at 3:34 am
" The cost refers to an estimated elapsed time in seconds required to run the serial plan on a specific hardware configuration"
Having heard an explanation of this from the Microsoft...
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 16, 2010 at 3:17 am
I think you need to talk to Microsoft about this.
If your backup gts created using Tape Format 1.240 on one operating system and canot be restored on another, using 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
August 11, 2010 at 2:42 am
If you want to script the SQL 2008 cluster install, FineBuild can help. The current release will also create a MSDTC cluster if you want one.
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 9, 2010 at 8:38 am
We use transactional replication and have a few updating subscribers. All of our subscribers were updated to SQL 2008 before we updated the publisher or distributor from SQL 2005....
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 9, 2010 at 5:12 am
You are right in saying the ownership chaining would have to be enabled in your own DB for its owners to gain elevated rights in master. But it is...
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 9, 2010 at 4:34 am
There are a couple of viewpoints I could take over Houston...
1) The missing functionality is serious, and the product is of little use to the enterprise without it.
2) The available...
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 2, 2010 at 3:31 am
There are a few possible causes...
1) Faulty install media. This does not often happen, and given the other messages is not likely to be the cause of your problem.
2)...
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 2, 2010 at 3:09 am
Are you installing from a network drive or a local drive?
The SQL Server install is not very tolerant of slow drives or slow systems. There are numerous timing tests...
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, 2010 at 5:54 am
If MSDB has Id 3 then you need to detach MSDB then attach MODEL as DB id 3. In order to detach MSDB you will need to stop SQL...
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, 2010 at 5:45 am
For SQL Server 2008 (and 2008 R2) you cannot tell from looking at the media if you are installing a 32-bit or 64-bit version of SQL Server. Neither 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
July 20, 2010 at 4:02 am
Viewing 15 posts - 976 through 990 (of 2,497 total)