Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- SR UDF Library (zip)
- SR UDF Library version (2.0.2.0) a user defined function library (161 UDFs) for InterBase and Firebird on the Windows platform. This version of SR UDF Library supports the following standard routins Math, File, DateTime, String, Regional, Hash in addition to Conversion routins for converting different measurement units.
- Tags: User-defined Function
- Software downloads 2006-10-11
- Build molecular queries from atoms in SQL Server
- Flexible but at a priceCombining several subqueries (hidden in objects such as views, UDF,...) may introduce overhead forcing SQL server to retrieve temporary results, store them in tempdb and only then return final results. Using such a technique on a big databases one should be careful enough to...
- Tags: Aliux, Microsoft SQL Server, server, software, sql, subquery
- Discussion threads 2006-09-19
- Moving the Tempdb and Master Database in SQL Server
- Applies to MS SQL 2005?Good article, thank you. Do the techniques within apply only to MS SQL 2000, or do they apply to SQL 2005 as well? My guess would be just SQL 2000.
- Tags: Programming languages, Databases, server, duke.url@..., MS-SQL, Microsoft SQL Server
- Discussion threads 2007-08-01
- Invoke UDFs that accept tables with SQL Server 2005's APPLY operator
- A new feature in SQL Server 2005 is the APPLY operator, which allows the database developer to invoke a user-defined function that takes table value parameters. In this article, Tim Chapman shows you how to use this incredibly useful new operator.A user-defined function UDF is a database objectintroduced in SQL...
- Tags: Databases, Enterprise software, Microsoft SQL Server 2005, Tim Chapman, UDF, Microsoft SQL Server, APPLY operator
- Technical articles 2006-08-24
- Incorporate SQL Server UDFs in your .NET applications
- Database interaction is a standard feature of most .NETapplications, with SQL Server as the popular choice for the data tier.Consequently, .NET developers often find themselves developing T-SQL codewithin their applications or stored procedures on the database server.Developers often overlook a number of the features in theT-SQL language. For instance, when...
- Tags: Database interaction, Microsoft .NET, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, Tony Patton, User Defined Function
- Technical articles 2005-10-18
- Logical Standby Unleashed
- This paper provides an in-depth review of Data Guard SQL Apply Logical standby database utilizing significant new features in Oracle Database 10g. This paper presents a strategy where SQL Apply is a significant element of a Business Continuity strategy. This session will share best practices and user experience deploying SQL...
- Tags: Oracle Corp., SQL, Databases, Programming Languages, Service Level Management, Strategy, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, It Operations, It service Management, Management
- White papers 2005-09-01
- SQL Apply Best Practices: Oracle Data Guard 10g Release 2
- With Oracle Data Guard SQL Apply in Oracle Database 10g, Oracle is addressing the requirements of the business community for an online disaster-recovery solution that also provides a means to offload reporting and decision support operations from the primary database. A logical standby database contains the same logical information as...
- Tags: Oracle Corp., SQL, Best Practice, Standby Database, Databases, Programming Languages, Data Mining, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware
- White papers 2006-06-01
- Building and using table UDFs in SQL Server
- Table UDFs (user-defined functions) are one of Arthur Fuller's favorite features of SQL Server 2000 and 2005. Find out why he says that, if you've never used them, you may be in for a surprise. Table UDFs (user-defined functions) are one of my favorite features of SQL Server...
- Tags: Microsoft SQL Server, UDF, Databases, Arthur Fuller, server, SQL Server Newsletter, TechRepublic Inc., Fun, Table, Enterprise Software, Software, Data Management
- Technical articles 2006-08-07
- UDF Packet Writing over USB with InCD from Nero?
- I want to buy an external USB DVDRW burnerLG GSA-E10L for my notebook IBM ThinkPad 600X,Pentium III / 500 MHz, 256 MB RAM, USB 1.1.I have Windows 98, Release 1.1. Is it possible to use a UDF formatted CDRW ("Packet writing")with this burner with programm InCD?(InCD is part of Nero...
- Tags: UDF, burner, niagara1234@..., InCD, USB, packet writing, windows, software, hardware, burning, Nero
- Discussion threads 2007-02-02
- StarBurn SDK (exe)
- StarBurn SDK is advanced CD/DVD burning, grabbing, and mastering toolkit. Features are: All MMC compatible CD/DVD recorders (CD-R/W, DVD-R/W, DVD+R/W and DVD-RAM) are supported. UDF file system mastering (UDF 1.02, 1.50 and 2.01). ISO9660 file system mastering including Joliet Unicde name extensions. Session import (appending already created CD/DVD). Bridge file...
- Tags: CD, File System, StarBurn SDK, DVD, Consumer Electronics, Personal Technology, Home Entertainment
- Software downloads 2005-07-20
- Microsoft T-SQL Performance Tuning Part 2: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server Using Indexing Strategies
- This paper describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer to achieve the same or similar results to those...
- Tags: Microsoft SQL Server Transact-SQL, Performance, Microsoft SQL Server, Server, Microsoft Corp., Quest Software Inc., Performance Management, Databases, Human Resources, Workforce Management, Enterprise Software, Software, Data Management
- White papers 2005-01-01
- SQL Apply Rolling Upgrade Best Practices: Oracle Database 10g Release 2
- Oracle Maximum Availability Architecture MAA is the Oracle best practices blueprint for implementing Oracle high-availability technologies. The goal of this paper is to provide best practices for using SQL Apply Rolling Upgrades to execute database upgrades with minimal downtime. Starting with Oracle Database 10g Release 1 (10.1.0.3 and onward), Data...
- Tags: Oracle Corp., SQL, Best Practice, Oracle Database, Oracle Database 10g, Oracle Maximum Availability Architecture, Databases, Enterprise Software, Software, Data Management
- White papers 2007-02-01
- Incorporate SQL Server UDFs in your .NET applications
- The article shows a misuse of UDFsIt’s nice to see UDFs get some attention. But the author exhibits a common misuse of UDFs. Take a look at this procedure:CREATE PROCEDURE dbo.ReturnAllEmployees AS BEGIN SELECT dbo.GetEmployeeName(e.EmployeeID) As FullName, Address, City, PostalCode FROM Employees e END The SELECT statement...
- Tags: anovick@..., create function, Incorporate SQL Server UDF, Microsoft .NET, Microsoft SQL Server, programming, sql server udf, udf, UDF dbo.GetEmployeeName, user-defined function
- Discussion threads 2005-10-20
- Understand when to use user-defined functions in SQL Server
- In the simplest terms, a user-defined function UDF in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued. (I will not be covering...
- Tags: Function, Parameter, Microsoft SQL Server, Server, Value, Table, UDF, SalesHistory, SaleDate, SalePrice, Tim Chapman
- Blog posts 2007-09-04
- Build temporary tables to optimize SQL queries
- Learn how to build a table from a list of values and join the table to the target table. You'll also discover how to build the temporary table to hold the values. Applications often present a way to allow a user to select a number of values. These...
- Tags: Databases, Arthur Fuller, SQL Server Newsletter, TechRepublic Inc., SQL, Table, SET, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-26
- Incorporate SQL Server UDFs in your .NET applications
- User Defined Functions UDFs are a powerful feature that every developer who works with SQL Server needs to know. Learn how to incorporate UDFs in your next .NET project. Database interaction is a standard feature of most .NET applications, with SQL Server as the popular choice for the...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft .NET, Microsoft SQL Server, Databases, Tony Patton, .NET, Middleware, Database interaction, User Defined Function, .NET Newsletter, Function, Method, Procedure, User-defined Function, Listing B, Scalar, Listing D, Enterprise Software, Software, Data Management
- Technical articles 2005-10-18
- sql function
- how to use exec statement in udf function to excute a variable which given as select statementDo you meanDeclare @MyQuery VarChar(500)Select @MyQuery = "Select * From MyTable"Execute (@MyQuery)You have to put the parentheses in.
- Tags: software, SQL, thiyagarajan.srinivasan@...
- Discussion threads 2007-01-02
- Street Proven Techniques for Deploying Data Guard SQL Apply
- In Oracle9i Database, Data Guard introduced a new type of standby technology called SQL Apply, which maintains a Logical standby database a transactional copy of the primary database in addition to Data Guard's existing Physical standby capability. Since its introduction, Logical Standby databases have been deployed in production at many...
- Tags: Technique, Oracle Corp., SQL, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- White papers 2004-11-01
- DBF to SQL (zip)
- The DBF to SQL program allows you to convert your DBF files to SQL script. You can apply this script on any SQL server, so you can easily transfer your data to a new system. There are several different SQL servers, but this program allows you to customize the output...
- Tags: Program, Microsoft SQL Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2005-11-01
- << Previous
- page 1 of 1
- Next >>
