Don't have time to compare them that I need but we are looking at two completely different query plans. Also, the troublesome query is a select and the other...

Can you also post the actual execution plan for the query from the server where it works well?

Have you checked the windows and sql server logs on the server itself?

I find that derived tables make the queries more difficult to read and understand. Using CTEs allows you to move the derived table to an easy to understand construct...

So, does the extra typing make it more complex? I think it makes the query more understandable.

Sergiy (3/17/2013)

---

🙂

Let's compare:

;WITH MyData AS (

...

Vedran Kesegic (3/17/2013)

---

You could also do it without cte. Why employ complex technique when you can use simple one? Cte is really great for recursion and multiple use of the...

clintonG (3/17/2013)

---

kevaburg (3/17/2013)

---

Logins created within the instance have by default no automatic access to any database within that instance. Each created user needs to be explicitly mapped to a...

Welcome to SSC. First, you did describe your problem okay but we really could use more information to really help you. For myself, and others, it helps to...

It would help if you would provide the DDL (CREATE TABLE statement(s)) for the table(s) involved in the query, sample data (NOT real data, just sample data that mimics your...

brettstahlman (3/16/2013)

---

Lynn Pettis (3/16/2013)

---

brettstahlman (3/16/2013)

---

opc.three (3/16/2013)

---

The reason why I disagree is because of the behavior of the after trigger when it is the instead trigger that is fired first. The...

pooya1072 (3/16/2013)

---

hi

i craete a SP in my database . by this command :

USE [MyDatabase];

GO

CREATE PROCEDURE test

AS

SET NOCOUNT ON;

SELECT id, feed1, feed2

...

brettstahlman (3/16/2013)

---

opc.three (3/16/2013)

---

The reason why I disagree is because of the behavior of the after trigger when it is the instead trigger that is fired first. The instead trigger fires...

Perhaps something like this:

declare @ProductType varchar(???),

@SalesIncrease int;

set @ProductType = 'LEISURE';

set @SalesIncrease = 1000;

with ProductsToUpdate as (

select

Year,

Company,

Product,

ProductType,

LastYearsSales,

ForecastSales

ProductCnt = count(Product) over (partition by ProductType)

from

MyTable

where

ProductType...

karthik M (3/16/2013)

---

Hello All,

I just refreshed all my posts.

This is a very old post (asked on 2009) 🙂

How to identify whether a code fall under O(n) / O (n2) /...