This trace flag helped me when I was working with SQL Server 2000 about 8 years ago. Since I've stopped working with SQL Server 2000, I did not have...

You can use varchar(XXXX) or char(XXXX). Instead of XXXX you can specify a number up to 8000. The number represents the number of characters that you'll have. ...

You can do it with DDL trigger. DDL trigger can be created on server level and on database level, but each level has different events that fire the trigger....

There is a good chance that for large tables the server will do an index scan, but it depends on few more things. For example is the value that...

The original request was that if both of the values are 99, then we have to exclude that line. It is enough that one of the columns won't be...

Makes perfect sense. I was missing something:-)

Adi

edited: Sorry, just had a look at it. It does seems to work. According to the where clause one of the...

Am I missing something? Seems to me that this should work:

select cStudentID, cCurrentGradeCode, cAnticipatedGradeCode

from #temp

where cCurrentGradeCode <> '99' or cAnticipatedGradeCode <> '99'

Adi

When SQL Server has to read very small tables, it many times uses table scan. In such small size, it doesn't make a difference.

Adi

Most chances are that it will get used much more. Partly because it is needed for SQL Server 2012's always on and partly because now the secondary database can...

I'm sorry, but I think you are going to extremes here in your argument discussion with GSquared.

Just because you CAN add a persisted computed column and index it force a...

I don't think that the error that you got is an error that is generated from SQL Server. I couldn't find an error with similar text and you didn't...

anthony.green (12/19/2012)

---

@@RowCount only looks at the last statement which in this case would be the DECLARE which will always return 0 rows

Use COUNT(*) from the INSERTED table instead.

But if the...

I have to admit that it is very hard for me to define the term SARGable. Before we started our discussion in my opinion SARGable criteria was one that...

Can you explain the logic that is used to get the values for the computed columns?

Adi

At this point we both agree that when variables are used in a query and the variables got there values in the same scope as the query, the server will...