tom.wauters (4/24/2013)

---

Chris, I can see the little differences in the plan.

However, I am not a dba-expert, and not that good at analysing query plans.

Can you please explain me a bit...

John Mitchell-245523 (4/24/2013)

---

DevDB (4/24/2013)

---

Its running fine for me. It returned 29877 when I added CONVERT(numeric(14,2),Value) > 0 in where Clause.

My machine is

Microsoft SQL Server 2008 R2 (SP2) -...

Try this:

DROP TABLE #Test

CREATE TABLE #Test (ID INT IDENTITY (23,6921), Value VARCHAR(25))

INSERT INTO #Test (Value) VALUES ('3.14'), ('Twenty seven'), ('24/04/2013'), ('100'), ('Yesterday'), ('0')

SELECT *

FROM (

SELECT

ID,

Value,

NumericValue = CAST(Value AS...

Jeff Moden (4/24/2013)

---

Chris,

In reference to the following line of code in your fine function...

E3(N) AS (SELECT 1 FROM E2 a CROSS JOIN E2 b CROSS JOIN E1 c), --1M rows...

sharky (4/24/2013)

---

One set based way of doing it:

DECLARE @Adding TABLE (ID int identity(1,1),Result int,ActualResult int)

INSERT INTO @Adding (Result) VALUES (10),(10),(10),(10),(-10),(-10),(-10),(-10)

SELECT ID, Result, (Select SUM(result) From @Adding A2 WHERE A2.Id...

Thanks Jeff!

One of the points I meant to...

Your third party should read this!

Jason-299789 (4/24/2013)

---

I know, and this isn't the worst query, one of them had a 1.2 million Sub-tree cost at the root.

This particular query is used in a...

No worries mate. There's a lot to do here...

Indexing on Policy.SectionLimitExcess - no indexes at all, start with a single-column unique clustered index if possible and relevant. How about SectionID?...

Update statistics on all tables referenced by this query.

Add an index to the table [section] - a unique clustered index on SectionID perhaps?

Run the query, capture and post the...

Amy.G (4/23/2013)

---

Chris, Thank you for this article. I have been trying to figure out a solution to a problem I've had for a while, and could only come up with...

david.holley (4/30/2011)

---

The issue with company and public holidays is certainly there. The current push is to get the basics out. We'll probably end up with a table for the holidays...

-- itvf parameters

DECLARE @Startdate DATE, @WorkingDays INT

SELECT @Startdate = getdate(), @WorkingDays = 12

-- row generator (see DelimitedSplit2k8 article)

;WITH E1(N) AS (

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1...

niladri.primalink (4/23/2013)

---

Hi All,

In a table i want to apply order by. My database is 20-20 and table is errorreport where I have only 4 columns (rpt_id, error_id, file_id, errorlino). I...