Viewing 15 posts - 1,201 through 1,215 (of 2,497 total)
You should consider using an anonymous account for the xp_cmdshell proxy account.
This proxy is used by all non-sysadmin users who want to run xp_cmdshell. The proxy will need access...
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 24, 2009 at 3:54 am
If you access your table via a stored procedure, the access plan will be created the first time the SP is run after SQL startup.
It is possible that...
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 24, 2009 at 3:38 am
The system databases are created on the disk where you put the SQL program folders.
Best practice is to leave master, mssqlsystemresource and model where they are installed.
You should...
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 17, 2009 at 10:33 am
Every database needs some free space. As a minimum, you will need enough free space to hold a copy of your largest table plus its indexes, so that 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 15, 2009 at 4:42 am
SQL Server FineBuild has scripts that help you export and import jobs. Feel free to raid the code for whatever you want.
There is a problem area moving jobs that...
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 15, 2009 at 4:27 am
Steve is tright. you absolutely MUST run DBCC CHECKDB, and make sure you use the ALL_ERRORMSGS option and do NOT use the REPAIR_ALLOW_DATA_LOSS.
Sometimes Windows may report errors with 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
September 14, 2009 at 5:16 am
It is generally considered to be bad practice to log on to a production SQL Server box in order to do management tasks.
The use of Windows desktop takes...
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 14, 2009 at 4:41 am
If you aer a sysadmin and you run xp_cmdshell, it will run using the credentials of the SQL Server service account.
If SQL is run using LOCAL SYSTEM authority,...
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 14, 2009 at 4:22 am
You really need to do some workload simulation, so you have ral figures for your installation.
Your tests will show how many I-O streams can be supported by your disk subsystem....
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 11, 2009 at 5:01 am
The advice about puting each filegroup on its own RAID set has a good intention at its heart, but is not really correct.
SQL Server can initiate multiple I-O streams against...
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 10, 2009 at 9:59 am
I was thinking of SQL Server table partitioning, not Windows drive partitions...
There is nothing to stop you putting all your file groups on a single drive. However, you should...
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 10, 2009 at 8:49 am
IMHO do not worry about separating partitions to different disks. Using partitions has a very significant advantage over using a status column in the clustered index...
The partitioning...
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 10, 2009 at 8:19 am
My understanding is that the 'Administrator' in question is a member of the Windows local Administrators group, not a SQL Sysadmin. This means the list of people who could...
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 10, 2009 at 3:30 am
This thread shows the problems that can happen when you want to do something that is totally unnecessary.
There are no performance or data integrity advantages to moving model database. ...
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 8, 2009 at 7:31 am
If you are going to finance learning SQL Server yourself, ten I recomend you get a Technet subscription. This cosst about GBP 250 in year 1, with a GBP...
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 8, 2009 at 5:09 am
Viewing 15 posts - 1,201 through 1,215 (of 2,497 total)