If the default behavior of dbcc shrinkdatabase was the truncate_only option wouldn't it stay the same? That's what my...

We actually just created a BI Director position with a team under him. I'm looking forward to see what they'll be doing.

Any time you see checkboxes...

Heaps are interesting. I've had Microsoft techs say they're coding mainly with clustered indexes in mind so we're likely to see more things like this with heaps.

majorbloodnock (8/9/2011)

---

Another thought. You're suggesting that the US require that chip manufacturers divulge their plans and plants to the government. What if they don't? Would they be shut down? If...

Not only that...

majorbloodnock (8/8/2011)

---

It's also true that developing new technology is expensive, and any company indulging in these kinds of underhand activities is gambling their whole investment; if they're found to be...

Two ways to go about this. One is to set "on delete cascade" on the foreign key. That will make it so when you delete the state anything...

I had actually gotten a Team Lead position at one point which I really enjoyed. It was assigning tickets to individual team members and helping them through them. ...

If you have both files you can right click on database, select Attach, and then select the files you want to attach. If you don't have the data file,...

In general I'm not a fan of this idea but depending on how...

Indeed. But if the DDL can't be modified...

Chances are you're doing an implicit conversion. Make it an explicit conversion taking the column that's an int and make it a varchar. If you need more help...

I haven't tried it but most of the binaries are stored separately and the shared ones should be marked as in use by another program so it should work fine....

sjimmo (8/2/2011)

---

Good question, but the answer does not match the question. The question does not ask about whether the command is being depricated. The answer is actually in the link...