Q&A BY TAG 'sql server'

You must sign in to ask a question. If you do not have an account, you can register here

Scheduler: Delay till the data gets loaded in actual databases
answered 27-06-2017 12:36:19 -0400

I have a scheduled VDPCache job which starts every Saturday at 12:00. The actual databases from where the cache data gets loaded will undergo a weekend processing and gets new data. Sometimes this processing will takes long time than expected. If I kee...

Answers: 2

cache DENODO denodo scheduler SQL Server

Scheduler: Truncate cache tables instead of invalidating.
answered 23-06-2017 09:17:54 -0400

I have a scheduled VDPCache job which starts every Saturday at 12:00. It invalidates the data for All Rows and load the cache every weekend . This makes the Cache Database keep a lot of invalidated data which is of no use and the disk space consumption...

Answers: 1

DENODO denodo scheduler SQL Server invalidate cache

Throwing exception com.denodo.util.exceptions.InternalErrorException: Error executing query
answered 09-06-2017 07:11:10 -0400

Hello, I am trying to run VDPCache jobs in the Scheduler. For a particular table, I gave the parameters for year column 2001, 2002, 2003......2017 so it can cache one year after the other in a sequence. But, I am seeing an error while the scheduler is...

Answers: 1

Denodo Scheduler 6.0 SQL Server

Cached data getting deleted as soon as it is done caching in SQL database
answered 06-06-2017 06:41:25 -0400

Hello, I am trying to cache the data using scheduler. There are around 30 views to be cached. 23 of them are having less data (around 10000 all together) and 7 of them are having heavy data (around 80000000 rows all together). So I created two VDPCach...

Answers: 1

Scheduler DENODO denodo scheduler SQL Server

Denodo DVP 6.0 and SQL Server Performance
answered 24-05-2017 09:07:43 -0400

Community, I'm fairly new to the forumsd, so please be patient with me. I configured a SQL Server 2014 data source using the SQL Server 2014 JDBC driver and noticed poor performance characteristics when issuing a query using a varchar field as the se...

Answers: 3

Slow Query Response SQL Server Table scans of Text fields Ignores Server Indexes

Unable to see tables VDP when connecting to a SQL Server
answered 31-03-2017 09:42:22 -0400

I'm currently able to connect to SQL server databases in my environement using the JDBC connector, when I want to create base views I expand the data source where it's only displaying SQL security roles and not any orther objects like tables and views ...

Answers: 2

base view JDBC Data Sources SQL Server

NULL is not handled in INNER JOIN
answered 17-03-2017 08:22:49 -0400

Hi, I am new with Denodo. I have two simple views. One coming from Sql Server and another Redshift. For exmaple: View 1: Name: v1 Source: SqlServer Column: col1 long View 2: Name: v2 Source: Redshift Column: col1 text In v2, col1 can be NULL. I am r...

Answers: 1

redshift SQL Server

Using NOLOCK hint in VQL Select statement
answered 20-01-2017 05:51:47 -0500

Is it possible to use NOLOCK hint in select statement on SQL Source

Answers: 1

VQL Sql performance SQL Server

JDBC connectivity to SQL Server 2008 R2 using either the JTDS or Microsoft drivers
answered 29-11-2016 07:57:47 -0500

I am running into an issue connecting to a SQL Server 2008 R2 named instance using JDBC with either the JTDS or the MS Driver. I've tried specifying just the instance (which would be ideal, as it is conceivable that with named instances they could be u...

Answers: 1

JDBC SQL Server

Privileges for SQL Server
answered 07-11-2016 08:09:53 -0500

what privileges should be given to the account connecting Denodo with the data source (SQL Server) and cache database (SQL Server)

Answers: 1

SQL Server