No announcements
-
0 VotesRestore 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 | 907 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 | 838 Views | Created by avivgood - Friday, November 1, 2019 12:41 PM | Last reply by Guoxiong - 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 | 1067 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 | 1288 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 | 6716 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 | 1677 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 | 8556 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 | 2602 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 ... -
0 Votes
DQS Error when try to create or open any knwoledgebase
I have an error in DQS client. When i try to create or modify any knowledgebase from DQS have this error: SQL Server Data Quality ...Unanswered | 4 Replies | 3874 Views | Created by Juan M. Alvarado - Friday, February 24, 2017 2:33 PM | Last reply by Christian 99999 - Friday, January 11, 2019 12:43 AM -
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 | 1 Replies | 2738 Views | Created by JamieDBA - Thursday, October 11, 2018 6:59 PM | Last reply by Christian 99999 - Friday, January 11, 2019 12:41 AM -
0 Votes
Project DQS Connection Manager Causes SSIS Deploy To Fail
I've run into an interesting issue when trying to deploy SSIS packages that leverage project level DQS connection managers. We're able to deploy SSIS projects ... -
0 Votes
Can we install DQS Client for SQL 2016 on Windows 7 64 bit?
Hi there, The documentation (link below) is not very clear on the OS Requirements for DQS Client for SQL 2016 - can the DQS client be installed on Windows 7 64 bit, and is ...Unanswered | 1 Replies | 2568 Views | Created by WombleUSA - Monday, November 12, 2018 6:19 PM | Last reply by Visakh16 - Monday, November 12, 2018 7:02 PM -
0 Votes
Problem installing Data quality services
I am using DQS for first time and came across DQS server installation issue, that first time I am installing DQS server then it is installed on localhost of sql server.Next time when I try to install ...Unanswered | 1 Replies | 2908 Views | Created by srm_2010 - Saturday, November 10, 2018 7:31 AM | Last reply by AV111 - Sunday, November 11, 2018 3:06 AM -
0 Votes
Data Quality service erro - Get number of logical processors failed. Check if WMI is enabled and WMIC console application is accessible.
Below is the error message encountered while installing Data Quality Services [10/24/2018 12:05:02 PM] Executing action: Register data quality assemblies and stored ... - Items 1 to 20 of 536 Next ›
No announcements
