Viewing 15 posts - 601 through 615 (of 1,271 total)
In addition to the advice above, if you plan to do this on a regular basis, you should familiarize yourself with bcp (bulk copy program). It is a command line...
May 4, 2009 at 12:18 am
All forms of high availability allow schema changes. The only option that has any sort of limitation on schema changes is replication.
May 4, 2009 at 12:13 am
I have to second Alex's suggestion. I don't think I have met anyone that knows more about failover clustering than Allan Hirt. He is currently writing a book on failover...
May 4, 2009 at 12:10 am
Greg Roberts (4/28/2009)
Every once in a while I have a serious brain fade and need the good old smack upside the head to reboot. 😀
We've all been there and done...
April 28, 2009 at 11:22 am
Actually, I am not in favor of outsourcing. But there are good and bad coders both in and out of the USA.
Quality should be the top priority of any company,...
April 23, 2009 at 11:28 am
How many instances are on your mirror/witness server? Did you make sure that there are no instances using the witness port already?
Also check your hosts file on both machines and...
April 23, 2009 at 10:48 am
Jeff Moden (4/23/2009)
Heh... there's some extremely talented folks right here in the U.S.A....
Wow, you took a function I wrote more than 4 years ago and sped it up so that...
April 23, 2009 at 10:24 am
I don't know anything about the economics or the politics of outsourcing, but I do know that I currently work with some extremely talented people in India and China and...
April 22, 2009 at 10:47 pm
On the other hand, it does make me want to come check out your company's website. 🙂
Oh, and one more thing: There is no "i" in team, but there is...
April 22, 2009 at 10:41 pm
Can you script out your endpoints so we can see how they are configured?
Are you using the wizard or setting it up manualy with T-SQL?
If there are other instances on...
April 22, 2009 at 10:32 pm
Yes, they are out there. BI seems to be a booming area right now with a real lack of talent to fill the spots. At least that's how it looks...
April 22, 2009 at 2:53 pm
By changing the authentication method from Windows Authentication to storing the credentials of the account to use. If you use Windows Authentication, then everyone you want to be able to...
April 21, 2009 at 1:24 pm
These days, the SQL jobs seem to split into 4 groups.
1. Administration: also called a production DBA
2. Development
3. Business Intelligence and Data Warehousing
4. Generalist: Two or more of the above
A...
April 20, 2009 at 11:51 am
Adi is correct. the RTM build is 1600. There is no workaround. You must upgrade the other server to at least the RTM version.
April 20, 2009 at 11:41 am
If you don't have experience on the platform, you will have a difficult time with the tests. You really should do the SQL 2005 certification.
This site will help guide you...
April 17, 2009 at 10:32 am
Viewing 15 posts - 601 through 615 (of 1,271 total)