Browse by Tags

All Tags » SQL Server 2005 SP2 (RSS)
10 March 2009 21:52

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...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
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...
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...
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 | 3 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"...
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 | 1 comment(s)
Filed under: , , , , ,
More Posts Next page »