query

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

SQL Inspect (zip)

SQL Inspect is a SQL editor for SQL Server, created with the aim of allowing users to quickly analyze a sub-optimal query, the tables and indexes used by that query, and record all results of rewriting the query. It offers the following features over standard SQL editor tools: Get an...

Tags: Query, SQL, Yohz Ventures Sdn Bhd, SQL Inspect, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2008-04-10

EMS MS SQL query 1.1

EMS MS SQL Query is a utility that lets users quickly and simply build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows connecting to databases, select tables and fields for a query, set the selection...

Tags: Graphical Interface, Query, SQL, Microsoft Corp., Databases, Programming Languages, Microsoft Windows, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Operating Systems, Hardware

Software downloads

MyZilla (exe)

MyZilla ncreases the productivity through the speed of a desktop application. If you are using multiple accounts, you'll find MyZilla as a real time saver. Manage any number of accounts inside one application. Organize your queries any way you want. You can save, edit, and delete queries at any time....

Tags: Query, Bug, Desktops, Hardware

Software downloads 2008-02-07

Search Radar for Firefox

When you search using Google or Yahoo, this plug-in displays a list of relevant search queries on the right to help you refine your search query. The suggested queries are displayed in a manner so as to not interfere with list of search results. Moving your mouse pointer over a...

Tags: Mozilla Firefox, Mouse, Query, Radar, Webaroo, Mice, Aerospace & Defense, Hardware, Peripherals, Manufacturing

Software downloads 2008-01-30

Working with LINQ in Visual Studio 2008

Last week, I introduced the basics about the .NET Language-Integrated Query LINQ technology. Now I'll cover how the O/R Designer feature in Visual Studio 2008 that allows you to use LINQ to access SQL Server. (Before diving into the code, I want to mention that TechRepublic member...

Tags: Microsoft Developer Network, Microsoft Visual Studio, Database, Query, Microsoft SQL Server, Microsoft Visual Studio 2008, Data, LINQ, O/R Designer, DataContext, Query Expression, DataClasses1DataContext, Tony Patton

Blog posts 2008-01-15

Reverse Hashing for High-Speed Network Monitoring: Algorithms, Evaluation, and Applications

A key function for network traffic monitoring and analysis is the ability to perform aggregate queries over multiple data streams. Change detection is an important primitive which can be extended to construct many aggregate queries. The recently proposed sketches are among the very few that can detect heavy changes online...

Tags: Algorithm, Query, Northwestern University, Engineering, Networking

White papers 2007-12-01

Performance Tuning BI on SAP NetWeaver Using DB2 for i5/OS and i5 Navigator

Optimal performance of BI queries relies on many factors. Size of the underlying tables, complexity of the query, existence of indexes, sophistication of the query optimizer, hardware configurations and other factors all play a role in the performance of any given query on the system. The nature of Business Intelligence...

Tags: Query, Performance, SAP NetWeaver, Netscape Navigator, SAP AG, IBM DB2, Pricing, Business Intelligence, Tools & Techniques, Performance Management, Enterprise Software, Databases, Marketing, Software, Data Management, Management, Human Resources, Workforce Management

White papers 2007-07-23

How do I... Select records for a dynamic label report in Access?

Generating reports is a big part of most database applications. Generally, a query or filter does a good job of passing only the data you want to see to the report. But it isn't always that easy. There might not be any apparent logic behind the records you want to...

Tags: Database, Microsoft Access, Query, Report, Data, Field, Record, User, Downside, Form, Table, PrintLabel, Figure E, Storage, Productivity, Databases, Hardware, Enterprise Software, Software, Data Management, Susan Harkins

Blog posts 2007-11-06

TrackMeNot (5)

TrackMeNot protects against search data profiling by issuing randomized queries to popular search-engines with fake. Protects against search data profiling by issuing randomized queries to popular search-engines with fake data. Version includes several changes such as Realtime Search-Tracking, Dynamic URL/Header Matching, Burst-Mode (default: off), and other improvements.

