Viewing 15 posts - 1 through 15 (of 79 total)
Looks like you are having some fun here 🙂
June 21, 2011 at 10:09 am
Yes, you can add 2 or more log files to a database without loosing log shipping and mirroring but my question to you is why? There isn't any gain...
April 4, 2011 at 11:28 pm
Let me first ask this. Have you enabled the TF 845 for the SQL Server 2008 R2 Std edition instances as well to use the Locked Pages in memory for...
March 14, 2011 at 10:06 am
I think we have identified the problem. SQL Server is memory hungry beast and doesn't play nice when you have 2 instances competing for memory if you don't set the...
March 14, 2011 at 8:27 am
Can you share some information if the box is stand alone or a VM? SELECT @@VERSION would help.
Do you use OPENXML, extented procedures, sp_OA* etc in your environment? Have you...
March 13, 2011 at 4:22 am
I agree with you that relying on memory and commenting on the post is NOT only difficult but extremely prone to errors. To go back to the actual question,...
August 27, 2010 at 11:14 pm
I would rebuild certain tables on certain nights and have a rebuild job running nightly.
TableA - monday night
July 27, 2010 at 9:30 am
Few random thoughts.
Faster tempDB potentially RAID10, more RAM.
Or take the overhead of creating a custom partition in the old fashioned way using multiple tables and a view with a...
July 25, 2010 at 1:07 am
Brian Huse (7/23/2010)
SET @ExecStr = 'DBCC INPUTBUFFER(' + STR(@@SPID) + ')'
INSERT INTO #inputbuffer
SET @Qry = (SELECT EventInfo FROM #inputbuffer)
which works, but requires everyone...
July 24, 2010 at 8:37 pm
July 22, 2010 at 8:18 am
In this post, I have listed the query as well as all the events traced in the default trace. Basically the default trace id is 1 NOT 0.
July 21, 2010 at 10:52 pm
Your best bet is to use Event Notifications and look for the specific events you are interested in.
Jonathan Kehayias has done a very good write up on Event Notifications...
July 21, 2010 at 5:31 pm
And in addition, that isn't going to solve the core issue which is that the memory utilization is too high. He'll just slam against 4 GB instead of...
July 21, 2010 at 11:44 am
July 21, 2010 at 11:38 am
July 20, 2010 at 9:24 pm