Index
Special Characters
- (Negative) operator, 559
- (Subtract) operator, 559
# (pound) signs, 329
$ (dollar) signs, 329
$PARTITION operator, 562
% (Modulo) operator, 295, 559
% (percent) suffix, FILEGROWTH, 149
% (Wildcard-Characters to Match) operator, 559
& (AND) operator, 296, 298, 461, 566
& (Bitwise AND) operator, 560
* (asterisk) operators. See star (*) operators
* (Multiply) operator, 559
* (Multiply) operators, 295
* (star) operators, 448, 457, 460
/*…*/ (Comment) operator, 562
@ (at) sign, 329
@@CONNECTIONS function, 562
@@CPU_BUSY function, 562
@@CURSOR_ROWS function, 562
@@DATEFIRST function, 562
@@DBTS function, 562
@@ERROR function, 562
@@FETCH_STATUS function, 562
@@IDENTITY function, 427–428, 562
@@IDLE function, 563
@@IO_BUSY function, 563
@@LANGID function, 563
@@LANGUAGE function, 563
@@LOCK_TIMEOUT function, 563
@@MAX_CONNECTIONS function, 563
@@MAX_PRECISION function, 563
@@NESTLEVEL function, 412, 563
@@OPTIONS function, 563
@@PACK_RECEIVED function, 563
@@PACK_SENT function, 563
@@PACKET_ERRORS function, 563
@@PROCID function, 563
@@REMSERVER function, 563
@@ROWCOUNT function, 389–390, 440, 455, 563
@@SERVERNAME function, 563
@@SERVICENAME function, 563
@@SPID function, 564
@@TEXTSIZE function, 564
@@TIMETICKS function, 564
@@TOTAL_ERRORS function, 564
@@TOTAL_READ function, 564
@@TOTAL_WRITE function, 564
@@TRANCOUNT function, 564
@@VERSION function, 564
[ ] (Wildcard-Character(s) to Match) operator, 562
[NOT] LIKE expression, 462
[^] (Wildcard-Character(s) Not to Match) operator, 562
^ (Bitwise Exclusive OR) operator, 560
^ (Exclusive OR) operator, Bitwise, 296
^ (OR) operator, Bitwise Exclusive, 296
_ (underscore) signs, 329
_ (Wildcard-Match One Character) operator, 562
| (Bitwise OR) operator, 560
~ (Bitwise NOT) operator, 560
~ (Bitwise NOT) unary operator, 299
~ (NOT) operator, Bitwise, 296
+ (addition sign) operator, 295, 298, 559
+ (Positive) operator, 559
+ (Positive) unary operator, 299
+ (String Concatenation) operator, 559
< (less than) operator, 297, 462
< (Less Than) operator, 560
!< (not less than) operator, 297, 462
!< (Not Less Than) operator, 561
<= (less than or equal to) operator, 297, 462
<= (Less Than or Equal To) operator, 561
<> (Not Equal To) operator, 561
<> or != (not equal) operators, 462
= (equal) operator, 296, 297, 462
= (Equal) operator, 560
!= (Not Equal To) operator, 561
> (greater than) operator, 297, 462
> (Greater Than) operator, 560
!> (not greater than) operator, 297, 462
!> (Not Greater Than) operator, 561
>= (Greater or Equal) operator, 297
>= (greater than or equal to) operator, 462
>= (Greater Than or Equal To) operator, 560
10 (Ten minutes loss) tolerance, 183
10 (Ten minutes wait) restoration, 183
/ (Divide) operator, 559
/ (Divide) operators, 295
- (Negative) unary operator, 299
- (Subtract) operators, 295
2PCs (two-phase commit processes), 502–503
- - (Comment) operator, 561
32-bit SQL Server 2007, 16
64-bit SQL Server 2007, 16
A
ABS function, 564
ABS(numeric) mathematical function, 318
access, SQL Server, 107–109, 117–118
access control, 101–102
access control lists (ACLs), 104, 124
access methods, engine, 63
Access Methods SQL Server object, 547
access tokens, 104
ACLs (access control lists), 104, 124
ACOS function, 318, 564
active backup, 179
active cluster configurations, 264–265
Active Directory, 114
active mirrors, 244–245
active servers, 244–245, 261
active/active cluster configurations, 264
active/passive cluster configurations, 264
Activity Monitor Window, 533
ad hoc reporting, 469
Add Counters dialog box, 544–546
ADD FILE argument, 153
ADD FILEGROUP argument, 154
ADD LOG FILE argument, 153
addition sign (+) operators, 295, 298, 559
address space, 54, 56–57
Address Windowing Extensions (AWE), 53, 55–56, 277
administration
availability, 256
.NET Framework, 9
administration role, availability management, 257
administrative architecture, SQL, 12, 81–82, 86–87
administrative database roles, 122
administrative wizards, 83
AFTER triggers, 382, 388, 391–392
aggregate functions, 317–319, 465, 468
aggregate queries, 19
Alert Job, SQL Server Agent, 243
alert mechanism, SQL Server Agent, 17
alerts, 89
Performance Monitor, 549–551
SQL Server Agent, 88
SQLAgentMail, 92
Alerts service, SQL Server Agent, 76
alias
column, 457–458
table name, 459
alias types and data integrity, 377–378
ALL keyword, 454, 463, 476, 564
ALL logical operator, 298
allocation maps, 39, 42–44
ALTER APPLICATION ROLE function, 564
ALTER ASSEMBLY function, 564
ALTER ASYMMETRIC KEY function, 564
ALTER AUTHORIZATION function, 564
ALTER CERTIFICATE function, 564
ALTER CREDENTIAL function, 564
ALTER DATABASE…MODIFY FILE statements, 139
ALTER DATABASE statements, 150–158, 564
arguments, 153–158
changing recovery model using, 186
and default filegroup, 141
moving data, log, and full-text files, 172
syntax, 150–153
ALTER ENDPOINT function, 564
ALTER FULLTEXT CATALOG function, 564
ALTER FULLTEXT INDEX function, 564
ALTER FUNCTION function, 565
ALTER INDEX function, 565
ALTER LOGIN function, 565
ALTER MASTER KEY function, 565
ALTER MESSAGE TYPE function, 565
ALTER PARTITION FUNCTION function, 565
ALTER PARTITION SCHEME function, 565
ALTER PROCEDURE statements, 408–409, 414, 565
ALTER QUEUE function, 565
ALTER REMOTE SERVICE BINDING function, 565
ALTER ROLE function, 565
ALTER ROUTE function, 565
ALTER SCHEMA function, 565
ALTER SERVICE function, 565
ALTER SERVICE MASTER KEY function, 565
ALTER SYMMETRIC KEY function, 565
ALTER TABLE statements, 363, 366–367, 372, 374, 375–377, 565
Alter Trigger code, 389
ALTER TRIGGER function, 565
ALTER USER function, 566
ALTER VIEW function, 566
ALTER XML SCHEMA COLLECTION function, 566
Alternate Synchronization Partners feature, 220
Amdahl, Gene, 258
American National Standards Institute (ANSI), 12
analysis services, 19–20
analytical data, 358
AND (&) operator, 296, 298, 461, 566
ANSI (American National Standards Institute), 12
ANSI compliance options, ALTER DATABASE statements, 157
ANY function, 566
ANY keywords, 463
ANY logical operator, 298
APIs (Application Programming Interfaces), 12–13, 78, 501, 504
APP_NAME function, 566
application development architecture, 12–14
Application Programming Interfaces (APIs), 12–13, 78, 501, 504
Application Server mode, 14
APPLOCK_MODE function, 566
APPLOCK_TEST function, 566
approximate numerics data types, 302
ARITHABORT Sql_option, ALTER DATABASE statements, 157
arithmetic operators, 295
Arrays feature, CLS, 335
article component, SQL Server replication services, 215
Articles dialog box, Management Studio, 229–230
AS principal, 134
ASC argument, 467
ASCII function, 311, 566
ASIN function, 318, 566
ASP.NET Web application security, 350
assemblies
in Common Language Runtime, 342–350
elements of, 343–347
locating, 343
overview, 342–343
role of, 347–349
strong names, 349–350
as version boundaries, 349
installation to SQL Server, 420
and metadata, 338
side-by-side execution, 340
Assemblies section, Common Language Runtime, 332
ASSEMBLY PROPERTY function, 566
assignment operators, 296
asterisk (*) operators. See star (*) operators
ASYMKEY_ID function, 566
Asynchronous I/O, 58
at (@) sign, 329
ATAN function, 318, 566
ATN2 function, 318, 566
atomicity, transaction, 498–499
attributes
metadata descriptions of, 345
XML, 512
attributes element, XML documents, 513
auditing, security, 134–135
authentication modes, 100–101, 105–109
AUTO mode, FOR XML statements, 469, 515
Auto_option section, 156–157
autocommit transactions mode, 499–500
autoexecuted stored procedures, 413–414
auto-increment, 447
automated administration architecture, SQL Server, 86–87
automatic fail-over, 245, 251
automatic memory management, 337, 340–342
autonomy/store forward, 212
availability, 255–285
of backups in disaster recovery, 181
client/server architecture, 15–16
data, 7
management of, 256–257
overview, 255
scale-up, 258–261
SQL Server scale-up/scale-out, 261–263
average counting, 540
AVG COMPUTE argument, 467
AVG function, 319, 566
AWE (Address Windowing Extensions), 53, 55–56, 277
EAN: 2147483647
Pages: 239