GilaMonster is correct--it's fairly trivial to set up a SQL script that can be called via SQLCMD in a scheduled task to do backups. We have a SQL Express install...

I would have thought that even 3-4 year old hardware...

I would maybe look at upgrading the network to 1Gpbs throughout. 100Mbps may seem plenty fast enough, but running absolutely flat out it will take more than four hours to...

I agree with SQLKiwi. One of the important things about the 64-bit version of SQL server is that it's entirely compatible with the 32-bit version, even down to the data...

pavanr (12/21/2010)

---

I agree that without an ORDER BY clause, the returned result has no meaning.

but can anyone explain, here in the case of Clustered Index, why it picks third record...

Out of interest, how fast is the network connection between these two servers? You don't specify.

I was expecting the answer to be something along the lines of things are always returned in the clustered index order (which would obviously raise questions in any case), but...

I wonder just how many SQL Server Express installations there are out there doing major workloads--that's 32-bit only (and limited to 1Gb of RAM to boot)! So long as the...

I'm curious--what would you class as a "sensible way"? I've often copied...

Ninja's_RGR'us (12/16/2010)

---

You can download sql express and install it on your pc. That's always a good start. If that's a no go because the DB is over 4 GB,...

I think SQL Management Studio is actually under-appreciated. I was just having to do some work on a client's SQL 2000 install, and I'd forgotten what a pain it is...

I'm unclear on what you're asking. If you're basically saying that you need to get Performance Monitor information from a time when you weren't actually running Performance Monitor, then it...

Can I just point out that the code is not SQL 2000 compatible, despite what it says at the top, because of the use of ROW_NUMBER()?

In point of fact you can use either the 32-bit or 64-bit version when you buy a SQL server license (so long as you don't use both at the same...

The reason your developers want you to do this is most likely because they have a service running on the other machine as Local System (or Network Service) and want...