Database Technology

Every points I col­lec­ted for Data­base Technology.

MSSQL Traceflags — Deadlocks

SQL 2005, You can enable trace­flags to allow MSSQL Serv­er pro­duce more verb­ose inform­a­tion to error­log. Trace flag 1222 Trace flag 1204

MSSQL DMVs — Blockings

This is a very good DMV script that gives you blocking/​​locking even on page level and the SQL state­ment each spid is run­ning at the time.   SELECT tl.request_session_id AS Wait­ing­Ses­sionID ‚wt.blocking_session_id AS Block­ing­Ses­sionID ‚wt.resource_description ‚wt.wait_type ‚wt.wait_duration_ms ‚DB_NAME(tl.resource_database_id) AS Data­base­Name ‚tl.resource_associated_entity_id AS Waitin­gAs­so­ci­atedEn­tity ‚tl.resource_type AS Wait­in­gRe­source­Type ‚tl.request_type AS Wait­in­gRe­quest­Type ‚wrt.[text] AS Wait­ingT­Sql ‚btl.request_type Block­in­gRe­quest­Type ‚brt.[text] AS […]

Sybase IQ Introduction

Sybase IQ is an ana­lyt­ics serv­er designed spe­cific­ally for ana­lyt­ics, data ware­hous­ing, and busi­ness intel­li­gence envir­on­ments. Dis­tin­guished from con­ven­tion­al data­bases by its column-ori­en­ted, grid-based archi­tec­ture, pat­en­ted data com­pres­sion, and advanced query optim­izer, Sybase IQ is deployed in a wide vari­ety of set­tings deliv­er­ing unmatched per­form­ance, flex­ib­il­ity, and eco­nomy in even the most chal­len­ging report­ing and […]