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: , ,
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...
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: , , ,
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...