Just so you know, I've had about 6 or 7 interviews since SSC started (none in years) and I called this out in every one. I also used to answer...

The formatting is fixed, or should be. Please let me know if it is still messed up.

I have seen some strangeness with randomness in SQL Server, running the same query...

It's possible, as to how easy? no idea? The original developers of SSC v3 used a lot of nHibernate and generated stuff in places and apparently some things are hard.

I...

LOL, how did I typo that? Keys are on different sides of the keyboard, different hands, I must have been tired.

The majority of my thread notifications were from this thread...

You don't need to take log backups. That advice is misplaced.

I don't think this will occur with a diff, but it's possible if the diff is not related to the...

We have debated about some of the features in Stack Overflow here, especially as they've gained a lot of popularity. I'll post a few threads to get discussion from you,...

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