Fidelity happens to be in my neck of the woods, so I found this article very interesting and very sad. It disheartens me to know that the few bad DBA...

I'd like to know the answer to Jeff's question myself. Please don't take this the wrong way, because we're just trying to help. But you seem to be making an...

Norecovery isn't going to help you. It'll leave the db in the same state as it is now. "Restoring".

CirquedeSQLeil (5/1/2010)

---

Another problem with defining the join as such is the problem of a Cartesian product. Explicitly telling the system to use an Inner join and which fields to...

And what has this...

Glad I could help. Sounds like you're on the right track for your job.

RapidShare and BitTorrent aren't about compressing the file. They're about passing files over the Internet in smaller bits and pieces so it doesn't necessarily take so long to get the...

Broken ownership chains can also cause security problems.

The websites are restricted from my workplace (I can't see them). But go to RapidShare.com and see if it has any information on private implementation. I know a couple of...

What you need is software similar to Bit Torrent or RapidShare without the file share being publically available for just anyone.

Cory,

Who told you that you could be logical about the questions answered on the forum???

@=)

Honestly, that possibility didn't occur to me. Retaining old data but forcing new data to be...

Then the answer is "Yes, he should be able to see the view" with a caveat. He MUST be granted SELECT permissions on the View itself. Otherwise, it will fail.

I...

Litespeed has adjustable compression. It can go pretty small.

Third party tools such as Litespeed can do it for SQL 2005.

manoj2001 (7/9/2009)

---

But if i am not wrong we could add instances in SQL Server 2000, by right clicking

enterprise manager and create and register new instance by giving name of the...