TheSQLGuru (3/23/2012)

---

opc.three (3/22/2012)

---

The SSMS Tools Pack has a built-in feature to help you generate INSERT statements from a table, or even from a specific query...very handy.

SSMS Tools Pack > Generate...

So I just ran a bunch of queries to warm up the buffer pool and got the committed memory up to 2.44GB with "AWE on, 3GB off"

physical mem, VAS, buffer...

For the server now using "AWE on, 3GB on" I never tested "AWE on, 3GB off" but I just found a good dev-server that is a candidate for this treatment....

george sibbald (3/23/2012)

---

sorry opc.three I am still not convinced on this use of AWE with 4Gb or less of physical memory and 32 bit, I have not seen any evidence...

Mhlewis (3/23/2012)

---

I was told by our sysadmin that 32 bit SQL on 64 bit OS was not an option, also the small amount of research I did on that indicated...

Jeffrey Williams 3188 (3/23/2012)

---

You can get this information from the backupset and backupmediafamily tables in msdb. You will also need to rename the files using WITH MOVE if you...

Jeffrey Williams 3188 (3/23/2012)

---

opc.three (3/23/2012)

---

Your readings are completely normal. SQL Server will claim as much memory as you allow it provided it thinks its needs it to efficiently serve data...

Mhlewis (3/23/2012)

---

I am being required to upgrade one of our installations of 32 bit SQL Server 2008 R2 to 64 bit as the server that the instance resides on is...

Your readings are completely normal. SQL Server will claim as much memory as you allow it provided it thinks its needs it to efficiently serve data to clients. 1.6GB is...

Lynn Pettis (3/23/2012)

---

As soon as I saw DB Mirroring, it makes sense. With that I would also assume that t-log backups are run periodically or after each load to...

Lynn Pettis (3/23/2012)

---

opc.three (3/23/2012)

---

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full...

Is xp_CmdShell enabled on your instance? If so, then you can issue a DOS DIR command on your backup directory and capture the results to a table, and then pick...

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full recovery mode. Procs...

Anytime! While I could not provide an easy path or complete solution, I am happy to assist 🙂

If you do not mind, if you decide to implement something, whether it...

See the section titled TempDB Temporary Tables in SQL Server[/url]