You need to create a login on the SQL Server instance, meaning go to the security tab in SSMS and then logins. Grant access to Windows accounts or set up...

I don't think there is a step by step for completely cloning a server. For a database, typcially you would restore a backup and then fix the logins/users. You can...

mirroring was not supported in the RTM version. You must have at least SP1 to use and it works great, though it has limitations.

The snapshot on mirror works well, but...

1 - as often as you can, NEVER auto repair.

2 - I'd set up a job to check fragmentation and automatically fix those tables when they get too high. High...

What does the purging job do? Is is one transaction or multiples? Many tables? Some larger? There might be an issue related to scale here. I'd actually profile where in...

I think I might want to go work with the major if I look for a new job. Maybe convince them to open up a branch in the US 🙂

I've...

Or use a DDL trigger

I think any of them will work well. Hyperbac is interesting in that the developers originally wrote Litespeed and this is an evolution for them in terms of lessons learned...

If you plan on lots of VM work, get an external USB drive. Makes a big difference with performance.

Where did you get this value? If you run something like sp_configure, you'll see the configured value in the third column, meaning someone has changed it. by default, I think...

You can run VFP against SQL. I built an app years ago, 96-97 timeframe, and it was way ahead of VB in it's OOP capabilities.

These days I'd be more...

First you need to post in the appropriate place. Are you having trouble with the SQL or something else?

Second, you haven't described what is wrong, what you've done, or...

You need to post in the appropriate forums for your question. I've moved this to T-SQL, 2005, but if it's not the right place, please let me know.

Someone came up with this forumla for displaying things based on rating, views, age, etc., to try and show the most popular.

It doesn't work.

We're going back to reverse chronology here...

Are they correct on the server or your workstation?

It needs to be on the server.