Hi Simon,

...

Toni Thank-you for the suggestion :).

I started working on the part-2 of this article, I will talk about all the suggestions in that article. If there are any more...

I like using Red-Gate Data Generation for mass row generation :). I find it it works really well, and gives me the flexibility by using the regular expressions and...

Hi Jeff,

I was planning to create 5 databases, each with different number of records. One with the original 30, second with 300, 3rd with 1000, 4th...

Marcia,

Maybe someone turned of the trace, I know when I first discovered it I was like who turned this on and turned it off without realizing its use. Try...

Thanks Gail.

That what I ended up doing; just wanted to make sure I wasn't missing something :).

- Mohit.

cs_troyk (11/11/2008)

---

Regardless of the practicality of the particular example used in this article, it is a good introduction to many of the considerations involved in changing a db design and...

Heh you are not the only one in that thought I believe :).

I just found this on Microsoft Connect:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125819&wa=wsignin1.0

But I think because something similar is possible to do by means...

I found the default trace a long while back while wondering around in SQL Install files. As soon as I noticed it I had the questions like performance, who...

Jeff Moden (11/10/2008)

---

Heh... Understood and appreciated... I've been there with non-compliant vendors myself. Same goes for "out sourcing"... lot's of them don't care about performance or RBAR because they...

Thank-you everyone on the feed back :).

I been working on the 2nd part of this article. Just been busy with studies for MCITP and my masters. But I...

Hi Jeff,

Thank-you for the comments, I didn't think RBAR would be big issue in my case because the table had limited number of rows and wasn't going...

Micke Schonning (11/9/2008)

---

The function CombineGroupNames() can be optimzed using this concat-logic:

DECLARE @Groups VarChar(MAX)

SELECT @groups = coalesce(@groups +'|' + G.GroupName. G.GroupName)

...