Batch Mode Processing for Row Data in SQL Server 2019

Batch mode processing was introduced in SQL Server in 2012, the same time as columnstore indexes. The combination of the two prevented SQL Server from needlessly processing column values not needed by a query, as it must do in classic row processing. This processing mode also permits SQL Server to take better advantage of cache […]
Read More ›

SQL Server: Users Without Logins?

Anna P., a student in Learning Tree’s course 8420, Querying Data with Transact SQL, asks “What good is an SQL Server user with no login?”. No good at all, if you think of users just as people. Clearly, people need to login before they can use SQL Server. However, users can also be thought of […]
Read More ›

UTF-8 Support in SQL Server 2019

UTF-8 has been the predominant character encoding system for the world-wide web since 2009 and as of October 2018 accounts for over 90% of all web pages. As of October 2018, UTF-8 is not supported by Microsoft SQL Server. SQL Server 2019 will remedy this situation, as current SQL Server community technology previews illustrate. The […]
Read More ›

Your Linear Regression Need Not Be Linear

Anyone who has ever done a linear regression in R has seen an R formula. R formulae are examples of the Wilkinson notation, sometimes called the Wilkinson-Rogers notation. This same notation is used by other applications including Matlab and Octave to indicate relationships between variables. In most cases, R users have seen the Wilkinson notation […]
Read More ›

Using .RProfile to Customize your R Environment

When R starts up, it looks for several files to initialize its configuration. R has its own configuration file called Rprofile.site located in the /etc folder. It is probably wise not to mess with this file unless you are very confident in your understanding. Most R users are aware that during startup, R reads an […]
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.