Probably a deadlock.

Using a NOLOCK hint (also known as READ UNCOMMITTED) allows you to read 'dirty' data - data that has not been committed yet. You saw rows that...

Waiting for the kettle to boil, so I have a minute to spare...

CREATE TABLE dbo.Test

(

...

Very slight variation on the theme:

SELECT P.FirstName,

P.LastName,

PayPeriod = ISNULL(TA.PayPeriod, '?')

FROM ...

sporoy (7/29/2010)

---

Estimated I/O Cost w/o hint: 2636, w/ hint: 3,26

Estimated CPU Cost w/o hint: 83, w/hint:1,56

Operator Cost w/o hint: 0.0051, w/hint: 0.01

So optimizer considers only operator cost? Do you...

Without a doubt best to avoid the cursor here, *but* there are ways to achieve the task if that's not possible for some reason.

Option 1 is to FETCH from the...

Probably due to the settings (like Collation Compatible, Use Remote Collation) you specified on the linked server. Please post an estimated...

Just to clarify about the ORDER BY: the index on SentTarih is already in sorted order (by definition) so no explicit sort is required.

Your clustered index is in a different...

Using ORDER BY, if the query optimiser chose to scan the table,...

The simple answer is it is because the optimiser estimates that a table scan would be cheaper.

Try the same query just SELECTing col1, instead of all columns (*), removing the...

The statistics that were considered interesting to the query optimiser are stored with the compiled plan, but this information is not exposed to users.

The real question is, why do you...

You're welcome.

But my favourite would probably be this:

DECLARE @SampleData

TABLE (

id INTEGER NOT...

There are many different ways to write a query to do this, here's a popular one:

DECLARE @SampleData

TABLE (

id ...

Some references for you to help you understand the things people have said:

The behavior of the IDENTITY function when used with SELECT INTO or INSERT .. SELECT queries that contain...

GilaMonster (7/26/2010)

---

That's not something I'd like to hear...