Show All Related Tags
Related Tags:
financial statement (14 results), mission statement (14 results), vision statement (6 results), income statement (5 results), privacy statement (3 results)more...
Show Fewer Related Tags
Related Tags:
financial statement (14 results), mission statement (14 results), vision statement (6 results), income statement (5 results), privacy statement (3 results), prepared statement (1 results), Cash Flow Statement (1 results)fewer...
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Generate dynamic SQL statements in SQL Server
- When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Dynamic SQL statements A...
- Blog posts 2008-03-10
- Train users to follow best practices when writing VBA code
- If you train users to do a little coding on their own, they may not hit you up with as many development requests. I think that teaching users Visual Basic for Applications VBA is a good place to start because it's easy to learn. VBA lets you automate tasks and...
- Blog posts 2008-02-01
- Find blocking processes using recursion in SQL Server 2005
- Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set or subset of records. This causes the second process to wait until the first process is done so it can acquire the records; this...
- Blog posts 2008-01-28
- Monitor query performance with the SQL Server 2005 procedure cache
- In SQL Server 2005, you only need to recompile the statements inside stored procedures. This is much different than SQL Server 2000, where the entire procedure or batch may be recompiled. The benefit to the statement level recompile in SQL Server 2005 is that typically just a few statements inside...
- Blog posts 2008-01-17
- Write your own sp_lock system stored procedure in SQL Server 2005
- The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. One of my previous articles describes how you can use sp_lock...
- Blog posts 2008-01-07
- Rebuild indexes online with SQL Server 2005
- Indexes are specialized data structures that operate on tables and sometimes views in the database engine used to aid in the searching for and sorting of data. Indexes are vital to the database engine returning results quickly. As data is modified in the underlying tables that the indexes operate on,...
- Blog posts 2007-12-10
- Execute SQL statements in Integration Services
- Executing SQL statements is one of the easiest and most common tasks that occur in SQL Server 2005 Integration Services SSIS. This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary. Add and bundle...
- Blog posts 2007-10-15
- BitTorrent users take another hit
- Some of the Internet's largest torrent trackers have been taken offline or severely cut back this month. For those of you who don't know what a torrent tracker is, it's a server which helps BitTorrent users to locate peers for a download via the BitTorrent protocol. ...
- Blog posts 2007-09-26
- Using SQL Server 2008's MERGE statement
- SQL Server 2008's new MERGEÂ statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions...
- 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
- SCO files for Chapter 11 bankruptcy
- With cash reserves running out, the SCO Group, Inc has filed for bankruptcy protection. In a move that probably did not surprise many, the company made the announcement in a news release issued on Friday afternoon, just before the stock exchange closed for the week. The statement...
- Blog posts 2007-09-15
- Speed up SQL Server database queries with these tips
- If you've worked with SQL Server databases for any amount of time, it's practically a given that you've run into slow running queries. Sometimes the reason for the slow response time is due to the load on the system, and other times it is because the query is not written...
- Blog posts 2007-09-11
- Using NOLOCK and READPAST table hints in SQL Server
- Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server. When data in a database is read or modified, the database engine uses special types of controls, called locks, to...
- Technical articles 2007-05-21
- Three ways to avoid Case Not Found errors in PL/SQL
- Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. Bob Watkins presents three ways to code around this error. PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE...
- Technical articles 2007-05-01
- Delete rows during updates using Oracle 10g's MERGE statement
- In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works. The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both...
- Technical articles 2007-02-20
- Modifying execution context in SQL Server 2005
- Tim Chapman outlines how you can use the EXECUTE AS clause to change execution context in SQL Server 2005. He then shows how you can use this clause to impersonate the owner of a table in a schema. Execution context is the identity for which SQL Server permits actions...
- Technical articles 2007-02-12
- Use Service Broker Internal Activation in SQL Server 2005
- DBA Tim Chapman walks you through the process of building a small Service Broker application that uses Internal Activation to process messages when they are passed. In previous articles, I covered the theory behind message-based systems and introduced the components of Service Broker, the new feature in...
- Technical articles 2007-02-05
- Write PIVOT queries in SQL Server 2005
- SQL Server 2005's PIVOT operator allows you to rotate row level data into tabular data without the use of the CASE statement. Tim Chapman describes why this new operator has a place in the TSQL developers' toolbelt. New to SQL Server 2005 is the PIVOT operator, which gives...
- Technical articles 2006-12-18
- Process non-consecutive array items in FORALL
- Prior to Oracle 10g, the FORALL statement only accepted a consecutive range of index values for processing. Starting with Oracle 10g, the INDICES OF and VALUES OF clauses can be added to support non-consecutive processing of elements in a collection. Executing Data Manipulation Language DML statements within a...
- Technical articles 2006-10-31
- Generate external table definitions from SQL*Loader
- External tables in Oracle enable you to query text files with the full power of the SQL language. Here is a quick way to create them using scripts generated by SQL*Loader. External tables, introduced in Oracle 9i, enable you to map a sequential text file to an Oracle...
- Technical articles 2006-10-03
- << Previous
- page 1 of 3
- Next >>
Content Types
Refining Tags
- Software (24 results)
- Databases (20 results)
- Enterprise Software (20 results)
- Data Management (20 results)
- Microsoft SQL Server (13 results)
- Tim Chapman (13 results)
- Software/Web Development (12 results)
- Hardware (10 results)
- Programming Languages (10 results)
- Software Development (10 results)
- Mobile (9 results)
- Tim (8 results)
- Microsoft Windows (7 results)
- Storage (7 results)
- Microsoft SQL Server 2005 (7 results)
- Procedure (6 results)
- Oracle Corp. (6 results)
- Operating Systems (5 results)
- SQL Server Newsletter (5 results)
- Bob Watkins (4 results)
- Data (4 results)
- Internet (4 results)
- Oracle Tips Newsletter (4 results)
- Transaction (4 results)
- Database (4 results)
- Desktops (3 results)
- SAS Institute (3 results)
- Listing B (3 results)
- clause (3 results)
- SQL (3 results)
- server (3 results)
- Productivity (3 results)
- Personal Technology (3 results)
- Table (3 results)
- Apple Macintosh (3 results)
- Workforce Management (3 results)
