Read the description of a seek. It's basically the same as a scan. But in this case, it thinks it can seek a limited range but ends up seeking on...

Take a look at extended events. You can capture the login event and then add the nt_username global field. There's also a session_nt_username as well as a username global field....

There's a nice introduction to it[/url] over on Simple Talk.

SQL Server 2014 has updateable columnstore indexes.

None of those is anything to do with a server's overall health. SQL Server doesn't really have such a thing built in. But, the closest you can get to it...

Yay! Books Online!

I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while I get things...

The system_health extended events session that runs by default captures deadlocks. You can see the full deadlock graph there.

OK. That was just 2014 acting cute. I did get two different plans in 2012.

To understand the differences, look to the properties. I have both plans using an Index...

Unfortunately, I just tested it on my machine and got identical execution plans for the two queries, which is what I expected. I'm going to go and try a couple...

So that still breaks down the same way. A class will have a relationship with multiple students. And a student will have a relationship with multiple classes. So, the way...

Sigerson (12/18/2013)

---

Grant,

Yes it was homework, but I thank you for taking your time to craft such a gracious (and clear!) answer. Some posters here scorn helping students and I've...

I'm with Gail. It sounds like statistics to me.

You may also want to take a look at Extended Events within SQL Server. You can set them up to capture all the queries that are run against the system....

Yeah, it sounds like the account that it's running under doesn't have access. Validate which account is running Agent. Make sure it's an account with access to your network and...

Unless you need to learn hybrid environments, I wouldn't bother setting up a system at home any more. Do you have access to an MSDN license through work? If so,...