Bob Duffy's Blobby Blog

SQL Server | BI | Dot.Net | Office | Sharepoint | MCE | Database Stuff

June, 2007

Posts
  • Bob Duffy's Blobby Blog

    Its about time too

    • 0 Comments
    Being a huge fan of Chris Taylor and the orignal Total annihilation (yes we forgive you for TA kingdoms, Gnugs rule and I married She-Devil), I'm currently playing Supreme Commander http://www.supremecommander.com/ It had been thought that this would...
  • Bob Duffy's Blobby Blog

    The Demo God Retires

    • 2 Comments
    I was just back from the first Irish Microsoft Technologies Conference http://imtc.firstport.ie/ I hope the video gets posted up. Rob Burke went out in style with the Demo to end all Demos. We had XNA, PC's XBoxes, WII controllers, Scottish Monsters controlled...
  • Bob Duffy's Blobby Blog

    Whassup with my SQL Server

    • 1 Comments
    Technorati tags: SQL SQL Server 2005 includes some great new dynamic management views and functions to help find out what is going on. These three in particular work quite well together. View/function Type Description sys.dm_exec_requests...
  • Bob Duffy's Blobby Blog

    How not to use Power Point

    • 0 Comments
    Came across this great link on improving your power point skills: http://www.davidairey.com/how-not-to-use-powerpoint/ very funny ;-)
  • Bob Duffy's Blobby Blog

    Smart Indexing Part II - Conditional Rebuilding

    • 5 Comments
    The Maintenance plan Wizard in SQL Server 2005 allows us to create an SSIS package that ReIndexes all Indexes. This is great for smaller systems, but on larger systems (over 10GB or so), the re-indexing can take a long time reducing the maintenance window...
  • Bob Duffy's Blobby Blog

    Smart Indexing Part I - Analyzing Indexes

    • 0 Comments
    Introduction There are three items that any SQL Server maintenance plan should cover at a minimum: Backup, DBCC and ReIndexing. Indexes much like your old laptop disk drive will become fragmented. As data is inserted a “page split” may put data...
Page 1 of 1 (6 items)