any...

It should. I don't have an instance handy to test it on right now, but it has worked for...

I'll award back points. I tested this at one point, but in writing the question, I was looking at the documentation.

To the further discussion of upgrading the database: sure, ideally...

Please vote...

I'm looking for a basic, introductory article that gets people to change simple settings. I would guess it's 2-3 pages without screen shots at the most. Feel free to post...

I used to have four. However on the standing desk, I found myself looking down more than I'd like at the lower two.

One of the lower ones died, and that...

A few of the Red Gate devs do this. I haven't...

I don't know that you can do this. Perhaps an APPLY can run multiple OpenRowset commands in a single query, but I don't think your use case is one I've...

You can leave them at SQL 2008 R2. Set the compatibility mode down level (< 120). If you are lower than 120, the cardinality estimator remains the same as previous...

We've used Ola Hallengren's maintenance script or @SQLFool's script here. You might try theirs on your system and see if it works faster.

Ola: http://www.sqlservercentral.com/scripts/Backup/62380/

@sqlfool: http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Never seen that working, so kudos for making it work. Most people move to SSDT and DB projects or they can use Red Gate's SQL Source Control to integrate.

Disclosure: I...

vliet (5/14/2014)

---

It depends on the exact profession but in my opinion nothing can replace a solid theoretical background. Especially with databases, because thinking in sets instead of records requires a...

call.copse (5/14/2014)

---

Having worked with a fair variety of programming types I can say weeding is a good plan - unfortunately there are not enough programmers with the right skills here...

Set the example, give the advice, second a suggestion, but don't beat people over the head. Not everyone is ready to hear, or heed, the advice right away.

It takes time.

http://www.sqlservercentral.com/Forums/Topic1164933-391-1.aspx

Chances are that something on your client system is out of date with what's stored on the server. Make sure your client is updated.