INF: ?????? Microsoft SQL Server ??????

?????? ????????? ?????? ?????????
???? ???????: 110352 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ???? Microsoft SQL Server ?????? ???? ????, ??? ????? ??????? ???? ????? ?????? ????? ???? ???? ??? ???? ?????? ?? ??????? ??????? ??????? ??? ??? ???????. ????? ?? expend ?????? ????? ?????? ??? ???????? ???? ?? ?? ?????? ??????? sizable.

??? ??? ?????? ????????? ??????? ?? ?????? ?????? ?????? stemming ?? ??????? ?????? ??????????. ??? ?? ????? ???? ?????? ???? ??????? "????? ????? ????? ? ????? ?" ??? ???? ?????? ??? ?? SQL Server ??????? 4.2 x "?????? ????? ????????? C?" E ?????? ????? ?? ?????? ????? ??????? ??????. ??? ????? ?? ????? ??????? 6.0 ???? ???? ?????? ??? ????? ??????? MSDN (Microsoft ?????? ????) ??? ??? ???????.

????? ?? ?????? ?????? ???? ??? ??????? ???? ????? ?? ??????? ???? ?? ??????? ????? ?? ?????? ?????? ???? ??? ???? Microsoft SQL ?? ???? ???? ?????? ?? ?????? ???????.

????? ??????? gained ????? ???? ?? ?????? SQL Server ?? ??????? ?????? ?? ????? ????? ?????? ?????? ????? ?????? ????? ????????? ?????? ???????. ?????? ?? ???? ????? ?????? ???? ?????? ?? deficiencies ?? ??? ??????? ?????. ??? ??? ????? ?? ?????? ???? ??? ?? ??????? ??? ??? ??????? ????? ??? ??????? ????? ???? ?????? ?????? ?? ??????? ??? ????? ??????.

????? ?????? ?????? ????? ?????? ?????? ??? ??????? ??????? ??????? ????? ??????? ?????? ???????? ????? ????? ??? ???????? ???????? ?? ???????, ????? ????? ?????? ?????? ????? ?????? ?? ??? ???????. SQL Server ????? ????? ??????? ?????? ????????, ??? ???? ??? ?????? ????? ?????? (? ????? ???????) ?? ????? ????? ?? ????? ??????.

???? Microsoft SQL Server 6.0 ????? ??????? ???? ?????? ??????? ??????? ?????? ?? ????? ????? ?? ??????? ? ????? ???????? ????? ??? ???????? ?????? ??????? ?????? ? ????? ?????. ??? ????? ?? ???? ??? ?????? ??? ??? ????????? ?? ???? ???? ?? ??????. ???? ?? ???? ????????? ???? bogged ?? ????????? ???? ?? ????? ???? ???? ???. ????? ??? ?? ????? ???? ?????? ???? SQL Server 6.0 ????? ?????? ?????? ?????? ????? ?????? ?????? ????????? ?? ????? ???????.

?? ???? ?? ????? ?????? ???? ????? ?? ????? ?? ???? ??????. ?????? ?? ???? ????? "puppet" ?????? ????? ????? ??? ????? ??????????? ?? ???????? ?????? ??? ????? ?? ?? ?? ???????. ??? ????? ?? ?? ??? ????? ?????? ??? ?????? ? ????? ??? ??????? ?? ????? ?????? ????? ??? ????? ????? ??? ?????? ?????? ?? ??????? ?????? ???? ??????? ??????.

??????? ????

???? ??? ??? ?????????? ???? ????? ??? ????? ? ???? ???? yielded ??????? ?????? ??????:

??????? ????? ????? ???????? ???????

???? ??????? ?????? ????? ????? ???????? ??????? ???? ????. ??? ???? ?? ??????? ??? ??? ????? ????? ???????? ???????. ??? ??? ?? ??????? ???? ??? ????? ????? ???????? ??????. ????? ?????? ??????? ???? ????? ???? ?????? ?? ????? ????????? ?????? ? ???? ???? hurt ??????. ??? ???? ??? ?????? SQL Server ?????? ?? ????? ?????? ????, ????? ????? ????? ????? ????? ???????.

