Viewing 15 posts - 2,326 through 2,340 (of 5,843 total)
shahgols (11/7/2013)
I have a query that calls on a UDF. In staging, has the same number of records and schema, it runs in 25 seconds. On...
November 7, 2013 at 4:09 pm
eyespi20 (11/6/2013)
SELECT node_id, node_state_desc, memory_node_id, online_scheduler_count,active_worker_count, avg_load_balance
FROM sys.dm_os_nodes WITH (NOLOCK)
WHERE node_state_desc <> N'ONLINE DAC' OPTION (RECOMPILE);
What information does this give...
November 6, 2013 at 10:28 am
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
Viewing 15 posts - 2,326 through 2,340 (of 5,843 total)