Data Management And Storage

Updating a View

I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ  

Share Utility Records?

I maintain utility records for several different buildings. I would like to share individual records with their supervisor. Presently, the records are stored on one excel page. I can't seem to divide up that one page into an email for each account. What would be the best program to use to store...

3 bit parity

I was just reading about parity on searchstorage.techtarget.com and have a question about 3 bit parity vs. 1 bit parity. I understand the setting to 0 for an even # of bits and setting to 1 for an odd #. Doesn't seem very reliable because you could lose 2 bits in data transmission. Just...

coordinate file import

can I import cartesian coords into acad from wordpad or exel

Longitude field

I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don't want to rely on the...

Does anyone have an MS Project file for a DW implementation they'd be willing to share?

Greetings all, As my orgaization begins the planning phase of a data warehouse implementation, I'd imagine it would be a true benefit to have a roadmap of an actual DW implementation in order to make certain all areas are addressed. Does anyone have a complete DW in MS Project form? Many thanks!...

Database Question.

Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information...

Using MAX data types in SQL Server

I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions. I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word...

Compressing Old Files

Hello, I would like to know the option(Compressing Old Files) which comes up during disk cleanup in win XP and win 2000. Is it good or bad? I mean, If I do the compression regularly will that effect my system/files in a long run? Is it same to that option (compress drive to save space) in disk...

Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2

I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I borrow a...