1
  • SQL View performance vs. SELECT

    I am experiencing slow views on my database. If I create a view and run it, then use the same select statement from the view and run. They both return the same data, but View runs slower. My expectations was that since views are compiled, they should run faster. Could some one clarify this for me....

    MHM2815 pointsBadges:
  • Crystal database expert not showing views for database

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? I can see views for other databases except this one.

    denise7525 pointsBadges:
  • Are parameters permitted on SQL Server 2000 views

    I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks

    CO Bill120 pointsBadges:
  • SQL Server Table and View Index

    Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

    Db23290 pointsBadges:
  • Copying view from remote to local SQL Server with SSMS

    Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using Export...

    Tsp196520 pointsBadges:
  • Comparing views, user-defined functions and stored procedures in SQL

    How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?

    SQL Server Ask the Experts2,585 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following