Viewing 15 posts - 33,196 through 33,210 (of 39,739 total)
Based on BOL, you DO NOT set working set size when SQL is dynamically managing memory. BOL doesn't seem to detail much on this, but this (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx) says to set...
March 28, 2006 at 7:56 am
If you client alias, be sure you specify a server port setting and not use dynamic ports.
I know you said the port was open, be sure it's open on the...
March 28, 2006 at 7:47 am
John has the right idea. I'd guess security or an invalid path. The SQL or Windows error log should show this.
March 28, 2006 at 7:47 am
Gordon,
There could be good reasons to limit your access. Not that I'd like it either, but you should work within your limits. If you need a test restore, then note...
March 28, 2006 at 7:42 am
Virus scanner is key. That can severely affect performance. Might also want to check and drop all indexes and recreate from scratch.
On the parallelism thing, you can restrict an individual...
March 27, 2006 at 2:06 pm
Innovartis has dbGhost to help with this and a few articles as well as one I'm expecting to get sent here any day.
March 27, 2006 at 2:01 pm
Can UDP 1434 get to the server? When you hit a server, this port allows the SQL browser to send back the port required for connection. Check for a server...
March 27, 2006 at 2:00 pm
Eric,
A few things to consider, and it would be great if you could test a few things. First, if your logs will survive on 1 disk, then use a RAID...
March 27, 2006 at 1:58 pm
I used to setup a separate admin database on each server. Use scripts to grab the size of each database, and you can find a few on this site.
Then use...
March 27, 2006 at 1:09 pm
Glad you liked it. We'll be looking for you soon as a contestent after the online challenge !
March 27, 2006 at 1:08 pm
fyi, before too much complaining:
http://www.kbalertz.com/Feedback_913090.aspx
After that, send the complaints to MS.
March 24, 2006 at 8:58 am
They also say the difference between a stored procedure and a trigger is the sproc is executed client side and the trigger server side.
http://www.dotnetspider.com/exams/ShowExamQuestion.aspx?ExamQuestionId=2325
It's statement level recompile. A CTE doesn't...
March 24, 2006 at 7:44 am
Why an inner cursor? Can't you just get the data and append it to a table or variable?
March 24, 2006 at 7:39 am
Believe it or not, I do have a few friends. Or maybe it's just people that owe me for doing something ![]()
I don't...
March 23, 2006 at 11:33 am
Valid points, but if each of these databases for small and simple (no mention given), they all theoretically can be consolidated onto one server. There is a compatability mode.
The advisor...
March 23, 2006 at 9:25 am
Viewing 15 posts - 33,196 through 33,210 (of 39,739 total)