SqlServer-QA.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 occur in a database the changes are formed as transactions that are held in buffer pool ...

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 per the schedule. Also you may be aware about 'postponement' of SQL Server  2008 version release ...

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 here I would like to suggest - How to Detect Table Fragmentation in SQL Server 2000 and ...

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 to download files from the Microsoft download site, you have to submit a Online Customer ...

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 for all service pack updates aka they call it now as a software update packages for ...

Cross post from KalenDelaney-SQLBlog content, very interesting!

If you are a SQL DBA and attended Tech-ed 2007 in Orlando then you wouldn't miss the opportunity see the Paul Randal's  session on '''Secrets of Fast Detection and Recovery from Database Corruptions' ''. If you have missed the opportunity to see that session in Tech-ed or missed total opportunity to visit Tech-ed then don't worry here is ...

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 to investigate, similarly how about having such facility ...

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 Server 2005 for the databases you can recover the data effectively.  SQL Storage ...

On day-to-day basis a DBA might come across with the issues on the fragmentation on the database, it may not be possible to design the database that will be totally efficient and optimum to perform without any issues. Due to the fact of data inserts, modifications and deletions ((DML tasks) the fragmentation will be obvious and by default SQL ...