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 Temporary Tables, Table Variables and Recompiles - interesting scenario

Published 17 January 8 2:23 AM | SSQA.net

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices...

Filed under: sql server, performance, msdn, blocking, maintenance plan, tempdb, tablesample, best practice, monitoring, FAQ, benchmarking, table variable, temp tables

New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Published 2 January 8 6:36 AM | SSQA.net

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services...

Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat

Having 'black-box' recorder for SQL Server!

Published 2 July 7 3:34 AM | SSQA.net

Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight...

Filed under: sql server, profiler, performance, msdn, blogs, trace, black-box

Using Application roles and security - SQL Server 2005

Published 19 June 7 3:30 PM | SSQA.net

In SQL Server, you can create database roles for easier administration of permissions in a database. Instead of granting individual permissions to each user separately, you can group users with the same permission needs by making them members of the same...

Filed under: application, sql server, performance, msdn, security, roles