3 Resources for

dynamic sql

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

DOWNLOAD: 10 common SQL Server problems and solutions: This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From "Out of Space" errors to a database going suspect, this list is great quick reference for every SQL administrator.Download and review the list:http://techrepublic.com.com/5138-10879-5995232.htmlThen join this discussion and let us know if this download provides...; Tags: 10 things, Bill Detwiler - TechRepublic, database, dynamic SQL, executor, josh hoskins, Microsoft SQL Server, server, software, SQL, sql server; Discussion threads 2005-12-14
Improve dynamic SQL performance with binds: Don't be too quick to dismiss dynamic SQL used in PL/SQL programs. Scott Stephens provides code samples that demonstrate how using binds can help boost dynamic SQL performance. TechRepublic's Oracle newsletter covers automating Oracle utilities, generating database alerts, solving directed graph problems, and more. Automatically subscribe today! Developers...; Tags: PL/SQL, SQL, Listing B, DBMS_SQL, Databases, Scott Stephens, Programming languages, Example 5, dynamic SQL, Oracle Tips Newsletter, TechRepublic Inc., Performance, Listing C, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-04-12
Improve dynamic SQL performance with binds: Comments on Dynamic SQLThe article is helpful to gather knowledgeon Dynamic SQL.But it could have been even betterif some ideas were provided on where using Dynamic SQL could enhance the performance,instead of using normal SQL statements.Ties in with my new entry in PL/SQLThanks for a timely article. Editorally speaking, there...; Tags: arpan_d02@..., Dynamic SQL, Example 4, Example 5, software, SQL; Discussion threads 2005-04-13

Additional Resources

Understanding SQL Server's WITH RECOMPILE option: Dynamic St ProcWell i guess that's the problem with only Dynamic Stored Procedure... It looks ur suggestion fits best to dynamic SP... Otherwise If SP has to work with just static veiw of relational schema in Normal Stored procedure, it should not be recompiled everytime as it might degrade the...; Tags: naishaltopiwala@..., server, software, sproc; Discussion threads 2005-04-12
MSDN Webcast: What I Wish Developers Knew About Writing Applications for SQL Server 2005 (Level 200): This webcast addresses some of the most common errors in SQL server encounter, and explains how to avoid them in the applications. The speaker covers connecting to SQL Server, cursors, handling NULLs, stored procedures and dynamic SQL, error handling, and transactions.; Tags: Developer, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management; Webcasts

