G33kKahuna,

Thanks for reading the article and I am sorry you did not find it useful.

If the tools you use always give you what you want and you never have...

david.murden (12/1/2009)

---

Hi Jacek0,

I might be being a cabbage but i have never seen :: used as a prefix to a join or anywhere else in sql actually. I had a...

Did you try to call the SP in a loop from the SQL Server Management Studio to make sure the performance hit is not SQL related? It looks like you...

The performace issues related to the transaction log (and data files as well) I have seen are related to the autogrowth. Now I tend to create databases and log files...

magarity (11/7/2009)

---

Since all I have is a dev server I wish the logs would go away automatically. I understand the importance of production systems' logs but I have no...

I would say yes. It is a judgement call between convenience and data loss risk.

I have to admit that my previous statement about the data logged is not exactly...

James_DBA (11/9/2009)

---

While the FULL recovery model will log more details to the log, the SIMPLE recovery model will log...

John Mitchell-245523 (7/17/2008)

---

Nobody has yet mentioned another reason for not shrinking the log on truncate: physical file fragmentation. If, when the log grows, it can't find a contiguous area...

Great article. I really liked the 'go back to the 70' part.

Sometimes when I see how stuff is done just because the computer can handle the load it drives...

I think you have to remove 'integrated security=true' from your connection string.

No. I don't think so.

How do you know which invoices to use? Use the same logic in the WHERE clause.

I would strongly recommend you read 'Pro SQL Server 2005 Disaster Recovery" by James Luetkehoelter. The book pretty much explains all aspects of the 'data preservation' - backup being just...

DECLARE @Body NVARCHAR(2000)

SELECT

@Body = @Body + InvoiceNo + ' - ' + Message + CHAR(13) + CHAR(10)

FROM ....

WHERE ...restriction for one contact.

This should work for one contact at a...

Red Gate used to have a free ebook "Dissecting SQL...

I think you may get a performance gain if you change your index to include F_Sales_Prod.net_amt

It would become a covering index for this query. (If I read the SQL statement...