Development

Optimizing SQL Server Files and File-Groups Made Easy

Recently I had the opportunity to work with a client on a very large Web Application; the database for this application was composed of hundreds of tables, indexes, file-groups, and files; including a dozen partition-functions and as many partition-schemes, spanning both clustered and non-clustered indexes. The client was requesting to improve performance in their database…

Read More