columns Image

columns

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
Jon Crawford avatar image
Jon Crawford answered Default

How do I display overlapping appointments in a schedule calendar?

columns report schedule

0 Likes

1Answer

0 Comments

question
ThomasRushton avatar image
ThomasRushton answered Default

Is there a way to create a new column based on the condition of having a certain number of characters in another column?

columns case-statement characters

1 Like

1Answer

0 Comments

question
ThomasRushton avatar image
ThomasRushton answered Default

How to retreive one single value in comma separated columns form, from a table in sql server?

columns value comma separated

1 Like

1Answer

0 Comments

question
dbnerd3000 avatar image
dbnerd3000 answered Default

SQL Questions about getting MAX and MIN values based on two columns for the Ids from two others

sql tsql mssql columns max

0 Likes

1Answer

1 Comment

question
Oleg avatar image
Oleg commented Default

My Select query with more group by columns is running very slow

select columns

0 Likes

0Answers

1 Comment

question
DaveC avatar image
DaveC edited Default

How to Format File to Map Table Columns Bulk Insert

insert columns file bulk format

0 Likes

0Answers

0 Comments

question
Kev Riley avatar image
Kev Riley answered Default

Max value from multiple columns

columns max

0 Likes

2Answers

5 Comments

question
Gazz avatar image
Gazz commented Default

How to update a column where column is based on a table list

update columns variable

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Jeff Moden avatar image
Jeff Moden commented Default

Transposing rows to columns in SQL Server 2008 R2

sql-server-2008-r2 columns row

2 Likes

5Answers

0 Comments

question
Sean_Smith avatar image
Sean_Smith commented Default

Display Same Column in Pivot manner

pivot mssql columns

0 Likes

0Answers

1 Comment

question
genuiForex avatar image
genuiForex commented Default

Dynamically Unpivot Columns

pivot dynamic-sql dynamic columns

This question has an accepted answer. Accepted

1 Like

2Answers

2 Comments

question
abkumar avatar image
abkumar asked Default

How to check added or deleted data in a table

sql-server-2008 t-sql joins table columns

1 Like

0Answers

0 Comments

question
Farhangm avatar image
Farhangm answered Default

How permission on column works?

permissions columns

This question has an accepted answer. Accepted

3 Likes

1Answer

7 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Database Table Design--Rows vs Columns

table columns row

2 Likes

2Answers

1 Comment

36 Posts
35 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.