I've got a DTS Job that locks a table (hopefully) and exports all the data with the status 'X'. It then updates the status to 'Y'. I need to have the job run once an hour, in order to export the new data that came in. When the job runs it overwrite the data that I've already exported. Where is the parameter I need to set, to tell DTS to append the data?
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed