Excellent, thanks again!

David 62010 (12/1/2009)

---

Check out the SQLScrubs project. First release targets SSRS 2008. Extracts execution log data into a DW, and provides a set of reports so you can track slow...

Then I'm on the right...

I'm having the same issue with SSIS, BIDS 2008.

I'm at the point where I'm thinking to uninstall and re-install BIDS...

Here is another link that is also quite relevant...

I realize now that this is because this query is measuring VIRTUAL memory, which in 64-bit is enormous.

What I'm actually after is the largest chunk of PHYSICAL memory available to...

george sibbald-364359 (11/9/2009)

---

I don't think you actually enable AWE, that sp_configure option has no effect on a 64 bit system. It is used behind the scenes in 64 bit to...

Silverfox (11/9/2009)

---

Marios Philippopoulos (11/9/2009)

---

Can someone explain to me, in simple terms, why enabling AWE is a good idea in 64-bit SQL?

The following msdn link supports this idea, although, with due...

There has to be a compelling reason for choosing a 3rd-party tool over SQL backups.

If a process isn't broken, what are we fixing?

The trouble is, oftentimes the decision to...

Paul Hayes-294329 (10/29/2009)

---

a resource semaphore wait type is typically waiting on a memory grant, check pending/outstanding memory grants in perfmon. That's normally because a query plan has compiled in a...

Here is an interesting link on a COMMVAULT bug:

http://www.siusic.com/wphchen/a-commvault-galaxy-qinetix-bug-experienced-in-restoring-sql-server-database-186.html

Thanks all for the lively debate, I have followed it with interest.

Well, here is the snippet of C# code I am going with; I'm parsing a (mostly NULL) table column...

Thanks guys, I will take a look at that thread.

Thanks, I will certainly take a close look; I just took a quick glance at your article, and it looks very interesting.

I...

Try this:

http://technet.microsoft.com/en-us/library/dd767418.aspx