I agreewith Frank kalis. A single Database approach is the place to start.I don't know why you are even contemplating multiple Database at this stage! The fist stage is to come up with a Conceptual Model and then ascertain.
2004-02-23
Iam not sure to use via XML but anyway i will try it later , but BCP sounds useful,can u pls specify clearly how to use BCP and from where i can get it. thanks to David and Sholliday
2004-02-17
thanks a lot tomash I will use temp tables instead of table data types
2004-01-29
1 reads
Well it can actually depend on yuor version of SQL and some settings I forget. If you store as a string and compare to a string SQL in most cases will compare as string, if comparing to a date SQL may convert to a compatible date format (it is a real value with whole number […]
2004-01-23
For 6.5 run regedit - Go to HKEY_CURRENT_USER/Software/microsoft/MSSQLserver/SQLEW/Registered servers and then double click on the required one.THe SA will be on the right of the screen vertically.Don't tell anyone this came from me - And I never use it because I never, ever forget my SA password as they are stuck on my screen with […]
2004-01-16
8 reads
Although SQL Server can store, index and search (to a certain degree) complex (non atomic) data types, it offers no native support for them. BLOB's like audio, video are huge, non-atomic data types that consists of parts and subparts and that's non so easy to represent int a relational db. BLOB's are mostly stored outside […]
2003-10-06
To use a checksum to determine row changes you need to have a unique key so that individual rows can be identified. (Checksum does not work on text, ntext, image, timestamp or ROWGUID data types.) One manner in which I have used checksum is to create a checksum table for each table I wish to […]
2003-08-28
The ANSI standards refer to the ISO standards. If you need the ISO SQL specs, I would suggest purchasing them from ISO.org. Both ANSI and ISO sell copies of their standards as one method of covering the cost of creating and revising the standards.(http://www.iso.org/iso/en/StandardsQueryFormHandler.StandardsQueryFormHandler?scope=CATALOGUE&sortOrder=ISO&committee=ALL&isoDocType=ALL&title=true&keyword=sql) Corrigendum are frequently publish and are usually available for free at […]
2003-08-05
1 reads
2003-07-29
What are the criteria SQL Server uses when deciding to auto update statistics? And, what sample does it use - presumable not 100%? Andy
2003-07-25
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers