Is not as simple as that. There are many different types of vision deficiencies. You may need to...

Some relevant discussion on this forum:

http://www.sqlservercentral.com/Forums/Topic1227558-1292-1.aspx#bm1227579

So, you have read this:

http://msdn.microsoft.com/en-us/library/aa213039(v=sql.80).aspx

Shared with intent exclusive (SIX)

Indicates the intention of the transaction to read all of the resources lower in the hierarchy and modify some (but not all)...

pdanes (12/21/2012)

---

Eugene Elutin (12/21/2012)

---

If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into table...

Shadab Shah (12/21/2012)

---

Al right .But they are totally different object . I mean to say one is a table and another SP. So that means you are saying that i...

Shadab Shah (12/21/2012)

---

Hi,

Since i am newbie to SQL Server, i am finding some new things.

1. I have a table in dbo schema named as Demo

2. I tried creating SP with...

If your input parameter is just a list of character-separated values, then you can make it just VARCHAR(MAX), then use split function to split it into table inside of proc...

Without artificial intelligence which is on pair with clear human knowledge which names refer to the same company and which one, even very similar ones, are not, it is simply...

You can clearly see in your execution plan that SQL performs full table/index scans for all of your tables used in queries, together with using HASH MATCH join which is...

Any indexes?

You join on non-key columns, so do you have indexes on them?

Can you also post current execution plan.

GilaMonster (12/21/2012)

---

You'd think...

To improve the performance of your...

DataAnalyst011 (12/19/2012)

---

Has anyone ever needed to make a chart (especially a line graph) in SQL Server Reporting Services user-friendly for color blind users? I've been brainstorming of various ways, but...

Kwisatz78 (12/20/2012)

---

Hi all

I am wondering what is best practice when a table has no natural primary key and no clustered index, what is the best thing to do in regards...

... I woud think that if there was a major problem with the query that it would always take a while to retrieve but that is not the case.

My question...