????? ????? ???????:
  • ?? ??????? ????? ???? ?????? ??? ??????? ???? ????.
  • ???? ???? ????? ??????? ???????? ? ???? ???? ???? ?? ???????.
  • ????? ???? ??? ?? ???? ???? ? ???? ???.
  • ??????? ??? ??? ???? ???????? ?????? UPDATE.
  • ??? ?? ????? ??????? ?? ???????? ??????? ??? ????? ????? ???????? compactness.
  • ????? ????? ??????? ??????? DBCC ???? ????? ?????? ???????? ????? ?????? ???.
?? SQL Server ????? ??????? ?????? ?????? ????? ?? ???? hurts. ??? ???? ??????? ???? ?? ????? ? ????? ?????? ???????? ???????? ????????. ??? ????? ??????? ???????? ? ????? Microsoft ???? ???? ??? ????? ??????? ?? ?? ???? ?????? ?? ????????? ???? ?????? ????? ????? ?? ????.

??? ??? ????? ????? ?????? ?????? ?????? ????? ? ?????? ?????? ????? ??? feasible ?? ?????? ???? ??????? ??????? ???? ???? ??? ????? ??????? ?????? ?? ??? ??????. ??? ?? ????? ?????? ??? ????? ???????? ?? ???? ????????? ??????? ? ?? ?????? ??? ??????? ?????? ???? ??? ??????? ??? ???????. ??? ?? ??? ?? ?????? ????? ??????? ?? ???? ????? ????? ??? ???? ???? ??? ???? ????.

?????? ????? ?????? ?????

???? ?????? ?? ????? ??? ????????? ?? ????? ????? ????????? ??? ?? ????? ????? ?????? ??????. ????? ???? ?? ???? ????? ????? ? ????? ??? ??????? ??? ????? ?????? ?? ????? ????? ???????? ?? ?? ????? ???? ??? ??????. ??? ????? ?????? ????? paramount ?? ????? ?????? SQL Server ????. ????? ?????? ?? ??? ?? ??? ?????? ??? ???????? ???? ??? ?? ?? ??? ??????? ????? ??????.

?????? ?????? ?????? ???? ????? ?? ???? ???????. ??? ?? ???? ?????????? ????? ?????? ????? ????? ????? ???? ??????? ?????? ???? ??? ????? ???? ??????. ??? ????? ??? ????? ??? ???? ????? ????? ??? ?????? ????? ?? ???????.

