louise 28346 (8/18/2016)

---

thanks Chris

Its this part

SELECT 123, 1 UNION ALL

SELECT 456, 2 UNION ALL

SELECT 789, 1 UNION ALL

SELECT 789, 2 UNION ALL

SELECT 789, 3

Ive an issue with because my data...

Brandie Tarvin (8/18/2016)

---

ThomasRushton (8/18/2016)

---

Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"

erm... SELECT...

-- sample data setup

DROP TABLE #MyTable

SELECT

POS,

Employee_ID,

[Name],

[Date] = CAST([Date] AS DATE),

WkTimeStart = CAST(WkTimeStart AS TIME),

WkTimeEnd = CAST(WkTimeEnd AS TIME)

INTO #MyTable

FROM (

SELECT 18, 96, 'John', '01/07/2016',...

-- set up some data to code against

DROP TABLE #MyTable

SELECT *

INTO #MyTable

FROM (

SELECT 123, 1 UNION ALL

SELECT 456, 2 UNION ALL

SELECT 789, 1 UNION ALL

SELECT 789, 2 UNION ALL

SELECT 789,...

Grant Fritchey (8/18/2016)

---

ChrisM@Work (8/18/2016)

---

Brandie Tarvin (8/18/2016)

---

Brandie Tarvin (8/18/2016)

---

Ed Wagner (8/17/2016)

---

I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in...

Brandie Tarvin (8/18/2016)

---

Brandie Tarvin (8/18/2016)

---

Ed Wagner (8/17/2016)

---

I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN...

SELECT

sNo = DENSE_RANK() OVER(ORDER BY [name] DESC, cycleno),

cycleno, [name]

FROM #tmp1

ORDER BY [name] DESC, cycleno

joshua 15769 (8/17/2016)

---

My primary keys are int sirs, But my database columns are all varchar(MAX)

I would like to thank you both for the great answers, i'm thinking, could I mark...

tindog (8/17/2016)

---

ChrisM@Work (8/17/2016)

---

tindog (8/17/2016)

---

ChrisM@Work (8/17/2016)

---

Luis Cazares (8/17/2016)

---

Brandie Tarvin (8/17/2016)

---

Eirikur Eiriksson (8/17/2016)

---

😀

...just...

tindog (8/17/2016)

---

ChrisM@Work (8/17/2016)

---

Luis Cazares (8/17/2016)

---

Brandie Tarvin (8/17/2016)

---

Eirikur Eiriksson (8/17/2016)

---

😀

...just managed to...

It sounds like one or more of the join columns are missing from whatever index is chosen, which would go some way to explaining the poor row count estimate and...

Luis Cazares (8/17/2016)

---

Brandie Tarvin (8/17/2016)

---

I...

Indianrock (8/17/2016)

---

Almost all of our application code is ORM-generated, originally in C# code. ( entity framework type stuff )

Are you saying the table/column aliases etc actually have a bearing on...

There is a use case for having an ordinary index with the same leading edge column as the clustered index. If your table is very wide (meaning less rows per...

Anandkumar-SQL_Developer (8/17/2016)

---

Dear ChrisM@Work / twin.devil ,

...