Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But as you will soon find out while reading this article it is one of those small tweaks that can increase the performance of your query! Implicit data type conversion happens when the SQL Server detects […]
You started with a small database with only a few users, business is going great and before you know it your small database of a few GB’s grows into the TB scale with loads of users! This is great from a business point of view but VLDB’s complicate maintenance and backup/restore operations, something you didn’t […]
A question I hear a lot from fellow DBA’s is how they can minimize the impact of index maintenance in a log shipped environment for large databases. The problem with running index maintenance like rebuilds in VLDB’s is that they generate very large transaction log backups. If the SQL Server environment you manage uses log […]
SQL Server 2008 introduced a new advanced option called “Optimize for ad-hoc workloads”. According to Microsoft: The optimize for ad hoc workloads option is used to improve the efficiency of the plan cache for workloads that contain many single use ad hoc batches. When this option is set to 1, the Database Engine stores a small compiled […]
If there is one thing that can easily boost your SQL Server performance and must be indexes. Creating an index is a (pretty) easy proces but maintenance on a heavily used and big index can be real challenge, a challenge that is easily forgotten by some administrators. Not performing regular index maintenance can remove all […]