Hi Experts can i get good articles relating to SQL Server 2008 on the following topics as i want to create a
Basically i need to know how the features work and if they are worth using.
1.Change data capture
2.filtered index and stats
3.Date and Time Functionality
5.Transact-SQL Row Constructors (Multi value inserts)
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…