Viewing 15 posts - 1,291 through 1,305 (of 2,497 total)
Your post is the first time I have heard about problems changing the sa password by using the GUI.
Can you post your reference that said this? I think someone...
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 22, 2009 at 2:53 am
Did you get the change made in the master DNS server or a slave?
If your DNS environment is integrated with AD (which is normal) then the change needs to 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
June 19, 2009 at 3:17 am
Just a guess... It may be something to do with how Windows recognises when a newly used account gets local admin rights.
I know that Windows build a list of local...
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 18, 2009 at 4:29 am
The right you need to do a defrag is: "Perform volume maintenance tasks" also known as SeManageVolumePrivilege.
Accounts in the local Administrators group have this right by default, but you 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
June 18, 2009 at 4:10 am
Personally, I would install the DTS designer component on all nodes. That way you can use it regardless of which node is active.
Also, I recommend you use the freeware...
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 12, 2009 at 4:57 am
My reading of the article is that if you over-allocate memory then Windows will run slower than if memory is not over-allocated.
You may find that adding LPIM to the 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
June 12, 2009 at 4:28 am
An article from the Windows Server Performance Team suggests that the use of Lock Pages in Memory is often harmful to overall performance.
In situations where Lock Pages in...
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 11, 2009 at 2:54 am
Windows 2003 is fairly good at managing memory, but it is not as sophisticated as Windows 2008. Many people find that setting a maximum memory size for SQL 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
June 9, 2009 at 7:21 am
Ther are two ways to deal with transaction log growth that do not involve manually shrinking the file:
1) Do more frequent Transaction log backups.
If your recovery SLA requires...
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 9, 2009 at 7:17 am
Your problem may be related to the repeated shrinking and growing of your database and log files. You need to stop doing this. Both database files and log...
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 9, 2009 at 5:31 am
Can I suggest you open a case for this with Microsoft. There should be a better solution than installing a 32-bit version of SQL Server 2008 on a 64-bit...
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 9, 2009 at 3:47 am
If you have a 64-bit installation of SQL Server 2008 available, it is definitely worth trying to connect to it with your 32-bit application. There are very few issues...
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 9, 2009 at 2:53 am
The first thing you should do is to try to find the cause of the slow performance.
Use Perfmon to look at items such as:
* Page file write operations (P/F read...
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 9, 2009 at 2:49 am
are u teacher or lecturer of sorts
No, I am a database architect.
But I have attended lots of Bonnie Baker seminars. She has a knack of explaining sometimes complex 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
June 9, 2009 at 2:36 am
Alzdba has given one case of where you will get a DB full message when you have lots of disk space. There is another...
SQL Server will only make 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
June 8, 2009 at 4:25 am
Viewing 15 posts - 1,291 through 1,305 (of 2,497 total)