The SQL Server Interview Questions that Matter

If you’re worried about interviewing for a SQL Server job, here’s some advice from the former head of an IT department on what matters (along with examples from the three critical areas where you need to have answers ready). As an instructor for Learning Tree’s Querying SQL Server 2014 and 2016 courses, I’ve worked with […]
Read More ›

Viewing the SQL Server Procedure Cache with DMVs

In the previous blog, we took a quick look at query plan caching using the classic but still serviceable syscacheobjects view. A serious journey of exploration into the SQL procedure cache must, however, begin with the dynamic management view sys.dm_exec_cached_plans. While this view does provide us with some interesting information in its own right, the […]
Read More ›

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 ›

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 ›

Apply the Openrowset Function to Acquire Rowsets

In the previous blog on SQL Server’s OPENROWSET function we observed that while OPENROWSET is most often encountered in relation to linked servers, it is also valuable for directly reading flat files. It’s worth taking a moment to mention another less common application of OPENROWSET ( ). If you wanted to write code that returned […]
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.