I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

December 2008 Blog Posts

SQL Server Management Studio 2008 suggests missing indexes with actual execution plan

This is something I haven't noticed before but I think it's mighty cool! When you choose to Include the Actual Execution Plan in SSMS 2008 it suggest any missing indexes it thinks that are needed. Plus it also calculates the performance benefit from adding them. I'm guessing the number (green 84.7361 in the picture) is in percent... So it's like a Database Tuning Advisor "Lite" :)) And best of all this also works when you're connected to a SQL Server 2000 or 2005.   This is what it looks like:   I'm starting to like this new SSMS...

posted @ Monday, December 29, 2008 8:10 PM | Feedback (7) | Filed Under [ SQL Server ]

Advanced SQL Server 2005 Express Job Scheduling

I've written a second article here on SQL Team on how to schedule jobs in SQL Server 2005 Express. Intro In my previous article we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself including run once, daily, weekly, monthly absolute and relative scheduling: Scheduling Jobs in SQL Server Express - Part 2   And part 1 of this series: Scheduling...

posted @ Wednesday, December 03, 2008 11:29 AM | Feedback (5) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET