By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
Beginning with SQL Server 2012 and beyond, Microsoft has developed a new feature in all editions of SQL Server that allows us to create databases independent of the instance hosting that database. In this article I will cover some of the features, pros and cons, and how to create a contained database. What is it? […]
Continue readingBy Jeffry Schwartz | Advice , Intermediate , Performance Tuning , SQL Development , SQL Server
-by Jeffry Schwartz Queries with multiple join clauses create particularly difficult issues when they perform poorly. Join ordering is extremely important because if a join creates a huge interim result set at the beginning of the query execution, SQL Server must continue to handle this result set until it can be trimmed down with filtering […]
Continue readingBy Lori Brown | Advice , Budgeting , Offer , SQL Server , SQLRX
— By Lori Brown @SQLSupahStah This is a bit off from our normal technical blog posts but, hey, if you can’t go out on a limb on your own blog, what good is it? After doing cleanup on systems over the years, I started thinking about why some servers seem to be so poorly configured. […]
Continue reading