No announcements
Found 537 threads
-
0 VotesDuplicate Remove
i have a table called memebrs which consist of memberid(Autogenerated), First name, lastname, dob, and so on... but since user clicked twice or thrice during ...Proposed | 5 Replies | 4276 Views | Created by Jhonme - Tuesday, March 12, 2013 12:47 PM | Last reply by Laxmidhar sahoo - Sunday, August 23, 2020 2:24 PM
-
0 Votes
Data Quality Services error - Sequence contains no elements
I am trying to create a new knowledge base by importing from a DQS file. This worked for the initial set of files, but when trying to import new versions of them receive the follow unhandled ...Unanswered | 2 Replies | 6337 Views | Created by JamieDBA - Thursday, October 11, 2018 6:59 PM | Last reply by OluwaT - Monday, August 17, 2020 1:20 PM -
0 Votes
Match Policy Rules Help with SQL DQS
Hello Community, I have been following a udemy course on DQS. I'm at the Matching Policy Stage, and I understand creating a Matching Policy is interactive. ... -
0 Votes
DQS installation Error
Running File: drop_all_assemblies.sql [16/03/2020 4:38:04 pm] ---[ Dropping all SSDQS Executable Objects ]--- [16/03/2020 4:38:04 ...Unanswered | 0 Replies | 1851 Views | Created by Newbie ETL Developer - Monday, March 16, 2020 12:46 PM -
1 Votes
DQS missing from Master Data Services Excel Add-in
Hi, I installed SQL Server 2012 (RTM) on my local machine and have configured both MDS and DQS in addition to installing the MDS Excel Add-in for Excel 2010 (32-bit). As part ...Unanswered | 4 Replies | 14507 Views | Created by Patrick Brady - Friday, March 30, 2012 3:25 PM | Last reply by Shivendoo Kumar Dubey - Thursday, February 27, 2020 6:16 AM -
0 Votes
Anyone please help me
lease prepare 1. High-level design (Table structures, ...Unanswered | 1 Replies | 2968 Views | Created by Guna Varalakshmi - Wednesday, January 22, 2020 10:11 AM | Last reply by Tom Phillips - Wednesday, January 22, 2020 12:52 PM -
0 Votes
Restore a database
Hi, I have a 327069 GB database backup file. to restore a this much size db, approximately how long time required and how much space required in a c ...Unanswered | 2 Replies | 4095 Views | Created by privya - Tuesday, October 22, 2019 7:06 AM | Last reply by jchang61 - Tuesday, November 26, 2019 10:14 PM -
1 Votes
How can I add a minimum length of characters in a varchar?
I have a table: create table "Users" ( Email VARCHAR(320) COLLATE SQL_Latin1_General_CP1_CI_AS Primary key, Psw varchar(32) COLLATE ...Answered | 3 Replies | 4518 Views | Created by avivgood - Friday, November 1, 2019 12:41 PM | Last reply by Guoxiong Yuan - Friday, November 1, 2019 2:34 PM -
0 Votes
Why IndexOptimize cannot reduce fragmentation of clustered index?
90% fragmentation. Why this stored procedure works on some indexes but not on some others? Is there other way to bring Fragmentation ...Unanswered | 4 Replies | 4470 Views | Created by LW1990 - Friday, September 20, 2019 8:27 PM | Last reply by Tom Phillips - Thursday, September 26, 2019 2:17 PM -
0 Votes
Data Sanitization Tool
Can any one help me inform about the Data Sanitization Tool of Microsoft ? Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This ... -
0 Votes
SQL management studio switching sessions issue
hi, i'm facing an issue on SQL server V18.1, which is when opening more than a query session and switching between them, the session ID changes but keeping the displayed query of ... -
0 Votes
BCP format with SPACE in column name
Does anyone know how to auto-remove the space in between column name generated from bcp -f .fmt format file in bcp script?Unanswered | 1 Replies | 4522 Views | Created by 64mao - Tuesday, July 30, 2019 9:14 PM | Last reply by Olaf Helper - Wednesday, July 31, 2019 6:08 AM -
1 Votes
DQS not removing special characters
I am using DQS and I have a Domain for which I checked the box for 'Normalize String' and give output in the form of ...Proposed | 6 Replies | 10097 Views | Created by vaibkv - Tuesday, August 13, 2013 6:48 PM | Last reply by Ghalib_Mustafa - Monday, June 24, 2019 2:49 PM -
0 Votes
System.Runtime.InteropServices.COMException error while using DQS connection manager
System.Runtime.InteropServices.COMException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem ... -
0 Votes
Differences in query time on two the same bases
Hi, I've got a problem with two identical databases. The structure is the same, indexes are the same, there are on the same machine, the same disc, the same settings. The only ... -
0 Votes
Is there any way to updating DQS KB automatically from a specific table using any kind of job?
Hi, we are working on a enterprise data warehouse project for our client and we have planned to maintain a metadata repository for our project to standardize things up. Now, we are trying to figure ... -
0 Votes
Best process to shrink db files
Hello All, What is the best process to shrink db files (not log files). Is there a calculation that tells us to what size to shrink? Links to documents will of great ...Answered | 3 Replies | 4719 Views | Created by LisaKruger - Monday, May 6, 2019 7:08 PM | Last reply by LisaKruger - Wednesday, May 8, 2019 3:06 PM -
0 Votes
DQS Installer ( DqsInstaller ) syntax error
I am getting a syntax error when executing DqsInstaller i am running sql 2012 cu3 here is the log file. Microsoft (R) DQS Installer Command ...Unanswered | 3 Replies | 11927 Views | Created by MelColo - Monday, October 1, 2012 2:33 PM | Last reply by mkp19 - Wednesday, January 30, 2019 10:36 AM -
0 Votes
SSIS Packages With DQS Constantly Hang
I've got several SSIS packages which use DQS Cleansing components. These all used to run just fine. They were never super fast, but at least they finished running. Now suddenly, ...Discussion | 2 Replies | 5914 Views | Created by ansonee - Thursday, November 29, 2018 11:00 PM | Last reply by adas0496 - Saturday, January 26, 2019 6:53 AM -
0 Votes
DQS client not able connect to DQS server
I am trying to set-up logging in DQS as per the following ... - Items 1 to 20 of 537 Next ›
No announcements
