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

Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!

Published 27 February 8 2:1 AM | SSQA.net

I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as...

Filed under: sql server, msdn, microsoft, blogs, 2008, 2005, visual studio, launch, windows server, product release

SQL Server indexing - when to reorganize or rebuild?

Published 21 January 8 4:30 AM | SSQA.net

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...

Filed under: sql server, indexes, msdn, blogs, rebuild, schema, best practice, schedule, links, performance monitoring, reorganize

SQL Server 2005 Service Pack 2 Cumulative Update 5 instalment available for download with a request to CSS!

Published 27 December 7 2:2 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation

SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!

Published 24 December 7 4:42 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, microsoft, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation

How to find whether that service pack file is a 32 bit or 64 bit?

Published 1 November 7 6:44 AM | SSQA.net

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin

Interesting point on SET OPTIONS in SQL Server 2005

Published 19 July 7 1:53 PM | SSQA.net

Cross post from KalenDelaney-SQLBlog content, very interesting!...( read more ) Read More...

Filed under: sql server, msdn, blogs, ssms, sqlblog, set, options, kalen delaney

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

Recover the corupt databases with the features in backup & restore - SQL Server 2005

Published 6 May 7 4:50 AM | SqlServer-QA.net (SSQA)

Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL...

Filed under: sql server, msdn, microsoft, high availability, backup, blogs