Browse by Tags

Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?

Published 12 December 7 12:7 PM | SSQA.net

While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and...

Filed under: performance, tools, replication, disaster recovery, dmf, database mirroring, encryption, compression, SQL Server 2008, Indexes From Every Angle, Database Maintenance, Interviews, Page Checksums, Backup/Restore, Conferences

SQL Server 2008 - enhanced feature in database mirroing "log compression"

Published 15 October 7 4:11 AM | SSQA.net

Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High...

Filed under: sql server, transaction log, log, features, 2008, database mirroring, compression, enhancement

New feature in SQL Server 2008 - compression how it works?

Published 3 October 7 9:42 AM | SSQA.net

Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and...

Filed under: sql server, microsoft, team, features, 2008, development, data capture, compression, backups, FAQ

Knowing about performance impact of simple use of procedures

Published 13 July 7 9:42 AM | SSQA.net

If you ask an experience DBA about the reasons for performance loss then the answer should be straight to look for SQL Server, Operating System and hardware counters for further investigation. Simultaneous access to shared resources causes bottlenecks...

Filed under: sql server, performance, dmv, compiled, impact, stored procedure, compression