???? ??? ?????? ????? ??????:
  • ??? ???? WHERE ?? ????????? "SQL" ? ??? ??? ?? ??????? ??????? ??????.

    ???? ?? ???? ???????? ?? ???? WHERE ???? ???? ?????. ??? ??? ???? ??? ???? ???? ?? ??????????? ???? ???? ?????? ??????? ?? ??? ?????. ??? ?????? ???? ????? ??????? ??????? SQL ???????? ? ??? ???? ?????. ?????? ?? ??? ??????? ???? ????? ???? ???? SQL ???? ?? ??????? ??? ??? ?? ?????? ?????? ???????. ?? ???? ?? ????? ?? ?? ???? ?????? ?? ???? ???? ??? ??? ????.
  • ??????? ????? ??????.

    ????? ??? ?????? ???? ?????? ?? ????? ?????? ??????? ? ???????. ???? ????? ??? ???? ???? ??? ???? ? ??????? ?????? ??? boosting ??????.

    ?????? ???? ????? ??????? ????? ?????? ?? ??? ?????? ?? ???????? ????? ????????. ???? ???? ??? ???? ?? ??????? ??? ?????? ?? ???????? ?? ???????? ?? ?????? ??? ????? ?????? ?????. ?????? ????? ????, ????? ??????? ??? ???? ?????? ?? ??? ???????? ???????? ?? ?????? ???? ?? hurt ??????.

    ?? ?????? ?????? ?? ????? ?????????? ?? ??????? ??????? ?????? ???? ????. ??? ?????? ??? ??? ??? ??? ????? ???? ??????? ?? ????? SELECT ??? ???? ??? ?????? ? ?????? ???? ?????? ??? ??? ?????? ????? ????? ????. ??? ????? ?? ???? ??? ?????? ????? ?? ????? ???? excessively ?????? ?????? ??? ???????? ?????? ???????? ??? ????????????. ?????? ??? ???? ??????? ???? ?????? ?? ??????? ??? ???? ???? ???? ???? ?????? ??? ???? ???? ?? ???????????.

    ??? ?? ?? ???? ???? ?????? ?? ??????? ?? ???????? ?????? ???? ??????? ????? ????? ????? ????? ???????? ?? ????? ??? ???????. ??? ???? ????? ?????? ????? ??? ??????? ???? ??? ???? ?? ??????? ?? ???????. ????? ?????? ?? ??? ?? ??? ?????? ????? ?? ??? ???? ???? ???? ??? ??? ????? ??? ?????; ???? ????? ??????? ??????.
  • ??????? ????? ??????? ????????.

    ???? ??????? ???????? ????? ??????? ???????? tremendously ????? ??????. ??? ?????? ??????? ?????? ??? UPDATE ? DELETE ?????? ????? ??????? ???????? ??? ??? ???????? ????? ????? ???????. ??? ?????? ???? ?????? ???????? ???? ??? ????, ???? ?????? ??? ?????? ?????. ????????? ???? ?????? ???? ?????? ?? ??????????? ???? ????? ???? ?? ?????? ?? ???????? ???? ?????? ?????? ???? ?????? ????????.

    ?????:
          SELECT * FROM PHONEBOOK
          WHERE LASTNAME='SMITH'
    
          -or-
    
          SELECT * FROM MEMBERTABLE
          WHERE  MEMBER_NO > 5000
           AND MEMBER_NO < 6000
    
    						
    ???? ??????? ??? LASTNAME ?? MEMBER_NO ??????? ???????? ????? ??? ??????? ?? ???? ???????? ???? ?????? ??? ?????? ??? ??? ??? ????? ?? ????????? ???????. ???? ??????? ????? ??? ??????? ???????? ??? ????? ??? ??? ????? ??? ??????.
  • ??? ?????? ??????.

    ?????? ??? ??? ????? ?? ?? ?????? ?? ????? ???? ?????? ???????? ?? ?????? ??? ?????? ?? ?? ???? ????.

    ?????? ??????? ???? ???? ?????? ??????:
          SELECT COUNT (DISTINCT COLNAME)
          FROM TABLENAME
    
    						
    ??? ?? ???? ??? ????? ??????? ?? ??????. ?????? ??? ??? ?????? ??? ?????? ?? ??????. ??? ???? 10,000 ?? ????? ??????? 5000 ??? ?????? ???? ??? ????? ??? ??????? ????????. ?? ??? ??????? ??? ??? ????? 20 ???? ???????? ???? ?????? ????????. ??? ?? ?? ??? ????? ????? ??? ????? ???????. ??? ????? ??? ??? ?????? ?????? ??????. ???? ?? ??? ??????? ??? ??????? ??????? ?? ?????? WHERE ???????????.
  • ??? ????? ???????? ?? ??????? ????????.

    ?????? ?? ???? ??????? ??????? ????? ????? ???? ????? ???? ?? ??? ????? ??????? ?? ????? JOIN ??? ???? ???. ??? ????? ?????? ????? ????????? ???? ????????? ? ?? ???? ?? ????? ??? ????? ??? ??????. ???? ??? ???? ??????? ???? ?????? ????? ??? ??????? ??? ??? ??????? ??? ?? ????? ????? ?? ??? ?? ??? ??? ??? ????? ???? ??????? ?? ??????? ??? "Smith" ?? "Jones". ???????? ??? ??????? ????? ???? ???? ??? ????? ?????? ??? ???? ???? ???? ??????? ??????? GROUP ??????? ????? ???????? ??? ????? ???????. ??? ???? ???? ??? ???? ???????? ? ????? ???? ????? ??? ???? ???????? ????????.

    ?????? ??????? ???? ???? ????? ???????? ???????? ??? ??????? ?? ?????? ????? ?????? ??? COL1 COL2:
          SELECT COL1, COL2, COUNT(*)
          FROM TABLENAME
          GROUP BY COL1, COL2
    
    						
    ????? ?? ???? ??? ???? ??????? ?? ??? ?????? ?? ????. ?????? ??? ?????? ???? ??? ??????? ?? ???? ?? ?????? ??? ??????? ??? ?? ???? HAVING. ??? ???? ??????? ????
          HAVING COUNT(*) > 1
    
    						
    ???? ??????? ???? ?????? ???? ????? ??? ????? ????.

    ??? ?????? ???? ??? ??????? ?? ??????? ????? ???? ??? ?? ???? ???????. ????? ?????? ??? ???? ??? ??????? ???????? ??? ??????? ???? ????? ??? ????? I/O ??? ?? ???? ?? ???????. ?? ??? ?????? ????? ???? ???? ?????? ???? ?????? ??????. ??? ??? ??? ??? ????? ??? ?????? ??????? ?? ??? ???? ????? ????? ?? ???? ?????? ????????.
