Take the ID and @courseid values out of your insert statement. By having them there, you are attempting to give it specific values. Skip that value and start...

From reading the original post, I'm not seeing that the poster is using partioning.

If that is the case, I would suggest the following for a purely home-grown solution. I...

When you restore a database from 2005 into SQL 2008 R2, it should leave it in 2005 compatibility mode. As long as you leave it in 2005 compatibility mode,...

I have done some research on this very topic. Here are my views.

The other poster is correct in that they are for different things.

Column level encryption is...

One thing to keep in mind is that the account being used to run the job (the user the agent service is running under) has to have access to that...

Mine isn't nearly as fancy, and it sticks a dangling comma on the end, but when I just want a quick listing of all columns in a table (say, for...

One thing I always keep in mind (unfortunately, learned the hard way a few years ago): Never let your current employer dictate what you learn. One day you...

My guess, and it is only a guess at this point, since I have not done the research, would be that it only truncates from the log if it is...

Could it be the checkpoint process? It happens at what seems to be set intervals if traffic is steady. Also, what type of storage are you using? ...

I just read about this the other day. When a full backup is started, the current (at that time) LSN is noted. The backup is completed. It...