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

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

How to fetch Current Date Records from a table
answered 25-10-2016 07:27:32 -0400

Team, We are using Denodo as Database. I have a table and I should not hard code the current date. I tried using currentdate, sysdate and the SQL is throwing error. Please help me on this! select * from EMP where EMPdate='2016-10-24' Thanks! Kiran

Answers: 1

denodo 6.0 SQL Server

How to connect MySql5 to Denodo
answered 03-10-2016 19:31:52 -0400

Hi Expert Team, I am using Denodo Express Tool and I am very new user . I am taking help from Tutorial . I have intsalled My Sql5 on my Machine and created new Schema as Ganesh . In Ganesh , I have created database as 'acm_cm1' and under which I hav...

Answers: 1

SQL Server

Unable to see SQL Server tables in VDP
answered 09-05-2016 05:02:24 -0400

Hi, I was able to create a JDBC connection to SQL Server. However, I'm unable to see the tables when I go to the 'Create base view' tab. The test ID was given full admin rights to the schema. And I'm able to query the tables successfully within SSMS. ...

Answers: 4

VDP SQL Server