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
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
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
SQL Server Trace Event Definitions

If you are using Event Notifications or capturing events in Profiler you undoubtedly have noticed that MS have used the same columns (xml elements) for storing different data for each event. For example there is an element called "integer data". You may ask what is stored in here cos it ain't...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Mar 23 2007
SP2 has changed, make sure you download the latest file

A regression bug was introduced in SP2 that resulted in a view problems when used in evironments that had other versions of SQL 2005 i.e. RTM and SP1. The SP2 download has been changed to include this hotfix. http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx The change...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Mar 6 2007
Task pad report

Following feedback I have issued another version of the taskpad report. This now works with databases that have been created by users that have access to the sql server via a group membership You can download the report from http://sqlblogcasts.com/files/10/default.aspx - var height=90;var width=720;

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 11 2007

Page 1 of 2 (17 items) 1 2 Next >