I hope that Google isn't implying they are removing data and then keeping it. My guess is they remove the references from my account, but they keep some type of...

jcrawf02 (2/24/2010)

---

Steve, fyi, HIPAA does allow you to request your medical records from your physician, and although you can't remove information, you can set limits on who they're allowed to...

I think you're taking the right approach. Learn, work at it, ask questions. I've been thrown into similar situations, and there are tons of Windows admins here on the forums...

This was the case when I worked in a large (Fortune 1000) company. we had two accounts, and were restricted from doing things with our regular accounts. It's a pain,...

You ought to grow it every 3-4 months, calculating what you'll need beyond that.

In terms of maintenance, you likely need to do it during off hours. You could archive off...

And I found another great question today. Someone hadn't had an answer in a few days, so they edited and removed their question.

Grrrrrrrreeeeeaaaaaaattttttttttt

Most sources we use are paid for. There isn't a lot in the public domain. Posting a short excerpt from a book is no different than from a website. You...

The compatibility level has nothing to do with the structure of the file, or the way the backup is taken. It only determines how the 2005 engine interprets the code.

Once...

nope, you cannot restore downlevel.

Script out the schema, run on 2000. Use SSIS or the export wizard to move the data.

Barry, sourced, quoted, limited to < 1 para, fair use.

Run the upgrade advisor to see what pops up.

I would also run a profiler trace of a test upgrade and look for deprecated code. There's an event for that....

$25 from Amazon will cover this: http://www.amazon.com/Omaha-Steaks-Boneless-Pork-Chops/dp/B0017129DC/ref=sr_1_2?ie=UTF8&s=gourmet-food&qid=1266945895&sr=8-2

Sure you can run that query, but will you run it for every table adn every day? Or are you going to assume the growth that occurs today is representative?...

The solution or the contest? You can post on your blog later, enter the contest now.

Since this became a performance discussion, I added a question on ASK about the best method. I know someone might memorize this for an interview, but you could easily change...