Tools to Aid your SQL Server Plan Cache

In a recent blog post, we looked at how SQL Server uses its index statistics to help determine an optimal query plan. We will soon look at several examples of the interaction between query plans and the plan cache, but before we do we must develop a set of tools to aid the effort. SQL […]
Read More ›

Optimize SQL Server Queries with Index Statistics

Television’s Mythbusters seem to have a lot of fun; it’s interesting that so many myths seem to involve blowing stuff up on camera. SQL myth-busting may not be as visually dramatic, but for people who are interested in query performance, it is much more important. There are a lot of people who think that it […]
Read More ›

Querying SQL Server Data from R Using RODBC

In the previous blog, we looked at some of the annoyances encountered when installing RODBC on Linux. Of course, RODBC can also be used in R running on Windows. In either case, running queries using RODBC is straightforward and without surprises. As is always the case, the first thing we need to do is connect. […]
Read More ›

Analyzing SQL Server Data with R and RODBC

Down the Rabbit Hole with RODBC The most direct method for reading SQL Server data into the statistical program R is with ODBC. If R is running on a Windows system, this is straightforward using the R package RODBC. On a Linux system, the installation of RODBC is more challenging. Of course, RODBC requires a […]
Read More ›

SQL Server on Linux: Using LibreOffice Base as a Client Application

Run sqlcmd on Linux or the SQL Server Managment Studio on Windows? As of November 2106, those are the only two choices provided by Microsoft to serve as a client to SQL Server vNext running on Linux. There are, however, other alternatives and one, in particular, might be attractive to folks looking for a graphical […]
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.