You can have just one Clustered Index per Table!!!

Are you thinking for the index with more than one column ( included columns ) ?

OK we must to avoid the double posts ...please post all comments here

:exclamation:

Yes the first step is to enable ( sure to create before ) trigger for any update, delete or insert record from the users!? This is the simple way to...

I think you should use the EXISTS ( when you have complex query to retrieve the data you want from DB) instead of IN clause, because you can see differences...

:hehe: almost every post or thread has the good feedback after replies but this one here is the general feedback for SSC, and I agree sure that the SSC...

Yea, plz translate it ...!!!!:w00t:

http://msdn.microsoft.com/en-us/library/aa226054(SQL.80).aspx

This is the location where you can find everything about converting, also with examples!

Whistling:

cutedeveloper (3/26/2009)

---

Hi Dugi!

It seems I do not have that forder and u_tables.sql script. What I have are:

C:\Program Files\Microsoft SQL Server\90...

D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL...

:angry:

Actualy I got the same (There is...

Why do you...

musab (3/26/2009)

---

Hi !

I am using data type nvarchar(max) and have 13 million records and want to get unique records out of it based on the text.

but the query...

sonu_jain (3/25/2009)

---

I am having more than 2 years of experience in working on database technologies.

i was working in an mnc in india as informatica developer for about 1 year 2...

Welcome on board!

As you can see...

Vampire (3/24/2009)

---

Brian,

I guess I dig grave for my own SQL Server :crying:

I have executed this trigger on a SQL Instance .\Inst1 and now it is not allowing me to connect...

Vampire (3/20/2009)

---

Thanks for the post Brian.

However, I am stuck with few issues. Hope you could throw some light on them and clarify .

1. I executed the Step to insert <local...

You are welcome!

:hehe: