Explore the Benefits of Covering Indexes

Sometimes the old ways are still the best- even in technology. Long before there was an SQL Server, database professionals made advantageous use of the “covering” index, so-called because the columns used in the index cover all the requirements of a particular query of special interest. Let’s take a look at a class covering indexes […]
Read More ›

Optimize Your SQL Server Queries with Column Statistics

Have you ever done something that your mother told you to never ever do? Well, we’re going to do that today, except with SQL Server. We’re going to get rid of SQL Server column statistics with the goal of learning what column statistics are and how they help SQL Server arrive at superior query plans. […]
Read More ›

How to Import Data from R Scripts into Power BI

Power BI can obtain datasets from R scripts, though as of the September 2016 release of Power BI the integration is not so slick. For example, we may wish to explore a possible log-linear relationship in our data or the potential of a polynomial relationship. While we could, in principle, add columns to a dataset […]
Read More ›

How to Use the OPENROWSET Function to Read Text Files

Fayed, a student in Learning Tree’s Introduction to SQL Server, asked how to import text files into SQL Server. Quite a difficult question, actually, because there are many different ways. The hardest part is choosing the method that is best for the task at hand. Today we’re going to take a look at reading text […]
Read More ›

Error Handling in Power Query

Hopefully, this blog will quickly become outmoded and useless and I will have wasted my time. Error handling in the Power Query Formula Language, most often simply called “M”, is weak compared with most modern programming environments, and the developers at Microsoft will no doubt address these issues and provide a better system. But, for […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.