Wouldn't this work?

[font="Courier New"]SELECT

   Fl.folderId

   ISNULL(COUNT(EL.eventTargetId), 0) AS NumberofHits

FROM

   folderList FL LEFT OUTER JOIN

   na_production.dbo.Pagelist PL ON

           FL.folderID = PL.folderID AND

           PL.moduleID = 576456718 AND

          ...

I'm going to throw a guess at this one. You have autogrow on the database and the autogrow process is causing the log file to grow. Try making...

A GO after the create schema should work as well.

You could also do Alter Table Add password_encrypted varbinary(128) then

update table

Drop the old column and then in SSMS rename the encrypted...

I don't know what forum this was in originally, but I have to disagree with Steve about it being a T-SQL question. You have done all you can in...

Michael Earl (4/30/2008)

---

...

The initial pause may be because your statistics are out of date because of a significant change in the number of records each time you load. You...

Bill Marriott (4/30/2008)

---

Nice article but now I am wondering how to 'fix' my db!

Are there any utilities out there that will bulk 2-part name my table references in all my...

You should be able to use distributionlist@yourdomain.com just like any other email address set up on the exchange server. The distribution list is setup on the exchange server right?

Oops, my bad, I actually had corrected the code, but forget to add the correction to my post. You just need a GO on the line before the create...

John is right you need to use an outer join, but first you need to have a list of all the months. This solution assumes you have a months...

How are the users querying the database? If they are using SSMS, you can change the settings for queries under Query -> Query Options to default to Read Uncommitted.

I agree with Grant, 1 Db with different schemas for the amount of data you are looking at.

GSquared has it right although you need to change the data type of the column as well, which you can't do while it has data in it. You could...

Can you give some example data and table structure(s)?

Are you returning all the data needed in the report in one data set or multiple data sets? What does the...

I don't know that I would say "evil", but dangerous would be a good term. I mean how can it be evil when the whole point of storing data...

Here is a link to another forum discussing parameterized views (which SQL Server does not have) which applies to what you want to do, I think.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73034