Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Exploring the window functions in SQL Server 2005
- Maybe I'm missing the significance of this?I don't get the usefulness of this technique. I even looked at the MSDN documentation, and I still see no reason to use it. This accomplishes nothing that I can't do with some sub-query work, at least as far as I can tell.Hopefully someone...
- Tags: Process improvement, Microsoft SQL Server 2005, Microsoft SQL Server, MichelliL@..., window, ut.sCode, u.hMy, join, p.sAddr1, Group-By
- Discussion threads 2007-03-20
- Learn how to join tables in MySQL
- This sample chapter, taken from MySQL Crash Course, discusses what joins are and how you can use them to create SELECT statements. Joins are one of the most important operations you can perform using SQL SELECT, and a good understanding of joins and join syntax is an...
- Tags: Sams Publishing, MySQL, Join, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2006-03-14
- Working with nested subqueries in SQL Server
- Example: Bad! Subqueries: WORSE!Firstly, the example given here is an extremely poor one because Using IN creates a temp table for every item in the IN list. If each of these subqueries only returns 10 records, this query will create 1000 temp tables. Very inefficient. SQL is not designed to...
- Tags: subquery, Jeff_D_Programmer, sql scripting, software, programming, queries, sql, sql query, query, join, Microsoft SQL Server, server
- Discussion threads 2007-01-30
- Look up values in SQL Server using range joins
- Arthur Fuller wants to shake up developers' assumptions that joins are always tests of equality. He explains that there are lots of ways to join, and demonstrates how you can use range joins to match a potentially large number of rows. It's a myth that joins are always tests...
- Tags: Microsoft SQL Server, Arthur Fuller, Databases, Network technology, server, join, SQL Server Newsletter, TechRepublic Inc., Row, Table, Listing D, Listing E, Listing F, Listing G, Listing H, Insurance, Financial Planning, Enterprise Software, Business Operations, Corporate Insurance, Finance, Software, Data Management, Networking
- Technical articles 2006-05-15
- An Asynchronous Messaging Library for C#
- The authors present the design of a small number of application level communication coordination constructs which can be hierarchically combined to allow the expression of sophisticated and flexible communication patterns. They are able to express join patterns found in languages like Comega by providing a library based implementation rather than...
- Tags: Join, Messaging, C#, .Net, Programming Languages, Groupware, Software Development, Software/Web Development, Enterprise Software, Software
- White papers 2005-10-13
- Join a query with one of the Tables used to generate the query
- Hi to everybody,I would like to know if it's possible to do this in MSAccess SQL:Select * FROM (table1 LEFT JOIN table2 ON table1.field1 = table2.field1) LEFT JOIN table2 ON table1.field2 = table2.field1Note that table2 is being used twic
- Tags: join, sql, programming, access, software, microsoft, windows, Table2, LEFT JOIN, rayasta@..., Table1, Table1.field1
- Discussion threads 2006-12-13
- Questions to ask a SQL Server database developer applicant
- Hiring a DBAI'd hand them a computer with a badly designed local database on it and ask them to identify some problems with it.Make it something with 3 or 4 tables, maybe a customers table and a contacts table and an orders table. Name the tables Table01, Table02, Table03,...
- Tags: database, dba, gsquared, hiring, it management, join, Microsoft SQL Server, sql
- Discussion threads 2006-10-17
- Optimizing searches in an OLTP database
- Find out why Arthur Fuller decided to throw 20 years of assumptions about data singularity out the window when he discovered the effectiveness of optimizing searches in an OLTP database. Based on his experiments, he notes that the performance effects of using this approach are profound. While eating dinner...
- Tags: OLTP, Databases, Arthur Fuller, database, join, data entry, SQL Server Newsletter, TechRepublic Inc., Trigger, Lookup, Data Singularity, Storage, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2005-06-13
- Photo: Moby joins Net neutrality fray
- At Washington press conference on Thursday, musician calls for new "Net neutrality" laws.
- Tags: join, musician, Net Neutrality, photograph, Washington
- Image galleries 2006-05-18
- recursively looping over a table to find most similar profiles (matching an
- I have a simple MSSQL 2000 table with only 3 columns:question_user_userID int 4question_user_questionID int 4question_user_questionanswer int ...
- Tags: chzumbrunnen@...
- Discussion threads 2006-05-16
- Look up values in SQL Server using range joins
- Be careful when dealing with floating numberNice, but rather than altering MinWeight to 1.01 we should alter the join condition with x < 1 and x = dbo.ShippingRates.MinWeight AND dbo.Shipments.Weight < dbo.ShippingRates.MaxWeight)
- Tags: Look-up, MinWeight, sql, join, sanjaya.tio@..., software, Microsoft SQL Server, server
- Discussion threads 2006-05-16
- Learn how to join tables in MySQL
- Joins are one of the most important operations you can perform using SQL SELECT, and a good understanding of joins and join syntax is an extremely important part of learning SQL.This sample chapter, taken from MySQL Crash Course, teaches you what joins are, why they are used, and how to...
- Tags: Databases, MySQL, MySQL Crash Course, Published, SQL, join
- Download resources 2006-03-14
- Cannot log Windows 95 machine into 2003 domain!
- I have a windows 95 machine with voicmail software on it. Is there a way I can get it to connect to the domain. We recently added a 2003 domain controller and all the issues started after that.I created a virtual network and install, dfs, dup update, and...
- Tags: 95, domain, hardware, join, Microsoft Windows, Microsoft Windows 95, password, truwarrior22@...
- Discussion threads 2006-01-27
- Understand the ambiguities of compound JOINs in SQL
- good use of on clauseActually, I do use elements of the on clause that only reference one table to good effect. I use it when the table I'm joining with has a lot of records in it that I would like to filter out before joining, (e.g. a description lookup...
- Tags: clause, dbo.Customers.CustomerID, dbo.Orders.CustomerID, dominic@..., join, joins, software, SQL, sql server
- Discussion threads 2005-11-15
- Join Clients to New Domain w/Script
- Does anyone have a script that will allow me to join multiple computers to a new domain without going to each computer and removing from old domain and joining to new domain? This is a small Church network, and time and resources are limited.If this is an Active Directory...
- Tags: domain
- Q&A 2005-08-12
- JOIN table and stored procedure
- Is is possible to JOIN a table and the results of a stored procedure (ANSI SQL, Oracle, MySQL or SQL Server)join...You would have to put the results of the stored proc in at least a temp table, then do the join. Is that what you are looking for? ...
- Tags: Databases
- Discussion threads 2005-02-25
- SQL Join
- HiI have 2 tables that I want to join, the two fields I wish to join on are both the same data type "VARCHAR2(20)" however field one contains data in the format "99999999" while field two contains data in the format "99999999/9". There is a unique match on characters 1-8...
- Tags: graemeduncan@..., inner join, join, software, SQL
- Q&A 2005-02-08
- Forced to Join Unions?
- TechRepublic members, "Scott Edstrom" and "olprof67" are mad because they feel like they've been *forced* to join a Union.(http://techrepublic.com.com/5208-6230-0.html?forumID=8&threadID=163791&messageID=1679995)In the US, you don't have to join a union if you don't want to. But some people, like these two, choose to take a job that has Union membership as...
- Tags: job, Forced, Join, Union, Bucky Kaufman (MCSD), career
- Discussion threads 2004-11-26
- Understanding the performance statistics from MySQL's SHOW STATUS command
- Beyond the basic SHOW STATUS statistics I describedearlier, the command also offers more technical data which can be used toassess things like memory usage, cache performance, and resource allocation.Here are some of the important variables in this category.Open_tables, Opened_tablesThis statistic shows you the number of tables currentlyopen, while the Opened_tablesvariables...
- Tags: Guest Contributor, MySQL, statistic, join, Opened_tables, SHOW STATUS, performance
- Technical articles 2004-05-21
- Join Excel
- How can I merge multiple Excel spread sheets based on SSN field?Thankstry vlookup function
- Tags: career, ichu50, Join, Microsoft Excel
- Q&A 2004-11-01
