satyanj (3/5/2013)

---

I run the following query on the AdventureWorks database.

SELECT ContactID,

LastName,

Phone

FROM Person.Contact

WHERE EmailAddress LIKE 'sab%'

In the execution plan, why is the "Key Lookup" operator appearing below the "Index Seek" operator...

Maybe, you can use a dynamic query

DECLARE @X bit, @strSQL nvarchar(2000)

SET @X = 1

SET @strSQL =' SELECT ' + CASE WHEN @X = 1 THEN ' COLUMN1,COLUMN2,COLUMN3'

...

I have some recommends here:

1-Choose the point time when your server does not work hard

2-Separate your table into smaller pieces (may be multiple files) and using a package to...

opc.three (2/28/2013)

---

Dung Dinh (2/28/2013)

---

Hi all,

I have a table Order with primary key ID column is uniqueidentifier data type on server B. Nightly, a synchronization job runs to synchronize orders from...

Dung Dinh (2/6/2013)

---

SQLAJ (2/6/2013)

---

Are you sure you have both the old and new user on the server? Is it only windows authentication? Do you know the SA account/password? You could...

Yes, SQL Service...

SQLAJ (2/6/2013)

---

Are you sure you have both the old and new user on the server? Is it only windows authentication? Do you know the SA account/password? You could also look...

david.abram (2/6/2013)

---

Hi,

As far as I understand your question, you are trying to login to your SQL instance with an account from a separate domain. As your SQL instance won't have...

GilaMonster (2/1/2013)

---

PageIOLatch isn't a lock, it's a latch. Usually used when SQL is moving pages around from memory to disk or disk to memory. Probably you don't have enough cache...

I got it. Thank so much,

james marriot (1/24/2013)

---

I have an example where the table im indexing appears in the join and where clause:

select OL1.a, OL1.b, OL1.c, OL1.d, OL1.e, OL1.f, OL1.g

from Orders O

inner join OrderLines OL1...

Bhuvnesh (1/22/2013)

---

I mean that the columns with data type = uniqueidentifier.

GilaMonster (1/22/2013)

---

You don't create indexes just based on that. The missing index DMV are suggestions, nothing more. Create an index on a test server, run a representative load, see if...

Thanks for all,

I will consider them before applying.

- You can create a computed column and search on it

Or

- Try to do that with Full-Text Search

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