What are the date types in both databases?

Date you provided might be dirty in business logic, but not for all date types. It is just year 200.

Can you post actual execution plans for both clauses.

RVO (11/4/2013)

---

Another interesting thing with [ prj_detail ] table.

A very simple query runs 4 seconds with hard_coded value co_code = '7001'

and it runs

1 minute using parameter.

use proddb6

declare @P_CO_CODE varchar(4)

set @P_CO_CODE...

razzgor (11/3/2013)

---

I'm hesitant to since this is my company's data. Any advice to offer without me having to upload specific details of the underlying structure? Things to look...

Hugo Kornelis (11/3/2013)

---

* The reply by Ville-Pekka is incorrect. I think he is confusing two features. Indexed views is the only feature that works automatically in enterprise but needs hints...

Actual execution plan would have helped a lot, but here is my shot in the dark.

Spatial indexes work automatically only in enterprise and development editions, so if you have standard...

jasona.work (9/2/2013)

Second, WTF is going on at MS? First, they go and kill off the Technet subscription, pissing of scads of people of various levels (from consultants who used...

declare @table table (categoryid int)

declare @t table(categoryid int,lobid int)

-- added 1,4

insert @t

select 1,2 union all select 2,3 union all select 1,4

-- added 3

insert @table

select 1 union all select 2...

What is the expected result.

I think this data will not return anything because there is no lobid=4 and you have match for each row.

If I remember right MySQL has such features. One is able to specify different grants by IP addresses.

Fal (8/22/2013)

---

We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone...

wolfkillj (8/19/2013)

---

Stefan Krzywicki (8/19/2013)

---

Sean Lange (8/19/2013)

---

Stefan Krzywicki (8/19/2013)

---

The Dixie Flatline (8/19/2013)

---

Just looking in a minute, while stopping to grab a donut. I feel compelled to ask...

Minnu (8/16/2013)

---

Hi,

Am having a non-cluster index on two columns, but the performance of that tables from my application is too slow, if i change the non-cluster index to cluster index,...

I think you just need to create table with columns code and location.

create table codeToLocation (code varchar(20), location geography);

After setting up data you just join this table to your query.

s_osborne2 (8/14/2013)

---

Hi,

That depends entirely on what they're doing with them. In my shop all developers have a local copy of SQL Server dev edition installed and there's also a dev...