Answer Posted / sagi.rahul
New Advanced Features In SQL Server 2008: -
a. New Data Types (Date, Time, Spatial, FILESTREAM &
HIERARCHYID)
b. Resource Governor
c. Backup Compression
d. Data Compression
e. Policy-based Management
f. Filestreamdata
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why we use the openxml clause?
Explain system scalar functions?
Explain few examples of stored procedure over triggers?
How can I check if a view exists in a sql server database?
What is database architecture? : SQL Server Architecture
What are the different normalization forms?
Which tcp/ip port does sql server run on? How can it be changed?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How to convert a table data in XML format in sql server?
What is lock escalation? : sql server database administration
Write SQL queries on Self Join and Inner Join.
What are “lost updates”?
What is the contrast amongst drop and truncate?
What is bit data type?
Explain Normalization and DE normalization