?? ????? equate ??????? ???? ?? ????? ????? ? ?????. ??? ???????? ???? ????? ??????? ???? ???? ? ????? ????? ???? - ?????? ????? ?????? ????? ??????? ?? ?????? ????????. ?? ?????? ???? ?? ???? ?????? ??????? ???????? ??? ????? ?? ?????? ???? ??? ????. ???? ?????? ?????? ?????? ?? ?????? ??????? ???????? ??? ??? ???? ??????? ?????? ????? ??????? ???????? ???? ???? hurt ??????.

?????? ????? ????????? ???????

???? ??? ????? ????????? ??????? ?????? ?????. ????? ??? ????? ???????? ???????? ????????? ???? ??????? ??? ????? ????? ????? ???????? ????????? ???? (RDBMSs) ? ?? ???? ??? ?? SQL Server. ??? ???? ?????, ???? ?????? ???? ????? ??????????? ?????? ?????? ????? ????????. ??? ???? ???? ??????? ?????, ?????? ????? SQL ????? ??? ?????? ?? ???? ????. ???? ????? ?? ???? ???? ?????? ????? ?????? ???? ??? ?????. ??? ??????? intrinsically ????????? ??????? ???? ????. ??? ????? ?? ?? ?????? SQL Server ??? ?????? ?????? ??????, ??? ???? ?????? ?? ?? ???? ?????.

??? ???? ??????:
  • ??????? ????? ?????
  • IN ? NOT IN ? ? OR ???????????
  • ?????? WHERE ???? ??? ????
  • ! = ????? ????? ???????? (????? ??)
  • ??? ????? ?????? ??? SUM
  • ??????? ????????? ?? ???????? ?? ????? WHERE
  • ????????? ??????? ?? ????? WHERE
  • ??? ????? ????? ???????? GROUP
?? ???????? ????? ?????? ?????? ???? ??????? ??? ?? ??? ????? ?????????. ??? ???? lessened ????? ??? ??? ??? ???? ????? ???? ???????? ??????? ??? ????? ????? ????? ?????? ?? ?????????. ???? ??? ??? ???????.

??????? ???? ????:
   SELECT SUM(SALARY) FROM TABLE
				

??? ??????? ???? ????:
   SELECT SUM(SALARY) FROM TABLE WHERE
   ZIP='98052'
				

??????? ???? ????:
   SELECT * FROM TABLE WHERE
   LNAME=@VAR
				

??? ??????? ???? ????:
   SELECT * FROM TABLE
   WHERE LNAME=@VAR AND ZIP='98052'
				

