Software Vendor Mistakes With SQL Server: Lowering Fill Factor For Every Index

I can’t remember the last time I saw someone lower fill factor for a good reason. Perhaps those just aren’t the type of folks who need my help, or perhaps…

Read the post: Software Vendor Mistakes With SQL Server: Lowering Fill Factor For Every Index

Software Vendor Mistakes With SQL Server: Not Using Filtered Indexes Or Indexed Views

In yesterday’s post, we covered some of the basics of designing nonslustered indexes to make queries go faster, but sometimes those aren’t quite enough.

Read the post: Software Vendor Mistakes With SQL Server: Not Using Filtered Indexes Or Indexed Views

Software Vendor Mistakes With SQL Server: Not Letting Customers Add Indexes

If your developers could intuit every possible way that your application could be used, and were really good at performance turning SQL Server, you…

Read the post: Software Vendor Mistakes With SQL Server: Not Letting Customers Add Indexes

Software Vendor Mistakes With SQL Server: Modifying Millions of Rows At A Time

I often see people get stuck hard by this. Even worse, it happens when they’re using a merge statement, which are like throwing SQL Server a knuckleball.

Read the post: Software Vendor Mistakes With SQL Server: Modifying Millions of Rows At A Time

Software Vendor Mistakes With SQL Server: Passing Long IN Clauses To Queries From An ORM

When it comes to weird performance problems, I’ve seen this cause all sorts of them. The worst part is that there are much smarter ways to handle this.

Read the post: Software Vendor Mistakes With SQL Server: Passing Long IN Clauses To Queries From An ORM

Software Vendor Mistakes With SQL Server: Sticking With ORMs And Not Using Stored Procedures

If you have a small to medium sized application, and your developers are highly skilled not only in their preferred method of development, and you have…

Read the post: Software Vendor Mistakes With SQL Server: Sticking With ORMs And Not Using Stored Procedures