Anonymous Post #2

Hi there.

I pretty much get 8 hours in per day. I think I work very efficiently. But I'm currently in a job where I can hide away in...

Interesting. I agree it's not the only metric. Effectiveness is ultimately what matters, but for planning, you need to guess at some xx amount of work and hours is one...

Are you moving to new places or to the same server over and over?

You only need to move logins once, and if you use the same SID, then you...

Just as a note, we usually have 2-3 free admissions to the conference we give away to authors each year.

Anyone that can cover travel/hotel and is interested, write me...

I've gone both ways, but I have tended to separate out the system databases to a separate job.

I'm with TheSQLGuru. I'd shut down SQL Server. If the files are being written to, it's possible that you are slowing things down or there could be an issue. There...

Usually the PK is a field that obviously identifies what's in the tables. Often there is an "ID" field with an identity or integer value in there. If you have...

Short answer: sql agent.

Are you running SSIS packages or are you trying to run SQL scripts from SSIS?

Yammer looks interesting, and thanks for pointing it out.

You definitely need downtime, but the thing to remember is that Twitter, alerts, Blackberry's aren't binary devices. It doesn't mean you are...

It's a problem with your tape drive, or the media. When you see "operating system error" it's something outside of SQL Server.

Backing up to tape is not recommended as the...

Just a chance to meet people from the site. We hire a casino company to cater the event, give away "chips" to play blackjack, poker, roulette, etc. for a couple...

You have some duplicate data in your join.

you could add distinct to the SELECT list, which would remove duplicates.

http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx

In standard.

It's nothing amazing. You could set it up yourself with a few jobs that backup, copy and restore.

It should be fine during normal workloads.

You can set up linked servers, which will be there and allow you to do updates. More admin work here.

you can set up an openquery/openrowset statement to do the work,...