?? ?????? ?????? ?? ???? ??????? SUM ??????? ?? ????. ??? ????? ?? ?? ??? ??? sum_range. ?? ?????? ?? ???? ???? ??? ?????? ??????? ?????? ?????? ??????? ??? ?????? ?????? ??? ????? SUM ?? ???????. ???? ?? ???? ???? ?????.

?? ?????? ??????? ?? ??? ?? ??????? ?????? ??? ??? ???????. ??? ???? ?? ???? ????? ???? ???????? ?????? ??? ?????? ??? ??? ???????; ???? ?????? ??? ??????? ???????. ??? ?? ??? ??????? ??????? ??? ????? ??? ?????? ?????? @ VAR ??? ????? ??? ???????? ?? ???? ??????? ?????? ???? ???????.

????? ????? ??????? ??????? ????? ?????? ?? ???? AND ???????. ??? ????? ???? ?????? ????? ???? ?? ????? ?????? ?? @ VAR ?????? ??? ??????? ??????.

?? ??? ??????? ?? ?????? ??????? ?????? ?? ????????? ????? ???????? ??????? ???? ?????? ????? ???????? ?? ?????? ??????? ????? ????.

??? ??????? ??? RDBMSs ???? ??????? ????? ?????. ??? ?????? ??? ????? ????? ????? ????? ??? ?????? ????? ???????? ???????? ?????? ?????????. ??? ???? ?????? ?????? ??? ?????? ??????? ???? ???? ????? ???????? ?????? ????? ???? ?? ????? ???. ??? ????? ??? ????? ?????? I/O ????? ??????? amenable ???? ????? ??? ?????????? ??????? ?? ??????? ??????. ???? ????? ????? ?????? ??????? ??? ????? ??? ??????? ????? ??? ???? ??? ???? ?? ??????????.

?????? ????? ????? ????

?? ???? ?? ???? overstated ????? ???? ???? ?????? ????? ??????? ?? ?????? SQL Server. ????? ?? ?????? ?????? ?? ????? ?????? ??? ???? ??? ?????? ?????? ???? ?????? ? ?????? ?? puppet ??????. ???? SQL ???? ??? ????? ?????? ???? ????? ????? ??????????? ????? ??? ????? ?? ????? ?????? ?????. ??? ????? ?? ????? ????? ??? ??? ?????? ????? ????? ????? I/O ? CPU ??? ??????? ????? ???????? ?? ??? ??? ?????? ???? ?? ??? ????.

???? ?????? ?? ????? ?????? ?????? ????? ????? ??????? ???????. ???? ??? ??? ??? ????? ????? ???? ???????? ????? turnkey ??? ???? ????????? ??? ????? ?????? ???????? ? ??? ?? ????? ????? ??????? ???? ???? ??? ?????? - ???? ?? ?????? ????? ??? ?????? ? ?????? ?? ?????? ?????? ?? ???? ?? ??? ????? ??????? ??????.

???? SQL ?????? ??????? ???? ??? ????? ??? ??? ???? ???????? ????????. ?? ????? ???? ???? ??? ???? bog ?????? ??????? ?????? ?????? ??? ?? ???????? ????? ???.

