Viewing 15 posts - 2,461 through 2,475 (of 2,497 total)
My advice is:
a) Talk to your production support and security people to see if what you are planning will be allowed to go live. History is littered with applications 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
January 28, 2004 at 2:50 am
Some reasons for storing images in a DB
a) Data integrity. Most applications I have known that use a mix of DB and non-db data storage have had problems with integrity...
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
January 26, 2004 at 9:51 am
It is important to not confuse reclaiming space within the filesystem with reclaiming space within the database.
SHRINK is used to reclaim space within the file system. After running a SHRINK, your...
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
January 26, 2004 at 6:53 am
Repeated shrink and growth of a database will always lead to bad NTFS file fragmentation. This will give continuing bad performance to your database.
The only way to fix NTFS fragmentation...
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
January 26, 2004 at 5:46 am
The answer is yes it should, but no it does not.
Looking back at the early days of when partitions were implemented in mainframe DB2, very similar problems occurred. It took...
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
January 23, 2004 at 2:49 am
Expiry or disablement of the SQL Server agent account is the most common cause of this problem. Other potential causes are:
a) SQL Server Agent account deleted as a 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
January 22, 2004 at 4:40 am
A final point... one thing missing from your maintenance plan is backups. You are doing backups...?
For most sites, a full daily backup is the best option. Transaction log backups 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
January 16, 2004 at 4:19 am
Running items 1 and 2 daily is probably overkill, and running item 3 at all is too often.
1) Integrity check
You need to balance your trust in the reliability of your...
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
January 16, 2004 at 4:13 am
There are some possible answers...
It is possible that the #temp insert did not require and file growth for either the .mdf or .ldf files, but the insert into the 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
December 31, 2003 at 5:59 am
It can be surprising how many times a tape backup needs a second tape, but this tape never gets mounted. The backp then hangs until someone notices it, often...
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
December 23, 2003 at 5:13 am
Knowing the memory usage for a database is not particularly useful.
I have worked on DB2 for z/OS, where information of this type can be obtained. The really useful information...
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
December 16, 2003 at 6:56 am
If you have custom DTS tasks, the backup and restore will affect the package definition, but will of course not include the custom DLL files. Restoring an old MSDB...
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
December 16, 2003 at 6:17 am
Are you using a Job Output File (seen in the Advanced tab on thejob step)? We had a problem where the proxy account could not open this file, even...
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
December 5, 2003 at 4:44 am
Why is the plan bad? Is it using parallelism? Have you tried turning this off?
Also, if you have set SQL memory to the maximum on the box, 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
December 4, 2003 at 7:30 am
Your problem may be related to adjacent-key locking.
When you do a insert or delete, SQL locks the adjacent key as well as the record you are processing. This 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
October 24, 2003 at 4:30 am
Viewing 15 posts - 2,461 through 2,475 (of 2,497 total)