You're correct on what a cartesian product is.

Jeff was asking how an OR used in a where clause will get you a cartesian product.

You'll probably get better and more accurate advice if you read up on the concepts in Books Online and on the MSDN pages, then post here for specifics that aren't...

Spids get reused. If your job completes and disconnects, another job connects a second later, there's a chance of it running under the same SPID as the first job. It...

Since you're on SQL 2005, you can use one of the DMVs to retreive tha last statement executed, instead of InputBuffer that only returns 255 characters

SELECT er.session_id, blocking_session_id, wait_type, wait_time,...

Depends on your server and the activity. If you do set up a permanent trace there are a few things to be careful of.

1 - Don't trace the very high...

While you can have rows of a size larger than 8060 bytes in SQL 2005, they should still be avoided.

The page size hasn't changed and the largets row that...

😀 I always use !=, but I'm not...

This smells of homework, or interview questions. Is that the case?

Most of tthese are easily answered with Books online or a quick google search

karthikeyan (11/7/2007)

---

Hi Experts,

1. Tell me the difference...

That's not inserting into the table with the insert trigger. The trigger is on dbo.OEORDH, and that insert inserts into dbo.Derived_DB.tbl_ORDERS (a very, very strange table name. The database is...

Depends on the business requirements. In one of the systems I maintain, we have to (for legal purposes) have a record of who inserted the rows and when (along with...

Depends on the query and what you're trying to achieve.

FRom what I read of the article you linked to, the advice isn't to not use the inequality ever, but to...

What's the data type of the column in the table?

CTEs are defined before the SQL statement that uses them, not in it. something like this

;with MyCTE (col1, col2, col3) AS (

SELECT ... FROM aTable

)

SELECT [some fields] FROM MyCTE...

They're english abbreviations. Means postscript. Thoughts added after something else, usually only partially related.

Depends on the query. In the example you give, you can't replace the inequality operator. The alternative you give is identical to the original in terms of how its executed...