Hi:

I've done this before to migrate users off of 2005 to 2008. The environments can co-exist and I believe the second installation has to be named. I hope...

Hello there:

Depending on the complexity of the database, you may consider drafting an SSIS package to update the tables that contain new information.

I've gone down the path of using Agent...

Hi:

It may also be worth investigating if you A) have 64 GB presented to the OS and a different OS version or B) have 32 GB presented, the OS mentioned...

My advice kind of takes it "from the top."

It sounds like you have a unidirectional firewall rule. Try a simple telnet to the port that SQL is supposedly listening...

Cool - best of luck to ya'!

---FR

Hi:

I'm not an expert with this, but I think the first step here would be to identify what is the user doing to update the...

Hi:

Not sure if this server is in production, but if not maybe you can rule out or focus in on the firewall by disabling it and attempting to connect?

If it's...

Try jumpstarttv dot com - I've viewed some of their videos and they're interesting. I hope linking to other sites doesn't get me dinged. :unsure:

Hmm... I think the number you're looking for will be based on the SLA / user experience you're bound to deliver. I also think that the exact number...

Consider looking at the following:

page life expectancy - (I think 5 mins is the MS best practice) this will tell you how long data pages are living in memory

buffer cache...

Hey All,

Here's are some scripts that I've used a couple of times in our environment. They work well if a script or many scripts...