There's nothing about local variables which prevent index usage.

That 30% is the worst possible case for a guess by the optimiser, not the norm. If it can manage a better...

Then why are you asking about all the data mining algorithms? That's what all the algorithms you...

Do you understand what data mining is used for? If not, please do a bit of reading on it.

The question is still too vague to be answerable.

Ed Wagner (8/4/2014)

---

So...

And vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1599205-391-1.aspx

That's a pretty vague question. Could you be any more specific?

EXEC sp_help_job <parameters>

You will need something in the next step of your local job to poll/wait in a loop, checking the status of the remote job to see if it's finished.

sp_start_job does...

WhiteLotus (8/3/2014)

---

GilaMonster (8/3/2014)

---

That counter is...

raj.prabhu001 (8/3/2014)

---

I have a fact table which has six field now and I have created non clustered index on all fields.

It will also have more fields later with millions of...

That counter is misleading. It...

Eirikur Eiriksson (8/2/2014)

---

Jeff Moden (8/2/2014)

---

I agree that SEQUENCE has the advantage of being able to cover multiple tables and that IDENTITY requires SET IDENTITY INSERT if you want to update...

Also need to keep in mind that CDC is Enterprise Only.

p.s. Nolock has side effects, it's not a go-faster switch that should be added to every single statement. Let's not...

WITH Employees AS (

SELECT

[LastName] + ',' + [FirstName] AS FullName

,HireDate

,Title

,DepartmentName

,BaseRate

,VacationHours

,SickLeaveHours

,ROUND(DATEDIFF(DAY,HireDate,'2014-08-01')/365.25,2) AS EMP_TENURE

,(SOME LOGIC OFF OF VACATION DAYS) AS PTO_REMAINING

FROM [AdventureWorksDW].dbo.DimEmployee

)

SELECT

FullName

,HireDate

,Title

,DepartmentName

,BaseRate

,VacationHours

,SickLeaveHours

,EMP_TENURE

,PTO_REMAINING

, (SOME LOGIC INVOLVING 'EMP_TENURE' AND 'PTO_REMAINING') AS BONUS

, (SOME...

Daniel Matthee (8/2/2014)

---

Can you please explain then when using an inner select statement (to minimize the sample )on huge table. (+- 20 columns, 400mil rows) the query runs WAY longer...