Viewing 15 posts - 2,326 through 2,340 (of 5,841 total)
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.
November 5, 2013 at 6:45 pm
sudhakara (11/5/2013)
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....
November 5, 2013 at 4:06 pm
bipan (11/5/2013)
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...
November 5, 2013 at 12:42 pm
I thought there was a way to install the tools for SQL Express... but maybe said tools don't include Profiler.
November 5, 2013 at 5:05 am
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...
November 4, 2013 at 2:36 pm
a simple Binoogle search for 'veeam and transaction log shipping' will reveal several relevant pages about the "Do not truncate logs" setting.
November 4, 2013 at 1:28 pm
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...
November 4, 2013 at 1:26 pm
I see no different on my laptop. sql2012 dev build 3349
November 4, 2013 at 5:30 am
Grant Fritchey (10/30/2013)
Right with you til #5 Kevin. NEVER use ALWAYS and ALWAYS avoid NEVER. 😛
Nice!! :w00t:
I suppose there are times to use SELECT * (other than in (NOT)...
October 30, 2013 at 1:52 pm
T.Ashish (10/30/2013)
I really have no clue on how can we optimize an INSERT statement, So I thought it would be good to share the...
October 30, 2013 at 5:24 am
thisted (10/29/2013)
October 30, 2013 at 4:12 am
layakali.sql (10/29/2013)
October 30, 2013 at 4:07 am
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...
October 29, 2013 at 3:29 pm
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...
October 28, 2013 at 3:15 am
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...
October 28, 2013 at 2:49 am
Viewing 15 posts - 2,326 through 2,340 (of 5,841 total)