Back from SQLSaturday #14 in Pensacola, what did I mess?

Thanks and I appreciate the support.

I do appreciate the criticism as well. It helps me learn, but public degradation isn't a great way to do it. A private message or...

Some of it is new ideas and research. I'm sure Microsoft Research falls under here. Do we get products out of there? I think Surface came out of there, but...

I have removed the attachment.

Please edit the data to be samples only, and upload in a new post along with an idea of how you want this data to appear...

Chris,

I tend to agree with you. Most IT groups don't want to upgrade servers often. But they will look to new versions, and I think it's a good idea to...

The ADO interfaces should be backwards compatible, but you need to test. You cannot do this migration without testing your specific application against a 2008 server.

It depends on the OS and edition since those have limits. If they listed each one, then it would be a much more confusing chart.

Web reference: CPU and memory

I agree with Jack's list.

ALTER INDEX is typically the first one, DBCC the second. The maintenance plans list these if you walk through the options, it will somewhat explain what...

Don't grant users any rights.

Create a role(s), and then add users to the role(s). Grant EXECUTE on the stored procedures to the roles. That's it.

You do not need the views...

CONTROL allows you to change things. http://msdn.microsoft.com/en-us/library/ms187940.aspx, CONTROL almost makes the like an owner.

No one gets permission by default. You do not need to check DENY, unless the user is...

Yes.

As you restart SQL Server, errorlog becomes errorlog.1, .1 becomes .2, etc. and a new errorlog starts.

Same for agent.

I agree with Gus that you don't want to be moving the size around. Why were you shrinking it? Is 100GB too large?

Look at your log backups, find the largest...

You might have VLFs (virtual log files) that prevent shrinking at times. There's a Forcibly Shrink the Transaction Log script on this site that can help.

HOWEVER, you should not be...

Chris,

It's a balance and I'm not sure how to address it. Microsoft doesn't expect, in my mind, everyone to upgrade to the next release. What they likely think is they...

DB2 has come a long way, and in many ways Oracle has as well. However I know plenty of DB2 and Oracle installations that heavily depend on command line work,...