IF OBJECT_ID('tempdb..#PartsList', N'U') IS NOT NULL

BEGIN

DROP TABLE #PartsList;

END;

GO

CREATE TABLE #PartsList

(

PartId INT...

What you actually search for is a string pattern within a number represented as a string using decimal notation.

Therefore you'll be better off having PartNumber stored as a string and...

Every record must fit into a single data page.

A data page is 8K.

1...

SELECT top 10 * from XYZ x

WHERE EXISTS (SELECT * FROM ABC a

WHERE a.Col2 = x.Col1

AND (Col3>date OR Col4>date OR Col5>date)

)

For this query (any version of it) to perform well...

DesNorton (4/5/2016)

---

I have inherited a DB, and need to make some changes for a search proc.

This app and DB are still in dev, and have not yet been published to...

Unless those characters are used for something else.

I used to import catalogue files...

It will return the same zero value for "0A" and "A".

I do not...

Following data normalization rules actually helps.

If numeric and alphabetic parts of the values are meant to be processed separately then they must be stored in separate columns.

If you cannot make...

andrea.dimaio (4/4/2016)

---

Now i've checked perfmon counter log bytes flushed/sec and i've seen that when the mistrious event happens,

this counter GO DOWN. So it means that :

- we have an external...

nadersam (3/31/2016)

---

First i would like to thank you Curious and Hugo for the detailed reply.

I have updated statistics for both database for those 3 tables.

The view still taking 3 sec...

JediSQL (4/1/2016)

---

Well, most of the data in the remote views does pass muster, so we end up pulling most of it. Thus, it is more efficient to get all...

Luis Cazares (4/1/2016)

---

Sergiy (3/31/2016)

---

GilaMonster (3/31/2016)

---

No. Temp tables are session-scoped, you cannot access a temp table created in...

drew.allen (3/31/2016)

---

Hard-coding the translation table is not necessarily a bad idea if the translation table is relatively small and the table rarely, if ever, changes. You need to know...

drew.allen (3/31/2016)

---

I specifically said Inline Table-Valued Function, precisely because they are inlined. Scalar functions are never inlined, which is why it can make sense to create an inline table-valued...

GilaMonster (3/31/2016)

---

No. Temp tables are session-scoped, you cannot access a temp table created in another session, not...