You can also try SQLSpec. We are in the process of evaluating that currently. It can build some nice "webby" reports.

http://elsasoft.org/index.html

Tara-1044200 (11/13/2009)

From the above query i am getting the list of databases but 5...

Thanks Gail.

With that note, the query would also change (when using sys.objects).

Select OBJECT_NAME(p.object_id) as TableName,SUM(rows) as NumRows,index_id

From sys.partitions p

Inner Join sys.objects o

on p.object_id = o.object_id

Where index_id in (0,1)

And o.type =...

dragee

Why?

Just because it has stuck with me since watching the food network the other night.

Try using a replace.

replace('"Term: Fall 2009 Subject: EDCI; Course: 257 Sensory Motor Sec: LL; Will Use Calendar"',';','-')

or some character that will not cause you the grief.

Agree, the answer to that question is - "It depends"

If we are using RBAR, on a 386, with 256MB Ram - I'm sure we could bring the house down with...

Same as Lynn said, with a reference

http://www.mssqltips.com/tip.asp?tip=1044

This article discusses the method you are using. The base idea is to do a rowcount without the table scan.

Here are a couple...

ROFLMAOTMGH

...TMGH = til my gut hurts

Once you eliminate the date cast(floor(... stuff and the subqueries, as a data integrity note - you should verify that the dates being picked up in your between clauses is...

Just ran into a query here @ SSC that has 36 table joins - asking for tips to improve.

You can make it work with a #table as well. It is trickier,...

Lowell (11/12/2009)

mea culpa; it was low hanging fruit and i'm...

Looks like about the same problem you ran into the other day in this thread.

Here is a blog about the same sort of issue.

This is also along the lines of...

The best options will depend on your environment. Test the options in your environment.