thbaig (8/10/2015)

---

Yes, I have confirmed. Overall data set size in temp table is ~100k rows.

When I set offset it terminate on EndRows , but always start from 0. e.g. if...

mrtran0404 (8/10/2015)

---

Sean Lange (8/10/2015)

---

mrtran0404 (8/10/2015)

---

Sean Lange (8/10/2015)

---

ChrisM@Work (8/10/2015)

---

John Mitchell-245523 (8/10/2015)

---

You're selecting every row from the table, so it's not going to be all that quick. Get rid of your...

Have you checked the data by eye to see if it's actually going to work?

create table #inv(

InvoiceNo varchar(20),

CustomerPo varchar(20),

InvoiceDateTime datetime

);

insert into #inv

select

Col1,col2,col3

...

-- Rewrite your inner query to use SARGable predicates.

-- Better still, consider a rewrite: build the query up as a string including only

-- the search criteria which will be used....

The query you have posted is nonsense,...

John Mitchell-245523 (8/10/2015)

---

You're selecting every row from the table, so it's not going to be all that quick. Get rid of your whole WHERE clause - it's just noise....

mrtran0404 (8/9/2015)

---

Dear all,

i having isue is when i select data form my table took more than 10 seconds to get result,

there are solutions that can help me get...

declare @StartRow int = 10, @EndRow int = 10

drop table #Temp;

;WITH

n1 AS (SELECT * FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) d (n)),

n2 AS (SELECT n = 0 FROM n1, n1 n),

iTally AS...

Grant Fritchey (8/7/2015)

---

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.

Move to the top, before any DML the following:[/font]

[font="Courier New"]CREATE TABLE...

Sean Lange (8/7/2015)

---

j-1064772 (8/7/2015)

---

[font="Comic Sans MS"]One simple improvement would be to avoid DDL in the middle of DML statements.

Move to the top, before any DML the following:[/font]

[font="Courier New"]CREATE TABLE...

serg-52 (8/7/2015)

---

I've checked the first query text using query diagrammer, namely off-line version of https://snowflakejoins.com/ and i see that

1) Product p is never used but in this...

HildaJ (8/6/2015)

---

Thank you in advance for any help.

I have a table that I need to do some computations on all the data but first I need to remove the duplicate...

ChrisM@Work (8/6/2015)

---

DavidDroog (8/5/2015)

---

Hi ChrisM

Replies below

1.Clients with “disciplines” filtered by geography using the geography parameter. This query should reference client, client address and geography tables plus those required to identify "disciplines"....

https://msdn.microsoft.com/en-us/library/ms190349.aspx

Data type determination...

Those three aggregate subqueries queries against the 'performance' table appear to be very expensive. Why not do them in one shot, which would offer you tuning possibilities for that component...