??????? ?????????? ??????? ??????? ??????? ?????? ???? ????? ????? SQL Server:
  • ??????? ??????? ??????? ????. ??????? ????? ????? needlessly ????? (??? ???? ??????? ???? ????) ?? ????????? ??? ?????? ???? ????? I/O CPU ??????? ???? ??????? ?????? ??? ??? ?? ????????? ?????? ? ???? ????? ?????? ??????? ?????? ??????????. ?? ?????? ????? ??????? ??? ?????? ???????? ???????? ????? ???? ???? ??????????? ???? ????? ??????? ??????? modest ???????.

    ????? ?????? ????? ??????? ???? ????? ??? ???? ?? ??????? ???? ????? ??? ????? ????????? ? mandating ??? ???? ??????? ???? ???? improvised ???????????.
  • ?????? dbcancel() ?? ??????? ????? DB ???? ????. ??? ??? ???? ????????? ?????? ??????? ??????? ??? ??????. ??? ?? ?? ???? ????? ??? ???????? ??? ????? ????? ????????? ?????? ?????? ???????. ?????? ??? ?????? ?? ???? ?? ???? ??? ????? ?????? ???? ?? ???? ??. ??? ??????? dbcancel() ??? ?? ???? exercised ???????? ??????? ???? ????? ?????? ????????. ?????? ??? ???? ?? ?????????? ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
    117143: INF: ??? ? ????? ??????? dbcancel() ?? sqlcancel()
    ????? ??? ???????? ??????? ODBC ?? ??? ??????? ??????? sqlcancel() ODBC.
  • ?????? ?????? ???? ??????? ??? ????????. ?? ??? ????? ??? ??????? ?? ??????? ????? turnkey ???? ?????? ???? ??????? ??? ????? ?????????. ????? ??? ???? ?????? ???? ??? ??? ????? ?????.
  • ????? ????? ???? ???????. ?? ???? ????????? ??????? ???? ??? ?????. ??? ????? - DB ??????? ?? ????????? ODBC ?????? ???? ???????. ?? ????? ?????? ????? ??? ??? ?????? ??????? dbsettime() ??? ODBC ?? SQLSetStmtOption().
  • ?? ?????? ??? ????? ????? ????? ?? ???? ?????? ?????? ?? ?????? SQL ???? ?? ??????? ??? ??????. ?? ?????? ???? ??????? ???? ?????? ??? SQL ???????? ??? ???? ????? ????????? ??? ??? ???? ????? ???? ??? ????? ????????? "?" ???? ????????? "?" ?????? ?????? ?????????. ?? ??? ?????? ?????? ?????? ??? ???? ??? ?? ??? ????? ???? ??? ??? ??????? ?????? ???? ???? "???? SQL?" ???? ?? ???? ??? ????? ?????? ????????? ???????? ??????? ???? ???? ???? ?????? ??????.
  • ?? intermix ??? ???? "?" ????????? ??? ?????? ?????? ??????????? (OLTP).
  • ?? ??? ????? ??? ??????? ?? ??????? ????? turnkey ???? ??? ???????? ????? ????? ????????? ?????? ?????? ???????. ???? ?? ???? ??? ?????? ?? ????? ?????? ???? ???? ??? ?? ????? ??????? ??????? ????????. ????? ?? ?????????? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
    137983: ????? ??????? ?????? ??????? ???????? ?? SQL Server

?????? ????? ?????? ????

?? ???? tempting ??????? ????? ???? ??? ?? ???? ??? ???? ???? ????? ??????. ??? ???? ??????? ????? ???????, ??? ???? ???????, ???? ??? ????????? ???. ????? ??? ??? ????? Microsoft SQL Server ????? ?? ????? ?? ????? ?????? ???? ???? ???????. ??? ?? ??? ???????? ?? ???? ????? ??????? ? ??????????? ????? ??????? ??? ????? ???????? ?? ????? ??????? ??? ??????????? ?? ???? ????? ????????.

?????? ?? ???? ????????? ?? ??????????? ???? ?????? ??? ?????. ?????? ?? ???? ?? ??? ??????? ??????? ?????, ????? ??? ??? ???? ?? ????????? SQL ???? ?????? ??? ?????. ?? ?????? ????? ?? ??? ????? ???? ???? ??? ??????? ?? ??? ????????? ?????. ??? ???? ???? ???? ????? ??????? ?????? SQL ??????? ?? ??????? ???????? ?? ??? ??????? ?? ??? ?????? ??????? SQL ???? ?? ???????. ??????? ?????? ?? ??? ????? ???? ?????? ??? ???? ?? ?? ???? openly ???????. ???? ?????? ?????? ?? ??????? ????? ?? ????? ?? ??? ??? ???? ???? ???? ?????? ?????? SQL ???? ?? ??????? ?????? ???????.

