Which of these are types of table partitioning?
Index Partitioning
Range Partitioning
Rowid Partitioning
List Partitioning
Hash Partitioning
Composite Range Hash Partitioning
The "ENABLE ROW MOVEMENT"
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
Which are the 4 ways of partitioning an existing table?
Online Redifinition method
Hybrid Method
Export/Import Method
Insert with a Subquery method
Dump Exchange Method
Partition Exchange method
What is the command to get information about the currently running processes in SQL Server?
sp_how
sp_configure
sp_who2
sp_get_processinfo
What is the command to view/change SQL Server level paramaters/properties?
sp_helpserver
sp_helpdb
sp_get_serverinfo
Which DMV is used to identify fragmentation of Indexes
sys.dm_os_schedulers
sys.dm_exec_requests
sys.dm_db_index_physical_stats
sys.dm_db_index_usage_stats
Which of the following SQL service is dependent of SQL Server service?
SQL Server Browser
SQL Server Integration Services
SQL Server Full-Text Search
SQL Server Agent
What are the 3 recovery models in SQL Server?
Simple
Full
T-log
Bulk-Logged
What is the command to get information about the currently running query for a particular process?
dbcc checkdb
dbcc inputbuffer(spid)
dbcc processinfo
On what default port does SQL Server run?
1441
25
8000
1433