view Image

view

question
Jeff Moden avatar image
Jeff Moden answered Default

Should I implement a view or a stored procedure?

view stored procedures denormalize

0 Likes

2Answers

0 Comments

question
mihalko avatar image
mihalko asked Default

Does the number of columns in a view, effect the performance of queries against the view if not all columns are being queried?

sql-server sql-server-2012 performance view columns

0 Likes

0Answers

0 Comments

question
bbunn avatar image
bbunn commented Default

Is it possible to compute a value in a view (Part_Final) and also use that calculated value to pull in the part description, in the same view statement?

view calculated column

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
cdburns123 avatar image
cdburns123 answered Default

Never seen this: LEFT OUTER JOIN ACTIVE STUDENTS ON STUDENTS.ID

sql-server-2012 view left join alias

0 Likes

1Answer

2 Comments

question
simon_ingle avatar image
simon_ingle answered Default

Hidden Items in SSRS 2016

ssrs view report users hide

0 Likes

1Answer

1 Comment

question
SSGC avatar image
SSGC commented Default

USE CTE slow in view than use temp table in sp

view cte linked server temp

This question has an accepted answer. Accepted

0 Likes

1Answer

7 Comments

question
DaveC avatar image
DaveC edited Default

How can I create a view with parameters?

t-sql view seeder-question database-objects

This question has an accepted answer. Accepted

3 Likes

2Answers

3 Comments

question
WRBI avatar image
WRBI commented Default

Get Details from dynamic table fields in a View

query view dynamic-sql

0 Likes

0Answers

1 Comment

question
ThomasRushton avatar image
ThomasRushton answered Default

How to reduce the store Procedure execution time

stored-procedures performance view

0 Likes

1Answer

0 Comments

question
S_M avatar image
S_M answered Default

Cannot read the data from a view, but can from the underlying tables.

sql-server-2008-r2 view data

0 Likes

2Answers

7 Comments

question
A S avatar image
A S asked Default

In SSMS v17 add table missing when creating a view

table view add

0 Likes

0Answers

0 Comments

question
Oleg avatar image
Oleg commented Default

View Syntax

view syntax

0 Likes

0Answers

3 Comments

question
KenJ avatar image
KenJ edited Default

Views and Triggers

view

0 Likes

0Answers

1 Comment

question
JohnM avatar image
JohnM edited Default

Decrypt view? see SP and Functions...etc

sql server view

0 Likes

0Answers

0 Comments

question
Sagar Bhargava avatar image
Sagar Bhargava commented Default

Issue while loading data from view

sql server 2012 view

1 Like

1Answer

6 Comments

93 Posts
86 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.