?????? ??? ??????? ??? ????? ????? ????????? ???? ?????? SQL ??????? ? ??? ???? ????? - SQL ?????? openly.

??? ?? ???? ??????? ???? ?? ???????? ??????? ????? ???? ???? ? ???? ????? ???:
  • ?????? ??????? ?????? 4032 ???????? ??? ????????? ?? SQL Server 4.2 x "???? ??????? ??????? ????????" ? 6.0 ???? SQL "SQL ???????? ??????." ????? ??? ?????? ?????? SQL ???? ?? ??????? ??? ?????? ?? ??? ????? SQL.
  • ?????? ??????????? ???? ???? ???? ????? ??? Microsoft Network ????? ??? ?? "???? ????? ???????".
  • ??????? ODBC ??????? ?????? "????? ODBC ??? ???? ????????? ODBC. ???? ????? ODBC ?????? ??? ???? ?? ????????.
  • ??????? ?????? ?????? ?????? ?????? ???? ????? SQL ?? ????? ????? - DB ?? ODBC. ???? ???? ???? ?????? SQL ?? ??????? Lagoon ????.
  • ??????? ???? ????? SQLEye ????? ????? ????? Microsoft TechNet. ??????: ?? ??? ?????? SQLEye ????? ?????? ?? Microsoft.
??? ??? ??????? ???? ?? ??? ???:
  • ????? ??????? ???? ??????? ?? ??? ???????? ???? ??????? ??? ISQL ? ????? ?? ??? ?????. ?? ?????? ????? ????? ????????? ??? ????????? ?????? ???? ISQL ???????? ?????? ??????? ?????? ?????? ????? ??????? ??? ???. ????? ??? ?? ?????? ?? ??????? complicating ?????? ?????? I/O ?? ??????? ????? ??????? ??????.
  • ??????? SET IO ???????? ???? I/O ????????? ?? ?????????. ???? ????? ??????? ???????? ?????? ???????/???????. ????? ????? ?????? ????? ??? I/O. ??? ??? ??? I/O ????????. ??? ?????? ???? ???? ????? ???????. ??? ?????? ????? ??????? ?? ??????? ???? ??? ??? ??????? IO ???????? ?????? ??????? ?????? ?? ????? ????? ?? ??????? SET SHOWPLAN ON. ????? ????? ?????? ??????? SHOWPLAN ??????? ??? ?????? ?? ???? ?????? ????? ???? ???????? ???????? ???? ???? ?????? ?? ?????????? ????????. ??? ?? ??? ????? ??????? ?????? ?????? ??? ???????? ????? ?? ????? ??????? SHOWPLAN ?????? ???? ?????? ???? ??????.
  • ??? ??? ????? ????????? ?? ????? ????? ?? ??????? ??????, ??????? ????????? ?? ????? ????? ?? ??????? ?????? ???????? ???? ?????. ???? ??? ??? ?????? ?????? ??? ?????? ????? ??????. ??? ????? ??? ????? ??????? ??? ????????? ???? ????? ????? ?????? ???? ???????? ??? ????? ?? ????????? ???????. ??? ???? ??????? ?? ?? ????????? ???? ???? ??? ????? ??? ????? ????????? ???? ?? ????? ????? ?? ??????? ??????, ????? ????????? ?????? ???? ????? ????? ???.
  • ??? ?? ???? ??? ??? ????????? ???????? ??? ??????? ??????? ???? ???? ??????? ???? ?????? I/O ????? ????? ??????. ??? ????? ??? ??????? ???????? ?? ??????? ????. ????? ??? ?? ????? ?? ??? ???? ??????? ?? ????????? ???? ?? ?? ?????? ????? ????? "??" ????? ????? ????? ?? ??????? ???? ?????.
  • ??? ????? ????? ????????? ?? ??? ??????? ????. ??????? ???????? ???????? ?????? ?????? ?? ??? ???? ??? ?????? ????? ???? ?? ????? ??? ???????. ??? ????? ??? ? ???? ??????? ??? ???? ?? ???? WHERE. ???? ????? ?????? ?????? ?????? ?? ????? ???? ?? ???? WHERE ????? ?? ?? ????? ???? ????? ??? ??? ??? ????.
  • ??????? ??????????? ???????? ?????? ? ???? ???? ???????? ??????? ??? ???? ???????? ?? ???? WHERE ? ???? ?? ??? ?? ???? ?????. ?? ??? ????? ????? ??? ???? ??????? ?????? ????? ????????? ??? ??????? ?????. ??? ???? ??????? ????? ?????? ??? ?????? ???? ???? ???? ??? ????? ?? ????? ??????? ??? ????? ?? ????? ? ?? ????? JOIN ??? ???? ??? ?? ???? ?????? ??? ???? ?? ?????? ??? ??????.
  • ???????? ??? ??? ??????? ????? ??? ??????? ?????? ??? ??????? ?? ??????? ?? ???????. ????? ????????? ??? ???? ??? ????? ??????? ????? ?? ????? ?? ??? I/O.
  • ??? ???????? ??? ????? ? ?? ?????? ??????? ??????? ?????? ?? ??? ??? ?????? ????? ????.
