Welcome to MSDN Blogs Sign in | Join | Help

June 2007 - Posts

Its about time too

Posted Saturday, June 09, 2007 12:03 PM by boduff
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 Read More...
0 Comments
Filed under:

The Demo God Retires

Posted Friday, June 08, 2007 3:29 PM by boduff
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 Read More...
2 Comments
Filed under: ,

Whassup with my SQL Server

Posted Friday, June 08, 2007 3:14 PM by boduff
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 Dynamic Management Read More...
1 Comments
Filed under:

How not to use Power Point

Posted Friday, June 08, 2007 2:23 PM by boduff
Came across this great link on improving your power point skills: http://www.davidairey.com/how-not-to-use-powerpoint/ very funny ;-) Read More...
0 Comments

Smart Indexing Part II - Conditional Rebuilding

Posted Friday, June 08, 2007 12:45 PM by boduff
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 Read More...
2 Comments
Filed under:

Attachment(s): sp_index_rebuild.sql

Smart Indexing Part I - Analyzing Indexes

Posted Friday, June 08, 2007 12:25 PM by boduff
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 in a different Read More...
0 Comments
Filed under:

Attachment(s): Index_Analysis.rdl
 
Page view tracker