Viewing 15 posts - 76 through 90 (of 130 total)
I think you are saying that you have successfully done the import using the wizard. have you tried saving the package created by the wizard and opening in BIDS...
November 8, 2011 at 12:25 pm
I found that working with Fore Each Loop Container on files I needed better information about the file properties. CodePlex has a File Properties Task that you can download...
November 8, 2011 at 11:27 am
I would suggest that you do not run this kind of reporting against a busy OLTP database. Use replication to copy the relevant tables to a reporting database and...
October 28, 2011 at 6:59 pm
I have always felt that it would be better to "profile" the production data to determine its characteristics. Then generate data that fits the character of the production data but...
July 28, 2011 at 3:54 pm
I have studied Kimball methodology extensively and have built several data marts and warehouse systems. The data in a dimensional model is actually completely normalized (nothing but keys and...
July 21, 2011 at 5:02 pm
I don't understand the reason for avoiding normalized design?
The suggested design violates first normal form and should not be considered seriously in a relational database system.
SQL_Variant...
July 21, 2011 at 2:42 pm
thanks Jeffrey. I totally agree. You probably haven't seen SQL service packs in the windows update because your thoughtfull IT peers have filtered them out.
My question...
June 24, 2011 at 12:59 pm
Looks like you are running the x64 installer on a 32-bit system but it could be something else.
June 22, 2011 at 5:19 pm
The LEFT Join means it will return every employee row regardless if there is a match in the T.Terminations table. If there is a match then it will show...
June 22, 2011 at 11:40 am
I recall figuring out that somewhere around 20 characters is the breakeven point. Less than that and varchar is using more space keeping track of the offset that it...
June 16, 2011 at 6:40 pm
If your recovery model is full then you have to do transaction log backups or the log will grow indefinately until it fills up the drive (or the 4 gb...
June 16, 2011 at 6:21 pm
Setting fillfactor is how you leave some space for new rows on an index. If you alter/rebuild an index with a fillfactor of 80 it will leave 20 percent...
June 15, 2011 at 5:17 pm
My opinion is if the table is going to be queried then build a clustered index after loading. If it is just a landing zone for data on its...
June 9, 2011 at 6:36 pm
What is the error?
June 9, 2011 at 5:48 pm
Viewing 15 posts - 76 through 90 (of 130 total)