Most chances that all of you star wars fan, know this site, but just in case that someone missed it, here it is http://www.asciimation.co.nz/

Adi

RBarryYoung (4/26/2009)

---

(copied from my blog):

For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...

Here is another way to do it using replace and len functions:

Declare @t1 Table(mid int, val bigint)

Insert into @t1

Select 1,95 union all

Select 2,959 union all

...

Since we are sharing some bad code stories, I have to tell you the true and sad story from few years ago. At that time I was working as...

According to your trace’s definition, as soon as the file get to the size of 5MB, the trace will stop. Did you check if the file got to this...

You didn’t specify what duplicate records are. I assume that when you say duplicate records you mean each record that has the same value in IDNO column. ...

I don’t like this question and yesterday’s question. The fact that if we run the code it will have the same results as the answer that was selected as...

Jack Corbett (4/21/2009)

---

Still on the Summit. Where has everyone stayed when attending? How do you get around? This will be my first Summit and first trip to...

Full text search uses a list of noise words. Noise words are words that most of the time we wouldn’t want them to be indexed because it will just...

Can you explain why the SQL Statement has to use the exist operator?

Adi

I don’t think that writing SQL Code should be protected by copyright laws. There is a very big difference between writing a novel or creating a movie and writing...

If I’m not mistaken, build 10.00.1075 is a CTP. Is there any reason that you still work with a CTP?

I’m not sure that this should...

Distinct works on all the columns in the select clause. Most chances are that the column that you added has a unique constraint (or a primary key constraint)...

Check the small demo bellow. I didn’t fallow the exact way that you asked, but if you want you can modify it to have also a delete statement before...

Just run a query on master.dbo.sysdatabases. You can sid column as an input to suser_sname function, and name and created date are already in table (crdate).

Adi