One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?
2008-12-12
3,940 reads
Getting to the data you need is always a challenge. Views can provide a "no muss, no fuss" way to retrieve the data you need—whether it's in the current database or another.
2008-11-19
2,972 reads
2008-11-25 (first published: 2008-10-20)
1,304 reads
This video covers the basics of creating a view in SQL Server. Views allow you to treat a query as a table and simplify your query writing. This view covers the Query Designer in Management Studio.
2008-07-31
5,756 reads
Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.
2008-01-02
6,623 reads
Views are one of the more basic constructs in SQL Server, but often it seems that developers are not sure when to use them. SQL Server expert DBA and trainer Andy Warren brings us a look at views as an abstraction layer in your database.
2007-10-25
4,912 reads
Hi AJ,Yes, all the sitename are populated.. I actually figured out the problem.. but not sure how would i be able to overcome this one..here is what is happenning..as per http://support.microsoft.com/kb/236605/EN-US/the first 8 rows in Excel determine the data type for rest of the rows in the sheet. IN my case first few rows have […]
2005-05-04
We have been using an access front end and SQL server backend for several years. The program evolved from an Access front and backend application. The performance across a WAN is terrible. We moved to Citrix to keep the thing moving. We are migrating to a .net frontend. In the mean time you can use […]
2005-05-04
The function is now working, though I did have to specify the master database - it did not find xp_sendmail via "db_applications". I am having trouble capturing the return code values (boolean) and/or result sets (from Books Online: Result Sets: xp_sendmail returns this message: "Mail sent"). I would like to return both. I used your […]
2005-02-21
Yup....post the code so that we can examine it.....and get rid of the cursor.If you don't know why I'm advocating the latter route....search here for 'good performance' and 'cursor'.....the 2 phrases rarely go together!99.99% of SQL actions can be done without cursors....with a (noticable)performance boost 99.99% of the time.....
2005-01-05
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers