MiguelSQL (3/11/2011)

---

My windows ID is part of the Local Administrators Group

When I start the server in single mode, and I try to log in, I get the error:

Login Failed for...

Thanks for the question. And yes waiting until later in the day to answer the QotD does help. Thanks to everyone for debugging the question! 🙂

Interesting question.

Yes, you could use an SP, as long as the user doesn't need to be able to write adhoc queries against it. (Even then you could handle that through parameters,...

If what you are looking for is the requirements (CPU, memory, Disk I/O, etc.) that are needed to support 30 simultaneous user connections you would need more information about what...

Log shipping would be OK for transitioning, but isn't useful during a testing phase as you can't access the DB until you break the log shipping and upgrade it to...

Yes, if you can install a 2008 R2 instance side-by-side with a 2008 instance.

I quickly reviewed a bunch of stuff and have some notes, though I won't go into detail as I have limited time:

Review both instances for updating to the most current...

Nice question, thanks!

Though I probably would have asked about it in the BULK LOGGED recovery mode, as that would have made it more likely that a TRUNCATE TABLE might be...

TK-487581 (3/8/2011)

---

So, just confirming - Index is only for performance. It has no hand in sorting the data, right? I thought if the index is clustered, then it should bring...

Thanks for the question, I did have to go read in BOL to figure out how to answer it, so I learned something.

The "Select *" statement is what is contained in the view. Extract_Date is an Oracle DATE column, so it is similar to the SQL DATETIME data type.

OK, I figured it out, and it wasn't at all what I expected. Someone had changed the compatibility level on the Libraries DB to 100, while the EOracle DB still...

larry Hennig (3/4/2011)

---

HOW TO ELIMINATE THE NEED TO REBUILD THE MASTER DATABASE

I have not seen this idea offered by anyone else, so I am claiming credit for the algorithm. ...

I didn't rebuild the linked server, but I did change a parameter and then change it back, and I have re-created the view multiple times. (Trying OPENQUERY vs. four part...