GilaMonster (1/28/2009)

---

Steve Jones - Editor (1/28/2009)[hr "whether its transaction log backups, and XML indexes or whizbang fiber-optic laser beam assemblers." that were copied word for word, and these aren't phrases...

Cover your ears...

An execution plan is an execution plan. They all age and when the cache cleanup process comes along, they get removed from cache. No differences for stored procedures.

The...

Steve Jones - Editor (1/28/2009)

---

I'll admit to using Whizbang at some point in my life, but not regularly. At least I hope not.

I thought about posting a diff of the...

Unfortunately my company cut corners and we had to make due with the standard fiber-optic laser beam assemblers. They just wouldn't spring for the whizbang model. Stinks.

We're beginning a project to ASSESS the upgrade from 2000 to 2008 this year. I wouldn't sweat your skills being out of date. SQL Server 2000 is still going very...

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...