Sunday, May 12, 2013

new concepts in SQL since sql server 2008


sp_releaseschemalock
xp_sqlagent_is_starting
sp_getschemalock
sp_enable_sql_debug
xp_loginconfig
sp_xp_cmdshell_proxy_account
sp_control_dbmasterkey_password
sp_droporphans



extended events
rank/row number/dense_rank/ntile
filestream/filetable
try/catch/throw
GUID
common table expression
data collector (management data warehouse)
pivot/unpivot
cross apply/outer apply
output
deterministic/non deterministic functions
trancount
transaction management
configure SSAS/full text indexing
TDE
subnet cluster
audit
xact_abort
service level security
core mode installation
RAID
locks
coalesce
statistics
plan guides
persisted columns
partitioning
query hints