Hi, this should give you what you need.

It looks at the birthdate column, doesn't care about the year as its not age we're interested in, assigns the current year...

Im confused with the numbering of the indexes. You have a Primary key on the table PK_tab3, then state another one PK_tab3_7? Is this what you meant

Do the "non-technical" users also supply the parameters to the stored procs?

One way is to set an Excel workbook which can fire a stored procedure. You can also sanitise the...

Can you post the table def and query.

In the meantime its worth checking this out:

http://www.sqlservercentral.com/articles/books/65831/

The microsoft recommendation is

<= 5% - Do nothing

>5 and <= 30% - Reorganize (defrag)

>30% - Rebuild

But as you can see from the all the posts....it depends! And is worth...

Well im guessing the 1 row for 11/28/2008 suggest there is no data in the table for the month of November for 2009, and as the SQL only considers the...

This should get the records in your table with the latest date based on the current month. If this is not what you need you can alter the part that...

I don't think you can create DDL triggers on system databases. So possibly the best way is to do it through permissions as above.

Thats right...do you really need to do a SELECT * FROM

? Only include the columns you actually need, and if possible add a WHERE clause to limit the result...

Is there some code missing here??? The parameters are not being set at all from what you're showing us

This has happened because the database was restored with NORECOVERY, which allows you to restore further files, diff / trans log backups etc.

If you want to bring it online in...

You need it to give the DTA something to work from, IE - how else would it know where to improve performance if it doesn't know what the current performance...

Yes thats it. You'll need to create the temp table first. Then you can use dynamic SQL with EXEC to populate it.

Absolutely. And taking the CONVERT(...) out of your WHERE clause will also improve performance of your query too.

I was going to do this some time back and was looking at using event notification to write xml to a table and set up a trigger on that table...