Viewing 15 posts - 61 through 75 (of 151 total)
Check one other thing please for me - PageLifeExpectancy. It's also in the SQL Server Buffer manager, and is the "Number of seconds a page will stay in the buffer...
March 19, 2009 at 9:02 pm
I would use caution with Microsoft. I say this...I have three of them set up at home for testing and am seeing some good results. Microsoft hasn't completely reached maturity...
March 19, 2009 at 8:58 pm
Hey Jason:
Actually, that's a "best practice" that we used when I was at www.sqlrx.com, and it seemed to work well. It does make sense - if tempdb, in the unlikely...
March 19, 2009 at 8:54 pm
You know, there will probably be a better response, but I had this once and just went and created the proc for SQL Server.
March 19, 2009 at 7:30 pm
Look at some of the other counters for phys and logical disk before concluding that there is a problem. Go check the Avg. Disk Sec/Read, write, and transfer during production...
March 19, 2009 at 7:29 pm
1mdf, 7ndfs, 1 log. Size the mdf and 6ndf to not grow, and the 8th ndf to autogrow. However, make sure though that they are sized large enough so there...
March 19, 2009 at 7:26 pm
Check out a blog that I have on my site for doing this. You can use a cartesian product to create a list and plug zeros for values that have...
March 18, 2009 at 8:29 pm
ANSI NULL OF goes bye-bye in next release, by the way.
bye 🙂
March 18, 2009 at 7:47 pm
A SELECT isn't included as a distributed transaction unless you explicitly do a BEGIN TRAN; developers sometimes do to keep the current connection. A SELECT INTO is minimally logged, so...
March 18, 2009 at 4:50 pm
I recommend the Microsoft Upgrade Advisor and Scalability's Upgrade Assistant along with RML utilities for upgrades and migrations. Choose these to find what did or didn't get upgraded. I have...
March 18, 2009 at 4:48 pm
I can see where there is room for improvement in both; SQL Server doesn't capitalize as does Red Gate, and SQL Server doesn't have the nice DDL boxes that come...
March 14, 2009 at 6:41 am
Exactly neither do I. That's probably why he's having all of the difficulty
March 13, 2009 at 8:51 am
Just do what you are doing, but specify IP address rather than computer name. My blog has steps on how I set it up...have you checked it out?
Lee
March 13, 2009 at 5:27 am
I found that quite a bit did not run well in RTM; I wouldn't advise it.
March 12, 2009 at 8:45 am
No way to tell unless I get on the box. Try this to see if these steps help - sounds like you didnt' set up endpoints correctly.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=258365&SiteID=1
March 12, 2009 at 8:26 am
Viewing 15 posts - 61 through 75 (of 151 total)