IT Answers » Data management and storagehttp://itknowledgeexchange.techtarget.com/itanswers
Tue, 03 Mar 2015 21:24:36 +0000en-UShourly13 bit parityhttp://itknowledgeexchange.techtarget.com/itanswers/3-bit-parity/
http://itknowledgeexchange.techtarget.com/itanswers/3-bit-parity/#commentsThu, 23 Apr 2009 18:33:17 +0000http://itknowledgeexchange.techtarget.com/itanswers/3-bit-parity/feed/0Does anyone have an MS Project file for a DW implementation they’d be willing to share?http://itknowledgeexchange.techtarget.com/itanswers/does-anyone-have-an-ms-project-file-for-a-dw-implementation-theyd-be-willing-to-share/
http://itknowledgeexchange.techtarget.com/itanswers/does-anyone-have-an-ms-project-file-for-a-dw-implementation-theyd-be-willing-to-share/#commentsSat, 05 Jul 2008 12:56:52 +0000Greetings 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!
Da Celt

]]>http://itknowledgeexchange.techtarget.com/itanswers/does-anyone-have-an-ms-project-file-for-a-dw-implementation-theyd-be-willing-to-share/feed/1Compressing Old Fileshttp://itknowledgeexchange.techtarget.com/itanswers/compressing-old-files/
http://itknowledgeexchange.techtarget.com/itanswers/compressing-old-files/#commentsMon, 16 Jan 2006 06:37:28 +0000http://itknowledgeexchange.techtarget.com/itanswers/compressing-old-files/feed/2How do I restore my SQL .bak file over the existing database?http://itknowledgeexchange.techtarget.com/itanswers/how-do-i-restore-my-sql-bak-file-over-the-existing-database/
http://itknowledgeexchange.techtarget.com/itanswers/how-do-i-restore-my-sql-bak-file-over-the-existing-database/#commentsTue, 13 Jul 2010 17:31:05 +0000http://itknowledgeexchange.techtarget.com/itanswers/how-do-i-restore-my-sql-bak-file-over-the-existing-database/feed/3Updating a Viewhttp://itknowledgeexchange.techtarget.com/itanswers/updating-a-view/
http://itknowledgeexchange.techtarget.com/itanswers/updating-a-view/#commentsThu, 08 Oct 2009 20:00:04 +0000I 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

]]>http://itknowledgeexchange.techtarget.com/itanswers/updating-a-view/feed/1Share Utility Records?http://itknowledgeexchange.techtarget.com/itanswers/share-utility-records/
http://itknowledgeexchange.techtarget.com/itanswers/share-utility-records/#commentsFri, 24 Apr 2009 18:47:52 +0000I 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 individual building stats and then email them to each supervisor?
]]>http://itknowledgeexchange.techtarget.com/itanswers/share-utility-records/feed/1coordinate file importhttp://itknowledgeexchange.techtarget.com/itanswers/coordinate-file-import/
http://itknowledgeexchange.techtarget.com/itanswers/coordinate-file-import/#commentsTue, 07 Oct 2008 20:54:10 +0000can I import cartesian coords into acad from wordpad or exel
]]>http://itknowledgeexchange.techtarget.com/itanswers/coordinate-file-import/feed/0Longitude fieldhttp://itknowledgeexchange.techtarget.com/itanswers/longitude-field/
http://itknowledgeexchange.techtarget.com/itanswers/longitude-field/#commentsWed, 10 Sep 2008 13:42:24 +0000I 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 user to remember to put a negative sign in front of their longitude data at the time of input. Is there a way that I can set up the field to automatically put a negative sign in front of the longitude value, if the user forgets to do it? Basically, I want to make sure that all data in the longitude field starts with a negative sign.
]]>http://itknowledgeexchange.techtarget.com/itanswers/longitude-field/feed/0Database Question.http://itknowledgeexchange.techtarget.com/itanswers/database-question/
http://itknowledgeexchange.techtarget.com/itanswers/database-question/#commentsWed, 02 Jul 2008 17:33:20 +0000Hello 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 about different years growth statistics before and after working with our company. They have requested that the database be easily updatable and produce good reports. I was wondering if I need a database at all? Also which database would be the best for handling a project like this?
]]>http://itknowledgeexchange.techtarget.com/itanswers/database-question/feed/1Using MAX data types in SQL Serverhttp://itknowledgeexchange.techtarget.com/itanswers/using-max-data-types-in-sql-server/
http://itknowledgeexchange.techtarget.com/itanswers/using-max-data-types-in-sql-server/#commentsThu, 20 Dec 2007 18:03:14 +0000I’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 Documents, etc. in the data base. If this is true, what is the method used to store the document in the data base? What is the max length of the Command String that is submitted to SQL Server?
]]>http://itknowledgeexchange.techtarget.com/itanswers/using-max-data-types-in-sql-server/feed/1