We recently used a free version of the Solar Winds db performance analyzer to track some problems we were having with our SQL and Oracle db's. We thought the tool worked great and it was quite helpful in diagnosing the problems. We would like to purchase the tool but it is out of the budget at $2000. What other tools are out there that has similar capabilities at a lower cost?
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…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…