1 3 3

: Sql

  1. #1

    New Sql


    Microsoft SQL Server 7.0




    SQL Server

    SQL Server






    :






    SQL



    DBase
    Paradox






    :













    Oracle 8
    SQL Server 7
    IBM DB2
    SYbase
    Informix
    Borland IntraBase

    Microsoft SQL ServerOracle



    Microsoft SQL Server

    Oracle











    ( )





    SQL

    Unix

    ( )

    Unix



    SQL Server
    6.5

    Microsoft SQL Server7.0 Enterprise Manager
    .


    English Query Language


    10
    SQL Server Books On-Line

    support.microsoft.com
    msdn.microsoft.com/library
    msdn.microsoft.com/sqlserver

    SQL-Server
    .


    SQL-Server




    ( )







    :


    SQL Server 7
    2000
    8
    ( )

    ʡ
    SQL Server 7


    :

    Client Access License

    SQL Server
    2400 3000



    :









    :


    SQL Server 7

    Microsoft Visual Basic 6
    Microsoft Access 2000 Developer


    DLL


    Microsoft Access Runtime



    Oracle Developer 2000, or R:2 or R:6

    Oracle Developer Runtime







    SQL Server 7

    Microsoft Data Engine



    SQL Server

    Oracle



    Microsoft SQL Server 7.0

    Microsoft SQL Server 7



    Microsoft SQL Server 7



    Microsoft SQL Server 7




    SQL Server Enterprise Manager






    SQL Server Client Network Utility


    SQL Server

    Enterprise Manager


    SQL Server Network Utility



    SQL Server Performance Monitor


    Windows NT


    SQL Server Profiler


    Transact SQL



    SQL Server Query Analyzer


    Transact SQL


    SQL Server Service Manager



    SQL Server Books Online



    SQL Server OLAP


    Microsoft SQL Server 7.0

    ( )

    SQL Servers




    DOS





    English Query Language



    Microsoft SQL Server 7.0

    Microsoft SQL Server 7.0 Enterprise Manager


    Microsoft SQL Server 7

    Microsoft SQL Server 7.0




    MS SQL Server



    SQL Server Agent



    Autopilot


    Distributed Transaction Coordinator





    Services

    Services



    Master


    Tempdb


    Model






    .mdf


    .ldf













    6.5 7.0


    SQL Server 6.5
    SQL Server 7.0

    Configuration values
    Minimum
    Maximum
    Minimum
    Maximum

    affinity mask
    0
    2,147483,647
    0
    2,147,483,647

    allow updates
    0
    1
    0
    1

    backup buffer size
    1
    32
    N/A
    N/A

    backup threads
    0
    32
    N/A
    N/A

    cost threshold for parallelism
    N/A
    N/A
    0
    32,767

    cursor threshold
    -1
    2,147483,647
    -1
    2,147,483,647

    database size
    2
    10,000
    N/A
    N/A

    default language
    0
    9,999
    0
    9,999

    default sort order id
    0
    255
    0
    255

    extended memory size (MB)
    N/A
    N/A
    0
    2,147,483,647

    fill factor (%)
    0
    100
    0
    100

    free buffers
    20
    524,288
    N/A
    N/A

    hash buckets
    4,999
    265,003
    N/A
    N/A

    index create memory (K)
    N/A
    N/A
    704
    1,600,000

    language in cache
    3
    100
    3
    100

    language neutral full-xxxx indexing
    N/A
    N/A
    0
    1

    LE threshold maximum
    2
    500000
    N/A
    N/A

    LE threshold minimum
    2
    500000
    N/A
    N/A

    LE threshold percent
    1
    100
    N/A
    N/A

    lightweight pooling
    N/A
    N/A
    0
    1

    locks
    5000
    2,147,483,647
    5000*
    2,147,483,647*

    LogLRU buffers
    0
    2,147,483,647
    N/A
    N/A

    logwrite sleep (ms)
    -1
    500
    N/A
    N/A

    max async IO
    1
    1,024
    1
    255

    max degree of parallelism
    N/A
    N/A
    0
    32

    max lazywrite IO
    1
    1,024
    N/A
    N/A

    max server memory (MB)
    N/A
    N/A
    4 *
    2,147,483,647*

    max xxxx repl size
    0
    2,147,483,647
    0
    2,147,483,647

    max worker threads
    10
    1,024
    10
    1,024

    media retention
    0
    365
    0
    365

    memory
    2800
    1,048,576
    N/A
    N/A

    min memory per query (K)
    N/A
    N/A
    512
    2,147,483,647

    min server memory (MB)
    N/A
    N/A
    0*
    2,147,483,647*

    nested triggers (bytes)
    0
    1
    0
    1

    network packet size
    512
    32,767
    4,096
    65,535

    open databases
    5
    32,767
    N/A
    N/A

    open objects
    100
    2,147,483,647
    0*
    2,147,483,647*

    priority boost
    0
    1
    0
    1

    procedure cache
    1
    99
    N/A
    N/A

    Protection cache size
    1
    8,192
    N/A
    N/A

    query governor cost limit
    N/A
    N/A
    0
    2,147,483,647

    query wait (s)
    N/A
    N/A
    -1
    2,147,483,647

    RA cache hit limit
    1
    255
    N/A
    N/A

    RA cache miss limit
    1
    255
    N/A
    N/A

    RA delay
    0
    500
    N/A
    N/A

    RA pre-fetches
    1
    1,000
    N/A
    N/A

    RA slots-per-thread
    1
    255
    N/A
    N/A

    RA worker threads
    0
    255
    N/A
    N/A

    recovery flags
    0
    1
    N/A
    N/A

    recovery interval (min)
    1
    32,767
    0
    32,767

    remote access
    0
    1
    0
    1

    remote conn timeout
    -1
    32,767
    N/A
    N/A

    remote login timeout
    0
    2,147,483,647
    0
    2,147,483,647

    remote proc trans
    0
    1
    0
    1

    remote query timeout
    0
    2,147,483,647
    0
    2,147,483,647

    remote sites
    0
    256
    N/A
    N/A

    resource timeout
    5
    2,147,483,647
    5
    2,147,483,647

    scan for startup procs
    N/A
    N/A
    0
    1

    set working set size
    0
    1
    0
    1

    show advanced options
    0
    1
    0
    1

    SMP concurrency
    -1
    64
    N/A
    N/A

    sort pages
    64
    511
    N/A
    N/A

    spin counter
    1
    2,147,483,647
    1
    2,147,483,647

    tempdb in RAM (MB)
    0
    2,044
    N/A
    N/A

    time slice
    50
    1,000
    50
    1,000

    Unicode comparison style
    N/A
    N/A
    0
    2,147,483,647

    Unicode locale id
    N/A
    N/A
    0
    2,147,483,647

    user connections
    5
    32,767
    0*
    32,767 (server)*

    user options
    0
    4,095
    0
    4,095

    * Lower or upper limit for objects allocated dynamically.





    Maximum Capacity Specifications
    This table specifies the maximum sizes and numbers of various objects defined in Microsoft SQL Server databases, or referenced in Transact-SQL statements.


    Maximum sizes/numbers

    Object
    SQL Server 6.5
    SQL Server 7.0

    Batch size
    128 KB
    65,536* Network Packet Size

    Bytes per short string column
    255
    8000

    Bytes per xxxx, nxxxx, or image column
    2 GB-2
    2 GB-2

    Bytes per GROUP BY, ORDER BY
    900
    8060

    Bytes per index
    900
    900

    Bytes per foreign key
    900
    900

    Bytes per primary key
    900
    900

    Bytes per row
    1962
    8060

    Bytes in source xxxx of a stored procedure
    65025
    Lesser of batch size or 250 MB

    Clustered indexes per table
    1
    1

    Columns in GROUP BY, ORDER BY
    16
    Limited only by number of bytes

    Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement
    10
    10

    Columns per index
    16
    16

    Columns per foreign key
    16
    16

    Columns per primary key
    16
    16

    Columns per base table
    250
    1024

    Columns per SELECT statement
    4096
    4096

    Columns per INSERT statement
    250
    1024

    Connections per client
    Max. value of configured connections
    Max. value of configured connections

    Database size
    1 TB
    1,048,516 TB

    Databases per server
    32,767
    32,767

    Filegroups per database
    N/A
    256

    Files per database
    32
    32,767

    File size (data)
    32 GB
    32 TB

    File size (log)
    32 GB
    4 TB

    Foreign key table references per table
    16
    253

    Identifier length (in characters)
    30
    128

    Locks per connection
    Max. locks per server
    Max. locks per server

    Locks per server
    2,147,483,647
    2,147,483,647 (static)
    40% of SQL Server memory (dynamic)

    Nested stored procedure levels
    16
    32

    Nested subqueries
    16
    32

    Nested trigger levels
    16
    32

    Nonclustered indexes per table
    249
    249

    Objects concurrently open in a server*
    2 billion
    2,147,483,647

    Objects in a database*
    2 billion
    2,147,483,647

    Parameters per stored procedure
    255
    1024

    REFERENCES per table
    31
    63

    Rows per table
    Limited by available storage
    Limited by available storage

    SQL string length (batch size)
    128 KB
    128* TDS packet size

    Tables per database
    2 billion
    Limited by number of objects in a database

    Tables per SELECT statement
    16
    256

    Triggers per table
    3
    Limited by number of objects in a database

    UNIQUE indexes or constraints per table
    249
    249 nonclustered and 1 clustered

    * Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647.


    Microsoft SQL Server 7

    Microsoft SQL server 7.0



    Microsoft SQL Server 7.0


    Windows NT 4




    SQL Server

    Database Server Standard Edition

    Microsoft Windows NT Server 4.0

    Microsoft Windows 2000 Server or Advance Server

    ( )

    Database Server Desktop Edition


    Full xxxx search

    Replication


    SQL Server 7.0 OLAP Services


    English Query

    SQL




    Database Server Desktop Edition



    Local or Remote Installation





    Typical


    Minimum

    SQL Server

    :

    Custom







    Multilingual (850)

    Unicode










    Microsoft SQL Server 7.0

    Service Pack 2



    Help -> About

    Service Pack



    Microsoft SQL Server 7.0 Enterprise Manager



    SQL Server 7.0

    Start -> Programs -> Microsoft SQL server 7 -> Enterprise Manager



    SQL Server 7



    Microsoft Management Console (MMC)

    Sql Server 7.0

    Transaction Server



    SQL Server


    SQL Server 7.0







    SQL Server

    Action




    Tools



    Microsoft SQL Servers





    Databases
    |_ master
    |_ model
    |_ tempdb
    |_

    Data Transformation Services
    |_ Local Packages
    |_ Repository Packages
    |_ xxxxdata

    Management
    |_ SQL Server Agent
    |_ Backup
    |_ Current Activity
    |_ Database Maintenance Planes
    |_ SQL Server Logs
    |_ Web Publishing

    Security
    |_ Logins
    |_ Server Roles
    |_ Linked Servers
    |_ Remote Servers

    Support Services
    |_ Distributed Transaction Coordinator
    |_ SQL Mail







    Databases



    Databases
    |_ master



    Databases
    |_ model



    Databases
    |_ tempdb


    SQL Server





    Data Transformation Services
    |_ Local Packages
    |_ Repository Packages
    |_ xxxxdata




    :

    Management



    Management
    |_ SQL Server Agent



    Management
    |_ Backup



    Management
    |_ Current Activity



    Management
    |_ Database Maintenance Planes



    Management
    |_ SQL Server Logs


    SQL Server


    Management
    |_ Web Publishing




    :

    Security



    Security
    |_ Logins



    Security
    |_ Server Roles



    Security
    |_ Linked Servers


    SQL Server


    Security
    |_ Remote Servers



    :

    Support Services



    Support Services
    |_ Distributed Transaction Coordinator



    Support Services
    |_ SQL Mail


    SQL Server



  2. #2

    Sep 2007
    3,014
    Blog Entries
    2
    30

    the_imperial911...


  3. #3

    Sep 2007
    City safeer
    2,123
    0

    : Sql