Viewing 15 posts - 24,136 through 24,150 (of 39,818 total)
DB2008 is correct.
You can set the ports in the Configuration Manager, or you can let SQL dynamically manage ports for named instances. The default is 1434 for the default instance,...
April 27, 2009 at 1:56 pm
Ideally you'd do this with a separate server, and test it completely to be sure it's working. A virtual server is a great place to do this.
April 27, 2009 at 1:54 pm
Most of the systems I've run were rebooted less than once a quarter, some once a year without issues.
April 27, 2009 at 1:49 pm
http://msdn.microsoft.com/en-us/library/ms181671.aspx
This doesn't make it fast, it rebuilds indexes.
If you don't have it properly indexed, it won't help.
April 27, 2009 at 1:48 pm
Most security products I know are looking for tens of thousands of dollars. A little outrageous from my perspective because the risk isn't high to most people.
April 27, 2009 at 1:46 pm
Prometric and Vue are the testing places.
I'm not sure of the status of the 2008 exams. They are really new, so they might not be distributed everywhere, or on the...
April 27, 2009 at 1:45 pm
Is your tempdb one data file? Just tempdb.mdf?
What was the result of the shrinkfile on this file?
April 27, 2009 at 1:44 pm
For statistics, http://msdn.microsoft.com/en-us/library/ms187348.aspx
You can do a specific table or index.
For the MDOP, what do you mean 8 servers?
April 27, 2009 at 1:41 pm
You also don't necessarily need to worry about locking. SQL Server handles most of that.
It would help if you specifically noted what you are trying to achieve. You may be...
April 27, 2009 at 12:43 pm
Licensing is a pain, and it's hard. Good to see that Bob is building a better license, working with customers. I'd like to see more of that with vendors, and...
April 27, 2009 at 12:40 pm
I don't think you can even install with the same named instance if one is down and the other running. I think you need a unique name at all times.
April 27, 2009 at 12:39 pm
Not sure how long we've been able to export to PDF from ER/Studio, but I don't think it worked well in the 99/'00 timeframe. The other issue is that you...
April 27, 2009 at 12:25 pm
A regression test is a retest of your code. So you set up tests to determine if it is functioning properly.
As you make changes, add new modules, etc., you...
April 27, 2009 at 11:00 am
What do you mean by streamling? Is this performance or process based?
April 27, 2009 at 10:51 am
Viewing 15 posts - 24,136 through 24,150 (of 39,818 total)