I like the article and the example.

I've tried to install it on my local sql2005STD instance wich has clr enabled and my testdb is trustworthy.

The vb.net version as well as...

about the same goes for "Spotlight on SQLServer" from Quest software.

First of all, you query is to heavy !

You use 3 objects and only join two of them, leaving the 3-th one for crossjoining ???

First I would start looking in the Windows event log searching for IO-errors (cards or disks) if you can perform a checkdisk,..

Then check if there are memory errors.

Then perform dbcc...

indeed F1 just brings up BOL,

shift-F1 brings up BOL and positiones to the selected statement in possible.

e.g. create index x on mytable (y)

when you select "create index" and then...

Books Online is a valuable resource. It contains the help for SQL and SQLServer

From Query Analyser, you can access it pressing Shift +...

how about

select substring(account_number,1,2) as Acc_prefix, count(*) as Counter

from your_accounting_table

group by substring(account_number,1,2)

order by Acc_prefix

Yelena's method is straight forward and manageble.

Just keep in mind you'll have to rebind the views when altering database object in your base-db.

 I'd...

- collect sqlserver version info.

- use sp_helpdb to get a first impression of the db-settings that are in use.

- perform sp_updatestats / dbcc updateusage for all db that use "autoupdate...

do all tables have a clustering index ?

I guess not. So for this maintenance time, you may want to create one (for each table ! ). If you just pick...

Check out : http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.asp

search SSC for "fragmentation"

It was the featured article in the daily newsletter of 2006/04/21.

That's why I tought I just might add a path towards sql2005

Anyway, nice...

looking good overhere.

Only thing is to plan the reboot ! (who wouldn't )

It is a "strange" thing that  it does not recognize it's own need for reboot (sql native client...

I'm not that much into reporting server, but you can also have this solved in your select query

SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth

, CONVERT(char(11), dateadd(mm,-1, MAX(src_date)))...

converting to soon.

SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth

FROM tbl_src_date