Viewing 15 posts - 31 through 45 (of 55 total)
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
October 2, 2013 at 6:22 am
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...
October 1, 2013 at 8:51 am
can you put your code in more details?
What are these T.labeltext , T.LabelKey, T.FileID.
error message is clear
September 30, 2013 at 3:44 am
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...
September 29, 2013 at 1:44 pm
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...
September 25, 2013 at 11:01 am
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...
September 25, 2013 at 2:44 am
try
select
substring( lastname, charindex(',', lastName )+1,
(charindex (',', lastName, charindex(',', lastName )+1 )-
...
September 24, 2013 at 2:52 pm
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
September 23, 2013 at 11:50 am
yghaziza (9/23/2013)
September 23, 2013 at 11:39 am
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 +...
September 23, 2013 at 5:43 am
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...
September 23, 2013 at 3:36 am
i don't see need to list definition of constraint in this case.
Restrict input in web application with validation expression,
September 23, 2013 at 1:16 am
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
September 21, 2013 at 1:00 pm
read this fantastic article carefully. This may help you
September 20, 2013 at 10:12 am
Viewing 15 posts - 31 through 45 (of 55 total)