The single biggest cost is a function which references a view which references a function which unnecessarily uses a slow cursor to concatenate some columns. Or something similar. A half...

vahid.arr (3/22/2013)

---

i want to minus two time(time(7) datattype in sql 2008) datatype and multiple(hour and minute) it to 30.how can i do that?this just work for hour

SELECT datediff(HOUR,[EnterTime],[ExitTime] )*30 from...

Evil Kraig F (3/21/2013)

---

I am well aware of the bad contractors out there... I'm a contractor myself. I've actually called back to the home company and told them to...

It's down to an optimisation introduced in SQL Server2005 often called "Deferred expression evaluation". Here's a great article by Paul White to add to others already posted.

The original "failing" query...

;WITH

-- Make an inline...

Declare @OrigTab Table(Part varchar(30), qty int)

insert into @OrigTab

select 'X51','3' union

select 'A5','1' union

select '123','2' union

select '054','5'

select * from @OrigTab ORDER BY 1 DESC

;WITH

-- Make an inline tally table (CTE)

E1(N) AS...

Stefan Krzywicki (3/21/2013)

---

L' Eomot Inversé (3/21/2013)

---

dwain.c (3/20/2013)

---

Lynn Pettis (3/20/2013)

---

I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing...

karthik M (3/21/2013)

---

I have read about Bushy plan and left deep in some articles. Bushy plan will consume more memory as it runs parallely. is it advisable to write query...

The spec isn't entirely clear; does this generate the results you're expecting to see?

SELECT b.*, a.*, x.*

FROM TableB b

LEFT JOIN TableA a ON b.ColId = a.Area

LEFT JOIN TableA x...

DECLARE @SomeDate CHAR(8) = '0'

SELECT

ISDATE(@SomeDate),

CAST(NULLIF(@SomeDate,'0') AS DATE)

-- similar to this handy trick:

DECLARE @numerator INT = 1, @denominator INT = 0

SELECT @numerator/@denominator

--Msg 8134, Level 16, State 1, Line 3

--Divide...

homebrew01 (3/19/2013)

---

Chris, although your code is better, I can understand why it's confusing to newer SQL coders. I think it's less intuitive, and not everyone is familiar with some of...

bugg (3/20/2013)

---

Thanks for that suggestion.

The...

Jeff Moden (3/20/2013)

---

That's to make it so that only those product_ids that...

Add column [status] to the include list for index IX_sessionid.

As an aside, you appear to have a fair amount of duplication in your indexes.

Ah, that's because I used...