kiman_keren (1/28/2009)

---

for question number 1: ow. i will try...

for question number 2: yup, i wanna know that.

for question number 3: wow. using clustered index for non clustered index... am i...

And you might want to talk to your instructor. That's a really poor example to show proper database use. Two tables with the same names, columns and data types? Serious...

I didn't get to see it. I wish I had. The discussion about it, prior to the plagiarism exposure, was pretty critical.

Sorry, I meant the example code. The explanation clearly mentioned two tables.

Yeah, I would have been curious to hear his side of the story too.

But I wouldn't throw rocks because he had few points when he posted an article. I posted...

Oops. Right. Forgot the N in front of the strings... sorry.

You can't pass parameters as column names, that's the error you're no doubt getting. To do something like this, you need to build the string and execute it:

DECLARE @y nvarchar(50)...

kiman_keren (1/28/2009)

---

Hello all,

i have some questions:

1. what's the different between clustered and non clustered? i've got a lot of answer in google, but i wanna know from this forum.

2. how...

KB (1/27/2009)

---

I have an insert statement and an update statement as follows:

INSERT INTO TableA

(

ColA1,

...

The unique constraint will keep duplicates from getting in. I'd suggest, in order to reduce contention, that you perform the INSERT statement without the pre-check and then check that the...

It looks like you're trying to return a list and a set of counts. You can do this without a cursor:

SELECT [name]

,COUNT([name])

FROM #DISTINCTC

GROUP BY [name]

You might want to pick up...

mbrady5 (1/27/2009)

---

Hello, I need help formulating the following.....

I would like to join cwm_cust table to cwm_cut_upload in the following query.. That part I am good with. What I cannot figure...

It's a pretty low act. I know that when I'm writing I'm scared to death I might string three or four words together in exactly the same way as someone...

Lynn Pettis (1/27/2009)

---

Thank you, this makes me feel really good. I'll try to get the execution plans for and post them here. It may a few days, as...

Uh... Wow... Over-achieve much?

I feel a bit stupid to be commenting on this. I don't have much experience with partitioning beyond reading up on the theory and a few discussions....