Friday, March 14, 2008

Sql Server 2008 upcoming

What is new and in sql server?
1-) It is possible to set restriction on users using resource governor. However restrictions can be defined on only CPU, not disc IO or anything else.
2-) On the fly data encryption is supported now.
3-) Since sql server 2005, online restore is available and there are some improvements in 2008
4-) You are no more required to take server trace in order to audit in detail. In 2008 audit supports auditing session activities.
5-) There is a new tool for tuning: Performance studio
6-) Like ADDM (AWR) in oracle, sql server 2008 has its own way of workload repository.
7-) Mirroring is able to compress transaction data before sending it to destination which benefits network bandwidth
8-) Compression is available at table level.
9-) Compression is available for backup operations.
10-) New change data capture (CDC) implementation
10-) There are some improvements on SSIS. For example it uses ADO.NET drivers instead of ODBC.

Actually there are many more changes and improvements in sql server 2008. These are the significant ones for me.

Friday, March 7, 2008

SQL Server Table Hint

FROM dbo.tbl_customers c with(nolock,index(IDX_cust_parentrowid)),dbo.rloan_appinfo r with(nolock, index(IDX_status))
c.cust_parentrowidno = r.rlai_rowidno
AND r.rlai_status='3'
AND c.cust_parentprocessid=7
AND c.cust_type = 'B'