Are you planning to share disk (that contain Log Files) with some other applications?...

It's not possible. You might be inserting in a table & fetching from another (it generally happens with default schema). Please verify it & if possible, provide us some data,...

You cannot restore the backup of a compressed database to an uncompressed database.

Few other restrictions:

•Compressed and uncompressed backups cannot co-exist in a media set.

•Previous versions of SQL Server...

Is it Power User or Admin?

The only other concern is the fact that a typical file size is around 60-80KB, and Microsoft reccomends using Filestream for files larger then 1MB.

So it may be better to...

You don’t need to. SQL Server Installer does it for you. What you need to have a Windows Account that can run Installer without any hiccups.

After a linked server is defined, to reference data objects in that linked server, you can use a four-part name in the form linked_server_name.catalog.schema.object_name in Transact-SQL statements.

The parts are...

It's good to start but there...

You are missing on ACLs (Access Control Lists).

Reviewing Access Control Lists Created for SQL Server Service Accounts

http://msdn.microsoft.com/en-us/library/ms143504.aspx#Review_NT_rights

In any cases I'd make him sign something that says I know this can return the wrong data and this is my decision. Takes you off the hook.

Make sure to...

I had one of those. I sat down with the architect and explained to him what NoLock actually did and what effects it could have. The standards document was updated...

It was a BUG in SS2K5 and MS claims it to be fixed. Time to re-open the defect I guess 😉

http://support.microsoft.com/kb/925001

As far as how to deal with it, find an example where that dirty read will cost the company money. Document thoroughly and show the boss. Then you've done your...

MyDoggieJessie (11/16/2011)

---

I think what DEV meant was he's a victim of inheriting the practice from others. I dont' think any one on this forum would say its usage is...

This is cross-question. This is what I suggested to Ashu. 😀

But what I am saying is a fact...