|
| |
| | Microsoft SQL Server: Alter SQL server 7 table field |
 | | I have to alter the fields to merge two tables. | | | Is it possible to alter the position of the field in the table. | | | Is it possible to alter the position of the field in the table -- Not yet. |
|
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20944731.html
(1308 words)
|
|
| |
| | OLAP/BI/IM stuff: [wish] "CREATE TABLE ... LIKE" in SQL Server 2005 |
| | This can be particularly useful in creating new tables to be added to an existing MERGE table. | | | As far as I know, this will not be supported by T-SQL, despite all the other SQL enhancements in Yukon. | | | You can copy everything except the keys / indexes with "SELECT INTO": |
|
http://duncanlamb.blogspot.com/2005/03/wish-create-table-like-in-sql-server.html
(1308 words)
|
|
| |
| | Rollback merge replication? |
| | Also, this size is configarable using the xxxChangesPerBatch paramerters on the merge agent. | | | Have a look at the merge agent profile - you should see them all there. | | | Merge replication takes place in batches, so if the connection is dropped in the middle of a batch, the initial commmands in this batch will be rolled back. |
|
http://www.droptable.com/MS_SQL_Server_Replication/m7767-Rollback_merge_replication.htm
(1308 words)
|
|
| |
| | Qube System Requirements |
| | Also the following products were used when testing Qube in this environment: Microsoft SQL 2000 Enterprise Edition, Microsoft Exchange 5.5, Citrix NFuse 1.51, and Citrix ICA Win32 Web Client. | | | Hard drive with 300 MB of free hard disk storage space (additional hard disk space may be needed based on quantity of Word merge data) | | | Note 4: It is permissible to use the Qube SQL Server as the MyAdvent® SQL Server, provided the Axys Report module is configured to run on a separate machine. |
|
http://www.advent.com/products/qube/index.asp
(469 words)
|
|
| |
| | Oracle performance tuning with indexes |
| | This text details the process of creating all of Oracle's index tree structures and offers specialized tips and techniques for ensuring SQL queries are serviced using the fastest and most efficient indexing structure. | | | Oracle uses a specialized optimizer method called a bitmapped index merge to service this query. | | | In a bitmapped index merge, each Row-ID, or RID, list is built independently by using the bitmaps, and a special merge routine is used in order to compare the RID lists and find the intersecting values. |
|
http://www.dba-oracle.com/art_9i_indexing.htm
(1203 words)
|
|
| |
| | BDE Developer Support - Latest BDE / SQL Links Update |
| | BDE Developer Support - Latest BDE / SQL Links Update | | | BDE 5.2 MSI Merge Module French Enterprise version (9,690,245 bytes) | | | BDE 5.2 MSI Merge Module English Enterprise version (9,676,931 bytes) |
|
http://www.borland.com/devsupport/bde/bdeupdate.html
(1203 words)
|
|
| |
| | Kimberly L. Tripp: Improving *my* SQL skills through your questions! - Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005 |
| | When a partition function goes through a merge of a boundary point, that boundary point is essentially removed. | | | In SQL Server 2005, you can create truly Partitioned Objects (objects are inclusive to Tables and Indexes) and to create a partitioned table you must base that table on a Partition Scheme (PS) and the PS must be based on a Partition Function (PF). | | | So, if this partitioned table is NEVER going to be modified and you never need to plan for a merge or split, then you can choose whatever definition is easier for you to use. |
|
http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=cf223632-c93b-4242-b0f2-af493e051266
(1886 words)
|
|
| |
| | Choosing and Using MSDE 2000 as the Database Engine for Your Application (Microsoft Data Engine (MSDE) Technical Articles) |
| | MSDE 2000 is available as a set of Windows Installer merge modules, which can be used by independent software vendors (ISVs) to install an instance of the SQL Server 2000 Desktop Engine during their own setup process. | | | MSDE enables developers to build desktop and shared database solutions that easily migrate to SQL Server when the solution must scale. | | | With support for single- and dual-processor desktop computers, MSDE 2000 is a reliable storage engine and query processor for desktop extensions of enterprise applications. |
|
http://msdn.microsoft.com/library/en-us/dnmsde/html/msderoadmap.asp
(2568 words)
|
|
| |
| | DBLP: Mauro Negri |
| | Mauro Negri, Giuseppe Pelagatti, Licia Sbattella: Semantics and Probelms of Universal Quantification in SQL. | | | Mauro Negri, Giuseppe Pelagatti, Licia Sbattella: Formal Semantics of SQL Queries. | | | Mauro Negri, Giuseppe Pelagatti: Join During Merge: An Improved Sort Based Algorithm. |
|
http://www.informatik.uni-trier.de/~ley/db/indices/a-tree/n/Negri:Mauro.html
(2568 words)
|
|
| |
| | DBLP: Goetz Graefe |
| | Goetz Graefe, Usama M. Fayyad, Surajit Chaudhuri : On the Efficient Gathering of Sufficient Statistics for Classification from Large SQL Databases. | | | Goetz Graefe: Sort-Merge-Join: An Idea Whose Time Has(h) Passed? | | | Goetz Graefe, Diane L. Davison : Encapsulation of Parallelism and Architecture-Independence in Extensible Database Query Execution. |
|
http://www.informatik.uni-trier.de/~ley/db/indices/a-tree/g/Graefe:Goetz.html
(2568 words)
|
|
| |
| | ETL Criteria |
| | The additional clickstream criteria are something that will evolve over time as ETL vendors become more sophisticated in their handling of web-based data sources, and as the web analytics vendors begin to merge with more mainstream business intelligence and ETL companies. | | | There are a number of different architectures for ETL products, from code generators to SQL rule-execution products to ETL engines. | | | In the Chapter 8 of the book, Clickstream Data Warehousing, by Mark Sweiger, Mark Madsen, Jimmy Langston, and Howard Lombard, (Wiley, 2002), we discuss issues that make clickstream data warehouse ETL different from ETL for a data warehouse with no web-based data sources, and aspects of the Âbuild versus buy decision. |
|
http://www.clickstreamdatawarehousing.com/ClickstreamETLCriteria.htm
(2568 words)
|
|
| |
| | [ Jambo! ] - DB Updates - English Amiga Board |
| | I have changed from the perl based script I was using to a PHP/SQL one (rather than write my own I went with the ILink script). | | | I hope to merge my search script with the index script in the future aswell, so Links and games can both be searched at the same time. | | | The old database has been converted and all sites in the old Jambo! |
|
http://eab.abime.net/showthread.php?t=965
(2568 words)
|
|
| |
| | searchOracle.com |
| | SearchSQLServer.com is dedicated to serving the information needs of database developers and administrators working with Microsoft's flagship database enterprise server: SQL Server and the upcoming Yukon release. | | | In order to provide you with more focused Database resources, we've decided to merge SearchDatabase.com with several targeted sites in the TechTarget network. | | | Most of your favorite Database info is now on SearchOracle.com and SearchSQLServer.com - please update your bookmarks! |
|
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214050,00.html
(183 words)
|
|
| |
| | ISO/IEC JTC1/SC34 N323: Guide to the topic map standards |
| | This language is intended to be a kind of SQL (or XML Query) for topic maps, and will greatly simplify topic map application development by making it much easier to extract information from topic maps. | | | In order for topic maps created by different parties to merge correctly it is crucial that these parties use the same identifiers for their topics. | | | This means that in order to see how a topic map engine interprets an XTM file, one could import that file into the engine, and then export it using the canonical syntax. |
|
http://www.y12.doe.gov/sgml/sc34/document/0323.htm
(2110 words)
|
|
| |
| | monotone FAQ |
| | In monotone's view, a branch is just a set of instructions about which forks you want to merge and which ones you want to remain not-merged. | | | Furthermore, monotone is very chatty with the database, often issuing hundreds of SQL commands at a time, which works fine when the "database" is just an in-process library, but would be quite slow when each command has to go out of process and come back again. | | | Monotone's internal delta storage format is byte-oriented: it is an implementation of Josh MacDonald's xdelta system. |
|
http://www.venge.net/monotone/faq.html
(2110 words)
|
|
| |
| | CS 157 Introduction to Database Management Systems -FALL, 1998 |
| | Merge all output files into one single large file and sort it. | | | The output files should looks like the sample in sql.zip and use themto upload the data to your Oracle at home. | | | In tokenizing your data, you need to combine the software tools and human judgment. |
|
http://www.mathcs.sjsu.edu/faculty/tylin/class/cs157A/auto_bk.html
(457 words)
|
|
| |
| | dBforums - Replication problem - Users |
| | I'm using merge replication from a SQL 2000 server to laptop users who are | | | Users for the most part are using NT Authentication. | | | Most of the time the laptop users will NOT be connected to the network. |
|
http://dbforums.com/t722197.html
(457 words)
|
|
| |
| | Numal Technologies - Corporate Solutions |
| | Numal develops data warehouses in both ORACLE and SQL Server environments to help turn data into information and ultimately into knowledge for better business decisions. | | | The two most common methods of the Merge-Purge process are Address Deduping and Name Deduping. | | | Address deduping is the most common, and removes duplicates based on zip code and address. |
|
http://www.numal.com/corpsolutions.html
(691 words)
|
|
| |
| | Data Management Product Data |
| | Description: SyncSort for z/OS is a high performance sort/merge/copy utility designed to exploit the advanced facilities of the z/OS operating system and zSeries computers. | | | Description: SQL Anywhere Studio is a comprehensive package that provides data management and enterprise data synchronization, enabling the rapid development and deployment of database-powered applications. | | | Description: DMExpress™ is the high-performance data transformation product for UNIX, Linux and Windows environments. |
|
http://library.fcw.com/plist/Data-Management.html
(534 words)
|
|
| |
| | Transparent Gateway for EDA/SQL |
| | The Oracle Transparent Gateway for EDA/SQL dramatically broadens the number of mainframe data sources that you can reach, integrating your legacy data into an open systems environment. | | | But accessing that information can be difficult --- particularly if your data scattered among different systems, stored in different file formats, and seemingly impossible to merge. | | | You can streamline operations, analyze data in real-time, and minimize data redundancy and inconsistency. |
|
http://www.oracle.com/technology/products/gateways/tg4edasql.html
(577 words)
|
|
| |
| | searchOracle.com |
| | SearchSQLServer.com is dedicated to serving the information needs of database developers and administrators working with Microsoft's flagship database enterprise server: SQL Server and the upcoming Yukon release. | | | In order to provide you with more focused Database resources, we've decided to merge SearchDatabase.com with several targeted sites in the TechTarget network. | | | Most of your favorite Database info is now on SearchOracle.com and SearchSQLServer.com - please update your bookmarks! |
|
http://searchoracle.techtarget.com/searchdatabase_redirect/0,295670,sid41,00.html
(203 words)
|
|
| |
| | searchOracle.com |
| | SearchSQLServer.com is dedicated to serving the information needs of database developers and administrators working with Microsoft's flagship database enterprise server: SQL Server and the upcoming Yukon release. | | | In order to provide you with more focused Database resources, we've decided to merge SearchDatabase.com with several targeted sites in the TechTarget network. | | | The site provides targeted news, expert advice, tips, search, learning guides, webcasts and research that cover all aspects of Windows-centric database design, development, administration and management. |
|
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214260,00.html
(203 words)
|
|
| |
| | Technology review: Databases |
| | True Relational DBMS use the Structured Query Language (SQL) to extract and update data and conform as closely as possible to the theoretical relational rules of normalisation. | | | Free Form databases have no structure and thus the advantages of a relational structure to create authority files where data is kept just once and concepts such as global edit and heading merge are not easy to achieve. | | | The database management functions are closely coupled with the application language and as a result Mumps is a very fast and efficient database management environment. |
|
http://www.biblio-tech.com/html/databases.html
(2454 words)
|
|
| |
| | Daffodil Replicator v1.6 with DB2 support released |
| | It is now possible to merge data between DB2 and heterogeneous remote database servers (Oracle, SQL Server, PostgreSQL, Daffodil DB and Derby) running in distributed environments. | | | The enhancements in v1.6 are the result of mutual efforts by Daffodil Software and the open source community. | | | High availability of data in distributed computing environment |
|
http://www.programmersheaven.com/d/click.aspx?ID=N3856&Rss=True
(2454 words)
|
|
| |
| | LotusScript Examples |
| | Rules for Creating LotusScript Agents that Execute from a Web Browser Sampling of SQL Statements that Can Be Used with Notes Scheduled agent that attaches file to documents. | | | How do you do a data import/merge using Lotuscript? | | | How to Use LotusScript to Prevent a User from Opening a View How to Use the LotusScript NotesItem CopyItem Method How to use @Functions in LotusScript. |
|
http://cseh.best.vwh.net/lssamples.html
(460 words)
|
|
| |
| | freshmeat.net: Project details for Agata Report |
| | Agata Report is a cross-platform database reporting tool with graph generation and a query tool like Crystal Reports that allows you to get data from PostgreSQL, MySQL, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as PostScript, plain text, HTML, XML, PDF, or spreadsheet (CSV) formats through its graphical interface. | | | You can also define levels, subtotals, and a grand total for the report, merge the data into a document, generate address labels, or even generate a complete ER-diagram from your database. | | | You can also develop reports using your PHP-GTK interface and then call them using the Agata API from an Apache or IIS-based Web application. |
|
http://freshmeat.net/projects/agatareport?topic_id=68
(202 words)
|
|
| |
| | Array value add |
| | I'll assume that you either have unique values coming in for each 'account/time' combination or that you are using SUM in your SQL statement to get your 'total' column. | | | However, I could use the merge and I am successful in my experimentation to insert the misisng month, but, the main issue is I just want the data value (of zero for the missing month) in the appropriate sequence. | | | Accuracy is needed since these values will go in to a graph. |
|
http://www.webmasterworld.com/forum88/3836.htm
(202 words)
|
|
|
