Browse by Tags

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.net

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse