You have RECOVERY MODE in FULL and you are not doing a transaction log backup. Without doing some form of transaction log backup the tlog will grow indefinitely.

sudhakara (11/5/2013)

---

Hi,

I need to verify memory size of each NUMA node in the system. Please share me the method how to confirm that all the NUMA nodes are configured correctly....

bipan (11/5/2013)

---

Hi Experts,

We need to setup HA and DR solution in sql 2012 for Sharepoint.

what is the best practice for implementing this.

Should I have SQL clustering and High avaibilty groups...

I thought there was a way to install the tools for SQL Express... but maybe said tools don't include Profiler.

Ahh, I misread your initial post. I didn't note the PHYSICAL reads being different, just logical. I get the same output you do essentially.

I would chalk it up...

a simple Binoogle search for 'veeam and transaction log shipping' will reveal several relevant pages about the "Do not truncate logs" setting.

When I first read your post I was sure there would be some second query that was doing updates, which would cause extra IOs (in a manner of speaking) for...

I see no different on my laptop. sql2012 dev build 3349

Nice!! :w00t:

I suppose there are times to use SELECT * (other than in (NOT)...

T.Ashish (10/30/2013)

---

I have received this script for optimization.

I really have no clue on how can we optimize an INSERT statement, So I thought it would be good to share the...

thisted (10/29/2013)

---

So, possible solutions. I identified an index That is on the table, but isn't being used that I plan to remove. I also am looking...

layakali.sql (10/29/2013)

---

We are gearing up to deploy SP 2013 on SQL 2012. As HA/DR is required, we are looking at Synchronous DB mirroring and log shipping on a physical database...

A SELECT statement requests a lock on one or more items, just like an UPDATE/DELETE/INSERT does. It is a SHARED type of lock, but a lock nonetheless. So...

I think the testing done here test situations that actually aren't very helpful/useful. If you know you want to do JUST one of the other then do just what...

As long as the boot partition is on a mirrored RAID1 you can leave master/msdb/model there.

The biggest issue I see with your construct is that you have backups...