The problem here is you're relying on an undocumented and unreliable use of variable assignment in a select statement.

There's absolutely no guarantee that the variable assignment will occur in the...

That's going to depend entirely on the logic within the SSIS package. I would assume you must have some conditional logic or wait conditions that can never be satisfied, or...

The problem with this is...

Deny and Revoke are not the same thing. Deny prevents permissions from groups...

erics44 (5/16/2012)

---

Hi

I have always been under the impression that in tables where there are a lot of inserts a clustered index should be avoided and clustered indexes should be used...

Jeff's correct here - there's no appreciable difference between SQL Server and Oracle for this kind of predicate.

Wrapping a char function around the column rather than converting the scalar parameter...

You're going to have to define "very large dataset".

If it's really huge, then yes, you'll have to do this in the database, but it obviously has complications and costs....

Depends on the average size of the data set. Both of the examples you've shown will be caching this on the application server - e.g. the database engine returns the...

Yep, what Revenant said. You can't evaluate NULL, just like SQL Server. As you have two columns involved in the logic, it might be simpler to have a step above...

Duran (5/14/2012)

---

The query did indeed return 0 rows, so I will add a clustered index and see what happens. I will also change the parallelism as well, I will leave...

OK, if it's a heap with no indexes, I'd fix the design rather than change parallelism settings.

You can find out if Session ID is unique at any given time...

I wonder why you're getting parallelism here for such a simple query... Is sessionID the clustered index of the Session table? Is SessionID unique?

Could you upload the deadlock graph as well?

It's important to understand what a deadlock actually is in diagnosing these issues - it's NOT the same as locking or blocking. It...

...Depends. Database...

Yep, it's very common thing to do. It can be done entirely in T-SQL and scheduled as an agent job.

All you need to do is backup the database to the...