No announcements
Found 2230118 threads
-
0 Votes'Normalized' folders in data_index
Hello all, I really need to know what the folders in data_index called "node_host_name".normalized.xxxxxxx are for, where node_host_name is the ...
-
0 Votes
Can old (5 months - 5 years) .normalized directories be deleted from data_index?
Hi All, This is my first post, I am trying to defrag my index but space is becoming an issue. I need to know what the impact is if any of deleting .normalized ...Answered | 1 Replies | 1132 Views | Created by honkeypig - Friday, December 8, 2017 12:20 PM | Last reply by honkeypig - Tuesday, December 12, 2017 11:43 AM -
0 Votes
Get normalized query
I would like to get a single normalized query Hello, database design can ...Unanswered | 2 Replies | 385 Views | Created by bolapati - Wednesday, May 30, 2018 10:30 PM | Last reply by Olaf Helper - Thursday, May 31, 2018 6:21 AM -
1 Votes
De-Normalized DW sample??
table, instead they are in a snowflaked dimension (dbo.dimGeography). I would argue that the fields in dbo.DimGeography should be normalized ...Answered | 2 Replies | 8942 Views | Created by farhad koohbor - Tuesday, April 5, 2011 2:16 PM | Last reply by TimCost - Wednesday, April 6, 2011 1:18 PM -
2 Votes
Fully normalized database design vs de-normalized redundat database design
So you would recommend to keep database in Normalized form only. The full story is of course more complicated, all depending on what you mean ...Answered | 10 Replies | 869 Views | Created by fai_developer - Thursday, April 2, 2020 7:59 PM | Last reply by fai_developer - Saturday, April 4, 2020 9:16 PM -
0 Votes
Normalized database
,) that the student really have this data, and my problem start with this, in enrollment system student must also have requirements, (form137,goodmoral) a single student have it, my ...Answered | 1 Replies | 1314 Views | Created by alluka - Thursday, January 23, 2014 4:50 AM | Last reply by Uri Dimant - Thursday, January 23, 2014 6:14 AM -
0 Votes
Dimension Table Denormalized or Normalized
In a data warehouse usually denormalization is preferred due to faster response time as compared to nomalized schema. But it depends on your underlying structure and how you would like to ...Answered | 1 Replies | 4703 Views | Created by nadirsql - Wednesday, August 17, 2011 7:39 PM | Last reply by Umair.Khan - Wednesday, August 17, 2011 7:44 PM -
1 Votes
Normalized data
Ok, This is a completely different situation. You have an EAV model. You should have told use this. And this is your attribute-value table. Is this correct? But ...Answered | 8 Replies | 507 Views | Created by LandLord324 - Thursday, September 15, 2016 6:38 PM | Last reply by Stefan Hoffmann - Sunday, September 18, 2016 11:13 AM -
0 Votes
Real Time data repliation between Un-normalized Database to Normalized Database (Uni directional) using SSIS?
; customized replication procedures - but that can be tricky A low tech solution would be triggers on your non normalized tables - assuming your normalized ...Answered | 1 Replies | 2741 Views | Created by R.A.J.Y.A.M - Friday, April 13, 2012 2:53 PM | Last reply by Chuck Pedretti - Friday, April 13, 2012 2:58 PM -
1 Votes
display AD phone in Lync (not normalized)
This appears to be glitch or bug in both OC 2007 R2 and Lync clients. I can reproduce it each time when I: - exit ...Answered | 3 Replies | 7377 Views | Created by plug n pray - Tuesday, June 26, 2012 9:31 AM | Last reply by plug n pray - Thursday, June 28, 2012 2:03 PM -
1 Votes
Real Time data repliation between Un-normalized Database to Normalized Database (Uni directional)
Thank you Stanley. Sure i will post my requirement in SSIS forum. What do you suggest if i want to implement real time replication on UN-normalized data to a ...Answered | 4 Replies | 6058 Views | Created by R.A.J.Y.A.M - Thursday, April 12, 2012 8:56 PM | Last reply by Hilary Cotter - Monday, April 16, 2012 2:21 PM -
0 Votes
Searching normalized lists
using SharePoint lists. His lists are pretty much normalized and linked via lookup columns (as foreign keys). The amount of data in these ...Answered | 4 Replies | 1249 Views | Created by rockinik - Wednesday, March 6, 2013 2:39 AM | Last reply by Ashok Kumar Swain - Wednesday, March 6, 2013 12:19 PM -
0 Votes
un normalization data to normalized data
hi, say i have table student. Student table is normalized. But issue: few data are not normalized . now task it to make ...Answered | 2 Replies | 2735 Views | Created by Kayadhu - Friday, July 27, 2012 3:09 PM | Last reply by Jordan Johnson Business Analyst - Friday, July 27, 2012 4:18 PM -
0 Votes
transform a de-normalized fact table to normalized fact table
Lookup transform ----- ...Answered | 7 Replies | 3572 Views | Created by hkjoel - Tuesday, June 23, 2009 6:58 AM | Last reply by Jamie Thomson - Tuesday, June 23, 2009 8:25 AM -
2 Votes
From normalized table design back to un-normalized result/output
column. You need to build the pivot column by means of ROW_NUMBER() function in a temp table then use GROUP BY to pivot the two columns: /* -- Uncomment to ...Answered | 11 Replies | 4102 Views | Created by jamesfreddyc - Tuesday, December 8, 2009 3:47 PM | Last reply by phe - Tuesday, December 8, 2009 9:08 PM -
0 Votes
Star vs de-normalized Tables
Hi, A star schema is a de-normalized schema. Data cleaning and consolidation should be done in the ETL process when you load data from the source system to the ...Answered | 2 Replies | 5215 Views | Created by Roger9955 - Friday, October 8, 2010 2:07 AM | Last reply by Philip Stephenson - Friday, October 8, 2010 7:05 AM -
0 Votes
Managing Normalized Tables
What is the best way to manage Insert Update and Delete records from these tables especially insertion of records in Audit ...Answered | 2 Replies | 2699 Views | Created by Saumik - Wednesday, October 5, 2011 7:09 AM | Last reply by Kalman Toth - Wednesday, October 5, 2011 11:22 AM -
0 Votes
Comparing not normalized values
actually, just make a measure like this in the calculated member script of the cube CREATE MEMBER CURRENTCUBE.[measures].[Payment Method] asAnswered | 8 Replies | 5164 Views | Created by Uwe Braunholz - Wednesday, May 25, 2011 6:38 AM | Last reply by Uwe Braunholz - Thursday, May 26, 2011 6:22 AM -
0 Votes
EDI to Normalized SQL Database
such things as claim header data, claim detail data, vendor data, provider data, subcriber data, etc. In my normalized database I have a claimheader table, claimdetail table, ...Unanswered | 1 Replies | 9389 Views | Created by ACCDev - Thursday, March 6, 2008 2:19 PM | Last reply by Alan Smith MVP - Friday, March 7, 2008 7:44 AM -
0 Votes
Normalized phones not visible in client
Hello all, we updated the client to Skype For Business and in this client don't see 5-digit numbers in contact cards. We have a lync 2010 ...Answered | 1 Replies | 1271 Views | Created by AntoxaM - Monday, April 27, 2015 1:42 PM | Last reply by Eason Huang - Tuesday, April 28, 2015 7:44 AM - Items 1 to 20 of 2230118 Next ›
No announcements
