Viewing 15 posts - 1,321 through 1,335 (of 2,497 total)
BOL is Books Online.
GSquared has a good idea about spiltting your RAID group.
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
June 4, 2009 at 5:46 am
Personally, I would break this down as follows:
1) SQL Server install
2) Transfer any required logins, etc from the old to the new machine via scripts
3) Transfer the user databases from...
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
June 3, 2009 at 4:35 am
That's not a particularly good idea
Take note of what Gail says. What is the ultimate goal you are trying to achieve?
If your goal is to have the same set...
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
June 3, 2009 at 2:58 am
i know eat up my free space and they are not in used(orphaned).
How do you know the objects in tempdb are not in use?
If you can prove they...
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
June 3, 2009 at 2:45 am
If you divide your database into multiple filegroups this will force SQL Server to use multiple I/O streams to access your data.
SQL can use multiple streams on a single table...
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
June 3, 2009 at 2:37 am
Each time you call xp_cmdshell you create a CMD environment. When xp_cmdshell ends this environment is destroyed. This means that each of your xp_cmdshell statements runs in complete...
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
June 2, 2009 at 3:47 am
There are a few things to consider.
1) What Windows rights does your SQL Server service account have. Check with BOL for what is needed. I cannot remember 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
June 2, 2009 at 3:42 am
Ther are some specialist forums dealing with Capacity Planning and Capacity Management topics. Google should help you find these.
The main thing you need to focus on at the start...
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
June 2, 2009 at 3:31 am
Take a look at SQL Server 2008 FineBuild.
The reference manual shows the GUI steps for doing the configuration, and points to the section in the scripts that does...
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
June 2, 2009 at 3:18 am
What information is given in the SQL Server Errorlog?
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
June 2, 2009 at 3:16 am
If you are installing on a machine attached to a domain and you cannot use a domain account when you do a SQL Server install, this means either:
a) You do...
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
June 1, 2009 at 4:52 am
Sp2 can use 64gig of ram
True for SQL Server database engine, because the database engine is AWE-aware. Even then, SQL Server is unlikely to get above 55 GB 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
June 1, 2009 at 2:38 am
regardless of the amount of actual memory that is installed on the computer
The /3GB switch can only be used if the machine has less than 16 GB memory. On...
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
May 29, 2009 at 3:56 am
The OP is asking how to get 32-bit Analysis Services using more than 2GB memory.
This is not possible. SSAS is not PAE-aware so it cannot make use of this...
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
May 29, 2009 at 2:36 am
SQL Server FineBuild can help you by providing a totally scripted install. This can be run manualy on multiple servers or deployed using a tool such as Altiris.
The link...
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
May 29, 2009 at 2:26 am
Viewing 15 posts - 1,321 through 1,335 (of 2,497 total)