Door

replaced my garage door opener this weekend. And it works!

I pinged a few people for you, and edited to remove your phone number. Not a great idea to post that publicly.

First, it depends on how you have connections. Most applications make a connection, run a query(ies) and then disconnect. Through web pages, typically you have many more people on the...

The system databases are:

master, model, msdb, tempdb, ReportServer, ReportServerDB

You can identify them with an IN clause

...WHERE name not in ('master', 'model', 'msdb', 'tempdb', 'ReportServer', 'ReportServerDB')

Mirroring doesn't affect the log, with the exception that the log is needed to send the data to the mirror database.

If you don't need full recovery mode, why not just...

There isn't a good way. Since the user can change the name in the connection string of the application, there is nothing you can do here to prevent it. What...

Doh! Build lists is correct. It's fixed.

Great job and this is a reference I'll keep around.

What are you trying to accomplish here? The rights a login has do not change based on the application. That's fundamentally different than how SQL Server as a platform is...

You are getting an implicit conversion, expecting SQL Server to convert those integer values for you. As Jeff mentioned, you want to use quotes around dates to explicitly state the...

I think the message is that those that write software need to be able to concentrate without interruptions or distractions. The loss of productivity is a cost that could be...

Craig Farrell (12/5/2010)

---

Dev boxes need to be older hardware. Yes, I said it. It needs to be on a computer with enough processor to try to parallel, not...

The names of the groups do not matter. They will not be changed automatically, but you can change them if you like.

As Gail mentioned, you really need to restore from backup. At the very least, you'd need a backup to tell you what rows are gone. In this case, I would...

Just about to put an SSD in my laptop for VMs and I will be interested to see how it helps.

I think SSDs have a place for some operations, but...