On the start you can leave all the index.

analyse work on database, read statistic and you will see usage of indexes.

after that you can decide about existence of indexes

there are many causes for performance. but it's good to post little bit more details about this.

Like, do you have created index on some column if yes which type, do...

look at this useful link

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

can you put your code in more details?

What are these T.labeltext , T.LabelKey, T.FileID.

error message is clear

you want to add column or edit column?

in edit mode, when you change some value of column red exclamation mark show.

after changing, only click on the other row of table...

N denotes that the subsequent string is in Unicode, means National language character set.

When you use unicode you mast have Nvarchar/Nchar ...

Index will be used anyway, but there are some...

if you can post procedure code.

First error is:

In your stored procedure [Rep_Accuracy_Achievement_Analysis_Report]

you have insert data from another stored procedure in temp table. that is not allowed and you attempt...

try

select

substring( lastname, charindex(',', lastName )+1,

(charindex (',', lastName, charindex(',', lastName )+1 )-

...

you can't use the same column in partition and grouping

ParentProjects.ProjectID.

read about difference between group by and over partition by and you will see how they work

yghaziza (9/23/2013)

---

@Grasshopper, Can you be more specific on 'restrict with validation expression'? What else is there other than parsing the expression, which is the result of this definition coming from...

it shoud be

DECLARE @comparedate AS varchar(20)

SET @comparedate = convert(varchar(20), dateadd(D,-4, GETDATE()), 102)

declare @abfrage varchar(2050)

SET @abfrage='SELECT Anlagedatum, Artikel FROM S_artikel WHERE Firma = ''200'' AND convert(varchar(20),Anlagedatum,102) >=''' + @comparedate +...

select left(patientName,3)+repalce(dob,'-','')+'01' from table1

'01' - what if you have more then 99 rows?

how do you link this two table?

i think you must have some primary key on first table...

i don't see need to list definition of constraint in this case.

Restrict input in web application with validation expression,

use sp_help TABLENAME from production and archive, and checked if data type are same in both table.

in this case our interest is PK column

read this fantastic article carefully. This may help you

http://www.sqlservercentral.com/articles/T-SQL/62867/