Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Fine-tune your Access queries to remove duplicate entries from your mailing lists
- If you query your Access database to generate a mailing list, but the list contains duplicate names and addresses, this helpful trick will save you some time. See how tweaking the query properties can ensure a list with unique entries. by Mary Ann Richardson
- Blog posts 2008-08-04
- Behavioral targeting: What you need to know
- Behavioral targeting is advertising's attempt at supplying you with specialized ads developed from your Internet history. The intent of this article by Michael Kassner is to shed light on how behavioral targeting works and how it could affect you. by Michael Kassner
- Blog posts 2008-07-31
- Why isn't my subquery updateable?
- The best of intentions often fail when writing a subquery. If you can't update your data via a subquery, there's an alternative. by Susan Harkins
- Blog posts 2008-07-18
- When Access queries won't update
- Access queries aren't created equal. If you can't edit data via a query, there's a reason. Here are some typical conditions that can prevent queries from being "updateable." by Susan Harkins
- Blog posts 2008-06-20
- 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...
- Blog posts 2008-01-15
- 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...
- Blog posts 2007-11-06
- 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...
- 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...
- 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...
- 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...
- Blog posts 2007-09-24
- 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...
- Blog posts 2007-09-17
- 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,...
- Blog posts 2007-09-17
- How do I... Use PHP with PostgreSQL?
- It's no secret that PHP and MySQL go well together. Both PHP and MySQL are open-source projects, are widely used in the developer community, and play well together because of PHP's built-in MySQL support. While MySQL has been getting the lion's share of attention, PostgreSQL also deserves a nod. PostgreSQL...
- Blog posts 2007-08-03
- Always check for whitespace
- Last month Justin talked about his quest for fundamental programming theory resources. One fundamental I keep running into is people who forget to check for whitespace. Or dont even know how to check for whitespace.I cant tell you the number of times Ive seen some poor engineer spend...
- Blog posts 2007-05-09
- Access Query not doing what I need
- I have a database that has several tables that are all linked with a relationship on a field that contains a unique numeric ID. I need to run a query that pulls data from two of the tables and all attempts so far are not giving me the output...
- Discussion threads 2007-03-07
- 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...
- Discussion threads 2007-01-30
- Access Autolookup doesn't actually fill in data
- I have 2 tables, Customers and Lates. I want to populate data ONTO Late FROM Customers. The match field is done correctly - it's the primary on the Customers table and a MANY on Lates. The QUERY works fine. Like the Access documentation shows, the info
- Discussion threads 2006-12-13
- Using common table expressions in SQL Server 2005 queries
- Common table expressions CTEs, a powerful and slick new feature in SQL Server 2005, make your SQL more readable and easier to maintain. Arthur Fuller demonstrates how you can use a CTE more than once in a SQL Server statement. New in SQL Server 2005 are common table expressions...
- Technical articles 2006-11-20
- 10 tips for sorting, grouping, and summarizing SQL data
- Do these tips help clarify some of your options when it comes to arranging SQL data? What other suggestions or techniques would you add to the list?YesI work with sql on a daily basis. but, a lot of it is overly simplified. This will be a good
- Discussion threads 2006-11-06
- Optimize database code to boost performance
- Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid. As .NET developers, we often find ourselves waist deep in SQL Server queries and stored procedures. A good example...
- Technical articles 2006-09-26
- << Previous
- page 1 of 4
- Next >>
Content Types
Refining Tags
- Software (54 results)
- Enterprise Software (37 results)
- Databases (36 results)
- Data Management (35 results)
- Microsoft Windows (31 results)
- Hardware (21 results)
- Storage (14 results)
- Microsoft Access (14 results)
- Operating Systems (13 results)
- Office Suites (11 results)
- Microsoft Office (11 results)
- database (11 results)
- Microsoft SQL Server (10 results)
- Server (10 results)
- SQL (9 results)
- EMS Database Management Solutions (9 results)
- Internet (7 results)
- Productivity (6 results)
- susan harkins (6 results)
- Microsoft Corp. (6 results)
- Networking (6 results)
- Mary Ann Richardson (5 results)
- Software Development (5 results)
- Software/Web Development (5 results)
- Marketing (5 results)
- Programming Languages (4 results)
- Search (4 results)
- Tim Chapman (4 results)
- programming (4 results)
- Data (4 results)
- MySQL (3 results)
- Performance Management (3 results)
- Channel Management (3 results)
- IBM DB2 (3 results)
- access (3 results)
- Record (3 results)
- Web (3 results)
- Workforce Management (3 results)
- Microsoft Office Suite Access Tips Newsletter (3 results)
- Human Resources (3 results)
- PostgreSQL (3 results)
- Melonfire (3 results)