Tags: Query, TrackMeNot

Software downloads 2007-09-21

How do I... Retrieve a random set of records in Microsoft Access?

We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. Perhaps a manager wants to predict future growth or an auditor is looking for anomalies. Now, it would be nice...

Tags: Function, Microsoft Access, Query, Microsoft Corp., Record, Value, FieldValue, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins

Blog posts 2007-10-11

Save queries in Windows Server 2003's Active Directory Users and Computers tool

Windows Server 2003 administrators can't live without the Active Directory Users and Computers tool. Here's a quick look at the saved queries portion of the tool, which allows you to save and reuse lookups for different Active Directory AD objects. The ability to reuse queries can save time and speed...

Tags: Query, Microsoft Windows Server, Tool, Computer, Microsoft Windows Active Directory, Microsoft Windows Server 2003, Directory Services, Microsoft Windows, Servers, Enterprise Software, Software, Operating Systems, Hardware, Derek Schauland

Blog posts 2007-10-02

See SQL Server graphical execution plans in action

Execution plans are one of the best tools to use to tune your SQL Server queries. In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to...

Tags: Query, Microsoft SQL Server, Data, Server, Column, Index, Speed, Table, Execution Plan, SalesHistory, SaleID, SaleDate, PoolTable, Product, Bookmark Lookup, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman

Blog posts 2007-10-01

How do I... Print a label for an individual record in Microsoft Access?

Printing labels is a common task and simple enough if you use the Microsoft Access Label wizard. You can print thousands of labels at one time. What isn't as easy is printing a label for a single record. You have to identify the record and pass it to a label...

Tags: Database, Microsoft Access, Query, Report, Microsoft Corp., Record, Form, Printing Label, CustomerID, Productivity, Document Management, Databases, Microsoft Office, Storage, Enterprise Software, Software, Finance, Managerial Accounting, Data Management, Office Suites, Hardware, Susan Harkins

Blog posts 2007-09-24

How do I... Stress test MySQL with mysqlslap?

One of the interesting new tools in MySQL 5.1.4 is mysqlslap, a load emulator that lets you see how well a particular query set or table engine performs under high-load conditions. A query that consumes too many database resources may be the result of designing tables incorrectly,...

Tags: Query, MySQL, Client, Melonfire

Blog posts 2007-09-17

Optimize SQL Server queries with these advanced tuning techniques

Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options. The best way to tune performance is to try to write your queries in a number of different ways and compare their...

Tags: Technique, Database, Transaction, Query, Microsoft SQL Server, Statement, Server, Tim, Tim Chapman

Blog posts 2007-09-17

EMS SQL query 2007 for Oracle (zip)

EMS SQL Query 2007 for Oracle is a utility that lets you quickly and simply build SQL queries to Oracle databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query,...

Tags: Graphical Interface, Oracle Corp., Query, SQL, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2007-06-22

EMS SQL query 2007 for DB2 (zip)

EMS SQL Query 2007 for DB2 is a utility that lets you quickly and simply build SQL queries to DB2 databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query,...

Tags: Graphical Interface, Query, SQL, IBM DB2, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2007-06-22

EMS SQL query 2007 for InterBase/Firebird (zip)

EMS SQL Query 2007 for DB2 is a utility that lets you quickly and simply build SQL queries to IBM DB2 databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a...

Tags: Graphical Interface, Query, SQL, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2007-06-13

EMS SQL query 2007 for PostgreSQL (zip)

SQL Query 2007 for PostgreSQL is a utility that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set...

Tags: Graphical Interface, Query, SQL, PostgreSQL, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2007-06-13

EMS SQL query 2007 for SQL Server (zip)

EMS SQL Query 2007 for SQL Server is a utility that lets you quickly and simply build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for...

Tags: Graphical Interface, Query, Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Hardware

Software downloads 2007-06-13