Browse by Tags

SQL Server 2005 Bug Report
21 February 08 07:43 PM | robcarrol | with no comments

Saw this link to a SQL Server 2005 bug report on the Microsoft Connect site. I guess someone was having one of those days https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253524&wa=wsignin1.0

Filed under: SQL Server, 2005, Tools

Indexing Strategies
16 February 08 12:39 AM | robcarrol | 2 comment(s)

I attended the Scottish SQL Server User Group meeting during the week and heard a presentation from Martin Bell on his favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have...

Filed under: SQL Server, Tools, Performance

Dual Database Monitor Tool
02 February 08 11:42 PM | robcarrol | with no comments

I was giving a database mirroring demo last week and needed a way to quickly demonstrate the automatic failover capabilities in SQL Server 2005. I was at a session at TechEd IT Forum last year run by Paul Randal and Kimberley Tripp and remebered seeing...

Filed under: SQL Server, Mirroring, 2005, Tools

DTS Support in SQL Server 2005
02 February 08 11:24 PM | robcarrol | with no comments

Had a call this morning from a SQL Server developer looking to run DTS packages on a SQL Server 2005 machine with Integration Services installed. The user's problem was that he could not edit or run the DTS package via Management Studio. There is a simple...

Filed under: SQL Server, 2005, DTS, Integration Services, Tools