in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL Server 2005 SP2 (RSS)

Browse by Tags

  • A significant part of sql server process memory has been paged out

    Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database pages will be removed from memory and thus SQL will...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Mar 10 2009

  • SQL 2008 OpsDay - Data and Backup Compression

    Hi all, Just wanted to thank all the attendees that participated to yesterday's event on SQL Server 2008 in TVP - Reading. We've received great feedback on the content of the day, and I really hope everybody went back home (for some of you I heard it was quite a long way!) sure that SQL Server...
    Posted to The Premiers (Weblog) by ThePremiers on Fri, Jun 6 2008

  • Get the tools the professionals use - ReadTrace is now available for SQL 2005

    One gripe about SQL 2005 was that read80trace wasn't available for it. That has now been rectified with the release of RML Utilities for SQL Server. This is an application that has a set of utilities for reading, analysing and replaying trace files. This is essential when doing any sort of analysis...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 18 2007

  • How big is your procedure cache?

    There have been continuing reports by most people I speak to about theire procedure cache becoming huge. Especially on 64 bit systems with lots of memory. Memory that you want for your data. The issue is due to the storinging of compiled adhoc plans. They just aren't getting aged out of the cache...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Aug 15 2007

  • SSIS - What is wrong with it

    I recently visited a client that was achieving wonders with DTS, I was there to give them pointers on SSIS. I spent a day gogin over SSIS from the control flow to configrations. A couple of things really got me was that SSIS is a new world that youhave to learn and boy there is a lot to learn, SSIS has...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jul 27 2007

  • SSIS : Lookup component doesn't handle data type changes

    I am always trying to optimise the storage I use this often results in changing between tinyint, smallint and int data types as the amount of data I need to capture increases. Unfortunately the SSIS lookup component doesn't handle such changes very well. Well it doesn't. If you change the the...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 8 2007

  • Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is now available

    Just published (April 17th): http://support.microsoft.com/kb/935356 The cumulative update package (build 3161) for SQL Server 2005 SP2 contains the SQL Server 2005 hotfixes that were not included in SQL Server 2005 SP2. Note This cumulative update package is also known as build 3161. Important notes...
    Posted to The Premiers (Weblog) by ThePremiers on Tue, Apr 17 2007

  • Hot fixes are always cumulative

    The one thing I learnt when I was at the MVP summit a few weeks ago was that hotfixes are always cumulative, in other words you get all the other hotfixes that have been made prior to your hot fix. The reason for this is that there is one SQL Server code branch that is used for releasing code. The code...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Mar 30 2007

  • Free 2GB SQL Server USB Keys

    We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink) The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t-shirts, books and USB keys. If you want to learn...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 29 2007

  • Update to the taskpad custom report

    Thank you to those people that informed me that my taskpad report was incorrectly reporting the backups times against the wrong type of backup. I have now fixed the report and have also included the backup types that are supported by SQL 2005. You can downlaod the new version of the taskpad custom report...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Mar 28 2007
Page 1 of 3 (21 items) 1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems