We republish popular articles periodically. It gives new people to the site a chance to catch them.

int.

Save space, makes more sense.

A phone number isn't really a number. It's a string of numerical characters.

A PK is a the way of uniquely indentifying each row within a table. It is implemented in SQL Server by means of a unique index. This can be clustered...

The two posters above are what I understand.

Please post an update if you figure something out as this would be a major bug to know about.

I'd follow Sugesh' advice, but also perhaps connect with SSMS and run the same query outside of the stored procedure when it's slow and grab the execution plan. This will...

Are these separate jobs in SQL Server or separate jobs in Windows scheduler?

Separate jobs ignore one another. If there are two steps, they go in order, not according to separate...

Thanks for the update.

I've seen this in a few places, usually when we've changed service accounts. SETSPN has worked at times and not others, so I think this is a...

This isn't transferring objects, it's trying to clear out all data, but you have FK references to/from another table, so you cannot do this.

Can you explain more about the table...

I agree with the call PSS advice. If it's not something simple like space, which it doesn't look like.

Might try shutting down SQL and defragging the OS drive as well....

Also might appear in My Computer, right click, Manage.

What do you mean? Through a linked server?

Actually I think the purpose of universities is to help you learn how to learn. And get credentialed, which shows you can stick to something for a decent length of...

They might be. You definitely should be aware of how to handle situations in SSMS. Not everything is clickable, so that will help you eliminate some steps, but you want...

The Honor Code at Virginia was under debate when I was there and still is. If you were suspected of cheating somehow, then an Honor Court was convened, consisting of...

Very interesting comments and thanks for the debate.

I'll say that I'm not perfect. I've sped before and made minor transgressions of the law. I guess I wouldn't count those as...