RSCERO (12/10/2008)

---

We use a piece of custom code that is inlcuded in our report templates so the engineers no longer have to continue to write these IIF statements. Anytime they...

Jonathan Kehayias (12/9/2008)

---

What is really great is that the regular contributors are all open to being contacted for assistance on problems. I can email Paul Randal, or Geoff Hiten...

Good question Gail. I'd guess they don't want any changes made before the cutover to the new hardware?

I don't know that you would be able to do this using the tools you mention. A work around would be to do the copy to tables in the...

I agree with bitbucket. Using one of the tools our there is better than trying to write code yourself. What Barry suggests will work too, and I've modified...

SSIS physically moves data from one place to another. Views are stored queries that typically, Indexed views are different, do not physically store the data.

Brandie,

Here's a link to the Connect issue I created for it: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335613. It was fixed in a cumulative update which I list in my blog, http://wiseman-wiseguy.blogspot.com/2008/07/ghost-of-sql-server-2005-database-mail.html

Looks like someone to some persons fell in love with UDF's.

Developer1 - "Hey why write it over and over again, we can encapsulate it in a UDF and...

Please post some test data as well. Please see the links in my signature to see how to post the data to get better answers.

Santhosh (12/9/2008)

---

Truncate is logged.

Basically you need to find a 3rd party log reader like Lumigent's LogExplorer[/url]

In reality you will probably need to restore the database to before the...

Roy Ernest (12/9/2008)

---

That is going to be tough. Truncate table does not make any entry in the Log file if I am not mistaken. Do you have traces running that...

Unless you have a log reader then there probably isn't a way to see it. I don't think that would be included in the default trace that is running,...

Great link, Adi.

The problem is in the bolded and underlined line of code:

SELECT sum(TotalCleared), ClearedDate

FROM (SELECT TotalCleared, CONVERT(char(10), ClearedDate, 101) AS ClearedDate

FROM CTE

...

Joel is right, you are not providing any criteria to the query so it is doing exactly what you have asked it to do.