?????? ?? ???????? ???? I/O ?? ???? CPU. ?? ?????? ?????? ????? ?? ??? ??? ??????? I/O "??" CPU ????. ????? ??? ?? ??????? ????? ??????? ??? ?????? ??????. ??? ???? ??????? ??? ??? ??????? CPU ???? ? ????? ???? ?? ??????? ??? SQL Server ???? ?? ???? ???? ??? ?????? ?? ??????? ??? ????? ????? ??????? ?????? ??? ??? ???? ??? ??? ??????? ??? ?????? ?????.

????? ????? ???? I/O ????? ???? CPU ?????????:
  • ??????? ????? ???? Windows NT ???????? I/O ????? ???? CPU. ?????? ???? ?????? ?????? "% Disk Time" LogicalDisk ??????. ?????? ????? "% ?????? ??? ???????" ?????? ?? ?????? ??????. ?????? ??? ??????? ???? ??? ????, ??? ?? ?????? ????? ????? Windows NT DISKPERF ?????? "diskperf -Y" ?? ???? ??????? ??? ?? ????? ????? ??????. ???? ????? Windows NT ?????? ??? ???? ?? ????????.
  • ???? ????? ????? ????????? ? ??? ??? ????? ??????? CPU ???? ???? ?????? (??? ???? ??????? ???? ?? 70 ???????) ?????? "% Disk Time" ???? ?????? ?????? ??? ???? ???? CPU.
  • ????? ????? ????????? ? ??? ?? ????? ??????? CPU ????? ???? ?????? (??? ???? ??????? ??? ?? 50 ???????) ??? "% Disk Time" ???? ?????? ????? ???? ??? ??? ???? ??? I/O.
  • ?????? ????? ??????? CPU ?? ??????? IO ??????????.

?????

SQL Server ?????? ??? ???? ???? ??? ????? ???????? ???????. ??? ?? ?????? ?? SQL Server 6.0 ???? ???. ?????? ??? ?????? ???????? ??? ??????? ????? ???????? ????? ???? ????????? ?????? ???????. ??? ??????? ?? ???? ???????? ?????? ??? ????? ?????? ??????. ???? ?? ???? ?? ??????? ????? ??? ??? ??? ???? ??? ??????? ????? ?? ????? ??? ???? ?? ?????????? ??? ????? ?????? ?????????? ?????? supportable. ??????? ???? ??????? ?????? ??????????? ??????? ?? ??? ??????? ? experimentation ?? ????? ???????? ????????? ?? ??? ??????? ???? ????? ????. ?????? ?? ????? ????? methodical ?? ????? ????? ?????? ?????? ??????? ?????? ??????? ??????? ????? ????? ??????.

???????

???? ???????: 110352 - ????? ??? ??????: 13/????/1426 - ??????: 3.1
????? ???
  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbmt kbinfo kbother KB110352 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????110352
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com