SQL Server 2005 SP2 - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » SQL Server 2005 SP2 (RSS)
18 December 2007 15:31

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...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
15 August 2007 21:57

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....
Posted by simonsabin | 3 comment(s)
Filed under: , ,
27 July 2007 23:08

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...
Posted by simonsabin | with no comments
Filed under: , ,
08 May 2007 12:44

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...
Posted by simonsabin | with no comments
Filed under: , ,
30 March 2007 11:19

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
29 March 2007 15:06

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...
Posted by simonsabin | with no comments
Filed under: , , , , , , , , , , ,
28 March 2007 10:21

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
23 March 2007 10:18

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...
Posted by simonsabin | with no comments
Filed under: , , , ,
08 March 2007 07:54

Maintenance plan warning for SP2

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected. If a maintenance plan component uses TSQL of this nature USE [DBFred] GO DBCC CHECKDB.... GO USE [DBSimon...
Posted by simonsabin | with no comments
Filed under: , , , , ,
06 March 2007 16:13

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...
Posted by simonsabin | with no comments
Filed under: , ,
11 January 2007 22:30

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...
Posted by simonsabin | with no comments
Filed under: , , ,
20 December 2006 09:43

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...
Posted by simonsabin | with no comments
Filed under: ,
23 November 2006 21:28

Taskpad view version2

This is a pure plagurism of Jaspers taskpad report . I have reformated the report to look like the taskpad in EM as close as possible. You can download the taskpad view custom report here - google_ad_client = "pub-9351707026400773"; google_alternate_color...
Posted by simonsabin | with no comments
Filed under: , , ,
16 November 2006 02:58

DMVs impact on performance

Bottom line is very little if any. The way the SQLOS has been rearchitected the dmvs have been built into at the lowest level. This means the data exists, it is not a virtual table that is built up when the dmv is queried. So go for it use the DMVs and...
Posted by simonsabin | with no comments
Filed under: , , ,
16 November 2006 01:07

Custom reports in SQL 2005 SP2

You may have come across the fact that in SP2 you can deploy custom reports that are accessible in management studio. This reports can be run from any context in the object explorer tree. Whilst I think this is really interesting, I haven't played with...
Posted by simonsabin | with no comments
Filed under: , , , ,
More Posts Next page »