If you still want point in time recovery, then add a second maintenance routine that runs... I don't know, once an hour (seems like you don't have many transactions) that...

You can't create a view to a "dynamic source." You have to be able define a specific table or set of tables for a view. I'm not sure what you...

Since you're not doing anything with the log backups anyway, take the database out of full recovery. Just use Simple. That won't eliminate all log problems forever, but it'll certainly...

This is why I still like standard discussion style forums as opposed to Question/Answer forums like StackOverflow. Yeah, if you have a very clear and specific question and want a...

You have a very clear error:

It has to be something related to this issue.

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...