Tag: databases
Questions Related to databases
-
Index Partitioning
-
Range Partitioning
-
Rowid Partitioning
-
List Partitioning
-
Hash Partitioning
-
Composite Range Hash Partitioning
-
allows Logical Rowid's to remain independent of physical rowid's
-
allows rows to move across partitions
-
allows rows to be physically located in a different tablespace, while remaining tagged to a partition
-
allows rows to be copied to non-partitioned tables
-
Online Redifinition method
-
Hybrid Method
-
Export/Import Method
-
Insert with a Subquery method
-
Dump Exchange Method
-
Partition Exchange method
-
sp_how
-
sp_configure
-
sp_who2
-
sp_get_processinfo
-
sp_helpserver
-
sp_configure
-
sp_helpdb
-
sp_get_serverinfo
-
sys.dm_os_schedulers
-
sys.dm_exec_requests
-
sys.dm_db_index_physical_stats
-
sys.dm_db_index_usage_stats
-
SQL Server Browser
-
SQL Server Integration Services
-
SQL Server Full-Text Search
-
SQL Server Agent
-
Simple
-
Full
-
T-log
-
Bulk-Logged
-
sp_who2
-
dbcc checkdb
-
dbcc inputbuffer(spid)
-
dbcc processinfo