Tag: SQL Server

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 […]

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 […]

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 […]

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 […]

Missing Server Configuration Manager from SSRS Server

I had an interesting problem recently. I was doing some work for a client on a CRM deployment and a performance issue. Whilst onsite, I helped with a problem with SSRS and reports not displaying. Further investigation displayed an error that said SSRS was not using a valid execution account. The error was “The report […]