Viewing 15 posts - 23,236 through 23,250 (of 39,819 total)
Do you know what horizontal partitioning is? This sounds like an interview question. If you give us some thoughts, or what you think (or don't understand), we can help. It's...
July 6, 2009 at 8:19 am
Bi-directional is a type of transactional replication. Do some research on that. You can use merge, which gives you more control over collisions, but also it is more complex.
Snapshot will...
July 6, 2009 at 8:18 am
I think it's good to get away and recharge. Not sure about 4 weeks, but perhaps that's cultural. It's been a long time since I've taken this much time away,...
July 6, 2009 at 8:13 am
You should hire a consultant. If you are not aware of whether it's possible to upgrade, you likely do not have enough knowledge to do this. Hire someone, learn from...
July 6, 2009 at 8:11 am
You have to link the job to other servers (linked servers), or set it to run on all server instances. There is no linkage between instances to automatically determine what...
July 6, 2009 at 8:10 am
The SID shouldn't matter. You can map the login to the user.
July 6, 2009 at 8:07 am
Can be either one, but typically it's an admin that has rights to do this, not necessarily the DBA.
MCSE isn't a job, it's a certification, by the way.
July 6, 2009 at 8:05 am
You can use CPU time, but if you're looking for overall time, you need duration.
July 6, 2009 at 8:03 am
I like George's first suggestion. Go in chunks, use shrinkfile.
July 6, 2009 at 7:56 am
Also, you should not be shrinking the log regularly. If they need that much space, then they need it. Log shipping results in regular log backups, that allow space to...
July 6, 2009 at 7:54 am
If you need to restore a database from 2005 to 2000, no matter what the compatability, you can only script out objects and permissions, and run that on 2000. There...
July 6, 2009 at 7:51 am
I'm not sure there's a reason to pick one over the other for simple tests, but as you get into queries, testing for equality can be more efficient. People often...
July 6, 2009 at 7:47 am
Usually there are some ports that are "listening", look for those.
SQL Server prints this in the error log as well when it starts, so you can always check there. The...
July 6, 2009 at 7:43 am
Wayne,
Sorry, I need to update the IFCode, and I'll do that tomorrow. The code formatting has been a challenge, and it's confusing to everyone. I wish there were a better...
July 5, 2009 at 9:44 pm
Viewing 15 posts - 23,236 through 23,250 (of 39,819 total)