I think give it a try by using temp table instead of table variable , then crate index on temp table for the field whic is in where clause ,...

Clear with the Max row size, it wont allow char to grow more than 8060 and varchar would reside in row upto 8060 and after that off tha page...

thanks a...

ok means the max row size is 8060 bytes and anything more than then resides off the page , right...

Thanks very much.....

Mithun

this row size me total columns size?

i mean i tried like this first,

create table my table (str1 varchar(3000),

...

Hey chris sir,,,

thanks for ur reply... now i know y we cant use dml in functions...

thanks , really thats usefulll

Mithun

Chris Morris (4/22/2009)

---

mithun.gite (4/22/2009)

---

Dear friends,

Need understanding, that y v can perform DMLs in Functions?

We can use DMLs using table variable in fucntion then y can with actual tables..

Please guide me...

GilaMonster (4/21/2009)

---

I can suggest some books.

Inside SQL Server 2005: Query Tuning and...

Florian Reischl (4/17/2009)

---

Hi

In SQL2k5 it is possible by a detour over a non-unique index and a CHECK constraint:

CREATE TABLE TestCheck

(

Id INT NOT NULL IDENTITY,

UniqueText...

Paul White (4/17/2009)

---

Mithun,

Everyone else has posted the sensible answers, so...

GilaMonster (4/17/2009)

---

Then what was the point of posting it?

its just a matter of...

GilaMonster (4/17/2009)

---

mithun.gite (4/17/2009)

---

Actually I have been asked to Optimize the query and do the performance tunning to the query.

select * from emp where dept_no in(10,20,30)

As in this query only optimization...

Chris Morris (4/17/2009)

---

mithun.gite (4/17/2009)

---

There is a big performnace problem with using Exists in this example,, so can i say that if we are passing static values in where clause then...

Dear All,

I took some test data on adventureworks database...

below are the queries:::

Query 1

select * from HumanResources.EmployeeDepartmentHistory

where departmentid in(7,4,1,2)

(201 row(s) affected)

Table 'EmployeeDepartmentHistory'. Scan count 1, logical reads 4, physical reads 0,...

Dear ALL,

Actually I have been asked to Optimize the query and do the performance tunning to the query.

select * from emp where dept_no in(10,20,30)

As in this query only optimization we...

It is possible, one way i know which is pasted below, wanted to know anyone knows the other simple way????

SET NUMERIC_ROUNDABORT OFF;

SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

QUOTED_IDENTIFIER,...