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.

david.irvine 7489 (5/13/2014)

---

Does no-one else use the options setting 'Dispaly results in a separate tab'? You see a complete pane of results automatically when the query has run, then...

call.copse (5/13/2014)

---

I do think there should be a safe environment where students can learn the theory without being overly concerned about practicalities - this could be the first year of...

I've run into a few people using this, and Filestream. For Filestream it's mostly been .NET programmers that write thick apps and want drag/drop, easy storage of lots of images.

For...

I'll be there. Heading over from Cambridge sometime Thursday, but there until Sat afternoon.

I'll be the guy in the bright shirt 🙂

Note: Moved new forum

Once you complete the install, you can search the entire system for the most recent modified files. There is a setup log you can review to see what happened.

I tried...