Tag: databases
Questions Related to databases
-
ALTER DATABASE … ADD FILE
-
ALTER DATABASE … MODIFY FILEGROUP
-
ALTER DATABASE … ADD FILEGROUP
-
ALTER DATABASE … REMOVE FILEGROUP
-
Read-only
-
Write-Only
-
Default
-
Primary
-
Service Broker
-
Database Mirroring
-
Extended MAPI Profile
-
Microsoft Exchange Server
-
In the Simple recovery model, all transactions are logged.
-
In the Bulk-Logged recovery model, all transactions are logged.
-
In the Full recovery model, most transactions are minimally logged.
-
In the Simple recovery model, most transactions are minimally logged.
-
max memory
-
physical memory
-
logical memory
-
network memory
-
dbcc checkdb
-
dbcc checkverify
-
dbcc checkstorage
-
dbcc checkalloc