Tag: 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

1441

25

8000

1433