Viewing 15 posts - 1,576 through 1,590 (of 2,497 total)
If this 15TB of data is important to your business, it is important to get the right advise. I recommend you get a consultant with experience of this size...
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 29, 2008 at 2:53 am
Create a distribution list in Exchange, and use the name of the distribution list as the email address in your Agent Operator.
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 29, 2008 at 2:40 am
I am sure there was a KB article about this problem (or maybe we got the details direct from Product Support), but I cannot find any KB article now. ...
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 26, 2008 at 2:19 am
If all 3 files are on the same physical disk, there is no point in doing this. At best performance will be the sme as with 1 file but...
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 25, 2008 at 6:18 am
Temporary tables should be deleted automatically by SQL Server when the thing that created them ends.
If a #temp table is created in a stored procedure, it will be...
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 25, 2008 at 4:55 am
tempdb size does not depend on the size of your largest DB.
My advice is to follow the advice of The_SQL_DBA.
When you know how much space is actually used,...
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 25, 2008 at 3:25 am
The file size on disk and the file size shown by Windows may not always be the same.
The information shown to the end-user by the DIR command or in Windows...
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 25, 2008 at 3:18 am
To add to The_SQL_DBA... If you have multiple file in a filegroup that are all the same size and all allow autogrow, then growth is likely to be concentrated...
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 25, 2008 at 3:04 am
lucassouzace,
You should read the previous posts in this thread. A number of people thought the 'correct' answer was wrong or the question did not have a single answer.
I am...
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, 2008 at 7:40 am
Are you doing a command line install? There is a entry on Connect about this problem.
The /AGTSVCPASSWORD parameter does not like the password value to be in quotes. ...
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, 2008 at 7:33 am
The SQL Server install will put a lot of files in the GAC, which is always on the system drive. There are other files that are always put 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
September 24, 2008 at 7:29 am
It is a long time since I used SQL Server 2000, and it took me a long time to find the answer.
The good news is you do not 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
September 24, 2008 at 7:24 am
Also be aware that the SQL Server 2005 install media has separate CDs for the server components and the client tools. If you ran your install from the 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
September 22, 2008 at 3:41 am
If you are using Full Text search, the internals of this have been rewritten for SQL Server 2008. If you moved from SQL Server 2000 to 2005 and made...
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 22, 2008 at 3:36 am
Colin's question about how you are monitoring things deserves respect. Unless you know what is causing the problem, you are unlikely to get the right solution.
The discussion you report...
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 18, 2008 at 3:10 am
Viewing 15 posts - 1,576 through 1,590 (of 2,497 total)