Behavior of SQL Server 2000 Network Library During Dynamic Port Detection: The SQL Server 2000 Books Online documentation describes many of the enhancements to the network libraries. SQL Server 2000 clients use DBNETLIB to perform to detect the ports. DBNETLIB is always loaded by the ODBC or SQLOLEDB components. DBNETLIB is responsible for making either direct IP/SPX calls or forwarding requests...; Tags: Network, Microsoft SQL Server, Microsoft SQL Server 2000, SQL Server 2000 Books Online Documentation, DBNETLIB, Databases, Enterprise Software, Software, Data Management; White papers 2005-12-13
Microsoft SQL Server 2008 Product Overview: SQL Server 2008 provides the technology and capabilities that organizations count on. With significant advancements in the key areas of mission-critical platform, dynamic development, beyond relational data, and pervasive insight, the benefits of SQL Server 2008 are substantial. This paper provides an overview of the new benefits and functionality available...; Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management; White papers 2007-06-01
'DYNAMIC DUO' of Technology: Unicenter SQL Station & AllFusion ERwin Data Modeler: This webcast will introduce you to the "DYNAMIC DUO", Unicenter SQL-Station and AllFusion ERwin Data Modeler, now offered for the first time as a single offering. Together, they complete the database application lifecycle by enabling creation and maintenance of enterprise data models and the development, testing, optimization and change management...; Tags: CA Unicenter, SQL, Computer Associates International Inc., CA AllFusion, Databases, Storage, Enterprise Software, Software, Data Management, Hardware; Webcasts
TechNet Webcast: SQL Server Code Name "Katmai" Data Management Overview (Level 100): The attendee of this webcast will gain an overview of Microsoft SQL Server code name "Katmai," the next generation of SQL Server. SQL Server "Katmai" provides an enterprise data platform for the mission-critical applications, while providing a dynamic development environment and comprehensive Business Intelligence BI platform. The presenter discusses the...; Tags: Webcast, Microsoft SQL Server, Server, Microsoft TechNet, Databases, Enterprise Software, Software, Data Management; Webcasts
SQL Server DMV Client (exe): Browse SQL Server DMVs Dynamic Management Views and quickly view user session performance information without having to run any SQL code. Locate long running sessions, blocked queries, queries with large I/O, CPU, or Memory activity. This version is the first release on CNET Download.com.; Tags: Performance, Microsoft SQL Server, SQL-Server-Pages, Performance Management, Databases, Enterprise Software, Human Resources, Workforce Management, Software, Data Management; Software downloads 2008-06-30
Protect databases from SQL injection attacks: In a SQL injection, attackers attempt to damage your database by a "injecting" a SQL statement into another statement. Learn simple methods for preventing injections from penetrating your system. SQL injection is a strategy for attacking databases. The attacker "injects" a SQL statement into another statement—often to...; Tags: SQL, Databases, Arthur Fuller, Programming languages, ASP Page, SQL injection, injection, database, SQL Server Newsletter, TechRepublic Inc., Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-07-21
Dynamic Promotion Suite (exe): Dynamic Promotion Suite is a complete Internet marketing solution for all your Web promotion needs. It contains our entire software Internet promotion product line in one package, provides you a total solution to Includes all of these products: Dynamic Submission 7.0; Dynamic KeywordBid Maximizer for Overture; Dynamic KeywordBid Maximizer Advance;...; Tags: Dynamic Promotion Suite, Internet, Marketing Research, Marketing; Software downloads 2004-12-28
MSDN Webcast: Top 10 Dynamic Management Views in SQL Server 2005 (Level 200): The presenter of this webcast provides an overview of Dynamic Management Views DMVs now available in Microsoft SQL Server 2005. In this webcast, presenter shares details on the 10 DMVs he considers most useful. This webcast demonstrates how each of these top 10 DMVs might be used in a production...; Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Digital Media, Consumer Electronics, Personal Technology; Webcasts
XML Manipulation Using CFML and MS SQL: Where can I find some good resources on how to manipulate XML documents using Cold Fusion and MS SQL. My ultimate goal is to use XML for legal document management and allow for dynamic changes when amendments take place.; Tags: CFML, LaJuan, MS-SQL, programming, XML; Discussion threads 2006-10-11
SQL DTS Task - Dynamic Properties Task: I intend to use DTS task called Dynamic Properties Task. Where can I get more info and examples on how people used in production for batch processing.What are the limitations or FAQ to look out for before implementing?; Tags: DTS, DTS Task, Dynamic Properties, Dynamic Properties Task, hardware, kaypaul@..., SQL, SQL DTS; Q&A 2005-07-28
Fend off the next SQL Injection attack with a properly secured database: As long as Web applications are used to provide access to data, SQL Injection will continue to be a threat. SQL Injection is typically used to accomplish one of four objectives: bypass authentication, glean information, inject new or alter existing data, perform a denial of service attack, or gain access...; Tags: SQL, SQL Injection, Programming Languages, Databases, Security, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Download resources 2005-06-27
Online Transaction Processing in SQL Server 2008: Microsoft SQL Server 2008 provides a database platform that is optimized for today's applications, and that can scale for any size of business. It drives cost-efficiencies by dramatically reducing downtime and enabling dynamic and proactive management that significantly reduces administrative overhead. Finally, SQL Server 2008 provides a highly secure platform...; Tags: Microsoft SQL Server 2008, Microsoft SQL Server, OLTP, Microsoft Corp., Databases, Enterprise Software, Software, Data Management; White papers 2008-01-01
Five useful dynamic management objects in SQL Server 2005: 11; Tags: career, e-mail, feedback, hardware, it management, linux, Microsoft SQL Server, Microsoft SQL Server 2005, networking, off-topic, programming, project management, security, sobella77@..., software; Discussion threads 2006-10-09
Management of SQL Server Virtualization: Virtualization is becoming the popular practice in many environments, allowing organizations of all sizes to utilize resources more efficiently. SQL Sentry Event Manager allows DBA's to more effectively manage these dynamic environments to ensure optimal performance. Virtualization can dramatically reduce the cost of hardware and other resources needed to expand...; Tags: Microsoft SQL Server, SQL, Server Virtualization, SQL Sentry, SQL Sentry Event Manager, Virtualization, Storage Management, Programming Languages, Utility Computing, Databases, Hardware, Storage, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; White papers 2008-02-21
Tips & Techniques for Optimizing BMC APPTUNE for DB2: DB2 applications vary widely in their technical implementation and importance to the business. Some applications are stable and offer few tuning challenges while others are more dynamic in nature and require greater SQL tuning focus. These variations require a more customized approach to collecting and analyzing SQL performance data that...; Tags: BMC Software Inc., Technique, Performance, SQL, IBM DB2, Performance Management, Programming Languages, Databases, Human Resources, Workforce Management, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Webcasts

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (2 results)

Technical articles (1 results)

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now

Configuring a Laptop for Mobile Use Power Checklist: Does your company have a mobile workforce? Does your company have even a single employee who carries a laptop to and from home? When it comes to ident ...; Buy Now