Craig Farrell (5/3/2011)

---

Steve, I've found that 99% of servers have their USBs locked down at the server side, if you can even access the data-center these days as a...

Eric M Russell (5/3/2011)

---

It is possible for a database application (not using AI but just basic SQL ranking, fuzzy indexes, and reference tables) to return the correct result for the...

I probably do, but so the OP knows, plenty of queries on a normal system will spike at 100% CPU. That's not necessarily a problem.

Nothing is ever written to the backup file. It is read-only. The sparse files created will store any changes made.

The time to restore on a USB drive will vary (SB2, USB3 interface). eSata will be quicker, but it's time.

For Virtual Restore it's very quick. No data is copied and...

One thing to think about is keeping a 1TB USB drive around for times like this. Make the restore happen on that volume, then try to resize the database.

Another alternative...

Second vote for SQL in a nutshell for SQL.

If you want SQL Server, pick up any SQL Server 2008 admin book. They're all about 80% the same. Go through it...

Congrats, Gail. Well deserved, I'm sure. I missed it online, but I will try to make it live.

http://www.sqlskills.com/mcm.asp

This isn't really a good question. What are you trying to monitor? What type of replication? Have you set it up?

We are not here to provide you detailed plans for...

I can run one query on my desktop and use 100% CPU. that's how SQL Server is designed. If it can use the extra CPU to process the query quicker,...

There are a few things that will automatically go to disk with tempdb. After some checking, you cannot get away from spillage during queries. If a query is estimated to...

Fair enough. Getting SP dates is easy. CUs might be harder, but I'll look into adding them.

I'm not necessarily looking for validation here, but a way to capture and consider linking things together. I can foresee that someone says they work at Wal-Mart and the application...

Brandie Tarvin (5/2/2011)

---

GAH!

I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones at SSIS Guy for posting nothing but advertisements...