Browse by Tags

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. We...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 08-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 Blog on SQL Server Stuff (Weblog) by simonsabin on 07-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 data types...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 05-08-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 Blog on SQL Server Stuff (Weblog) by simonsabin on 03-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 Blog on SQL Server Stuff (Weblog) by simonsabin on 03-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 Blog on SQL Server Stuff (Weblog) by simonsabin on 03-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 obvious...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-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 Blog on SQL Server Stuff (Weblog) by simonsabin on 03-06-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 if (socialButtons!=null) { socialButtons...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 01-11-2007
SQL Server 2005 SP2 - December CTP

Thanks to Paul the December CTP is now available. The first notable change is that custom reports now use the .rdl extension and not the .rdlc extension. This means that you can easily develop reports in BI studio and use them in Management Studio. if (socialButtons!=null) { socialButtons(); } - google_ad_client...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 12-20-2006

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