my query is :

select top 1 [name],address,nextmedia1,[description] from media where look=1 and name ='100942885226.jpg'...

I think the fluctuating CPU usage by sqlservr.exe, may cause for this heavy reads. how can i fix these?

I...

yes, i mean both about background on the...

GilaMonster (5/31/2010)

---

My explanations weren't scientific enough? Did you read through the posts referenced in the first of those links?...

thanks, it was helpful.

do u know any...

Paul White (2/16/2010)

---

dr_csharp (2/16/2010)

---

Any other details...

Paul White (2/16/2010)

---

Right. I think I have worked out what you are trying to do. Correct me on the following where I am wrong:

You have data stored in...

i dont know what do u mean by limitation, cause this function has one goal and...

eventually i forced to write a function.

i put here for friends like use :

CREATE FUNCTION [dbo].[CONVERTOR](

@string nvarchar(10)

)

returns nvarchar(10)

AS BEGIN

declare @converted nvarchar(10),

@charnvarchar(10),

@counterint,

@lengthint,

@unicodeint,

@asciiint

set @counter = 1

set @converted=N'';

set @length=LEN(@string)

while(@counter <= @length)

begin

set @char=substring(@string,@counter,1)

set...

Carl Federl (2/14/2010)

---

"data stored in nvarchar field is number but in UTF-8"

This is not possible as national characters in SQL Server are stored in UCS-2 (Universal Character Set 2 byte)...

i create new database with SQL_Latin1_General_CP1_CI_AS collasion, but still same...

CirquedeSQLeil (2/13/2010)

---

http://msdn.microsoft.com/en-us/library/ms187928.aspx

You can do it - but data can be truncated, only partially displayed, or an error returned because the result is too short to display. Use the link...

Eddie Wuerch (1/11/2010)

---

Normal aggregate functions (SUM(), AVG, () COUNT(), MIN(), MAX(), etc.) are available to be used as windowed functions (using OVER and PARTITION BY).

SELECT Title,Subject, Max(Price) OVER(PARTITION BY Subject)...

hooRRRa ,i do like this :

SELECT * FROM Book Inner JOIN

(

SelectSubject,Max(Price) as Price

FROMBook

GROUP BYSubject

)T

On T.Subject=Book.Subject AND T.Price=Book.Price

but please guide me if there's any better solution :O)