Heres the explanation given by my technical lead to the client for using views for reporting purposes while justifying no performance impact to App users accessing the base tables:

"Yes,...

People having a good laugh at my cost! +1 to that.

Jokes apart, sometimes in an organization, one has to go by what his superiors think is the correct way to...

Guys, thanks for your inputs. I have created the below script which serves my purpose for now.

Cheers!

SELECT 'CREATE VIEW ' + TABLE_SCHEMA + '.vw_' + TABLE_NAME + ' AS SELECT...

Point Taken.

However I still need a script for creating a view corresponding to each user table in the database.

Thanks

Yes I know it seems silly to do this. But we have security reasons also for doing this. Besides this practice is common in data warehouse environments where reporting users...

Can somebody share the script required to pull the information I need from the Active directory?

Thanks

I agree that its not right to say that Oracle is better than SQL.

However what I was trying to say is that SQL architecture is so interpolated with the Windows...

I agree with you.The entire SQL Server design is very OS-specific and this seems to have been more intentional and motivated by business purposes rather than optimization.

Guys,any basic ideas will do,I just need some pointers.

Thanks

Can you guys elaborate on how the pdf and doc data can be directly redirected to a simple web browser(via HTTP endpoint probably) where it can be directly downloaded by...

Any suggestions guys??

Thanks.

What are the appropraite counters which can be used from inside SQL Server for monitoring memory usage withing 2GB,which can tell me whether the allocated 2 GB max memory is...

This is a 32-bit Windows 2003 Enterprise server having 4GB RAM.Earlier we had enabled the /3GB switch on it to allow user processes including SQL to consume upto 3GB memory.But...

Any thoughts on this guys?

Thats right.I have a Standard ed 32 bit 2 node cluster,where i have each node running one active instance.In case Node A fails,Node B will have 2 active instances running...