Gianluca Sartori (2/18/2011)

---

I have to admit it was my fault.

If I didn't post on THE THREAD a "Lennie alert" nobody would have noticed, Lennie would have got his answer and...

Craig Farrell (2/18/2011)

---

Koen Verbeeck (2/18/2011)

---

I just read the thread you linked...

Jack Corbett (2/17/2011)

---

george sibbald (2/17/2011)

---

Koen Verbeeck (2/16/2011)

---

Jeff Moden (2/16/2011)

---

CirquedeSQLeil (2/16/2011)

---

For the execution of Wayne:

--get spid of code requestor

sp_whorequestedcodeIntheThread 'Wayne'

--use returned spids to verify the request

dbcc inputbuffer(61)

--output

'Wayne definitely requested...

GSquared (2/16/2011)

---

Fal (2/16/2011)

---

Koen Verbeeck (2/15/2011)

---

Fal (2/15/2011)

---

WayneS (2/15/2011)

---

Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a...

GilaMonster (2/14/2011)

---

Stefan Krzywicki (2/14/2011)

---

GilaMonster (2/14/2011)

---

Grant Fritchey (2/14/2011)

---

Now I feel much better. I lose my job to Gail or I lose my job to Gail. Isn't there a third option that...

GilaMonster (2/14/2011)

---

Grant Fritchey (2/14/2011)

---

Now I feel much better. I lose my job to Gail or I lose my job to Gail. Isn't there a third option that doesn't involve me...

ALZDBA (2/14/2011)

---

IMO you are fooling yourself by using the wrong PF with the correct table in your select query.

SELECT *

, $PARTITION.AnnualDateRange_PartitionFunction(OrderDate) AS...

I haven't had a chance to run the code and won't until after work today at the earliest, but from reading through it it looks like your SWITCH statement violates...

Have you done a query against the system tables to see if that's still the case?

SELECT T.name, P.* FROM sys.tables T

INNER JOIN sys.partitions P

ON T.object_id = P.object_id

This query will tell...

nadabadan (2/13/2011)

---

Craig Farrell (2/13/2011)

---

EDIT: I was going to respond again but then I realized I was answering the exact same argument for the third time. You ignore half of...

nadabadan (2/13/2011)

---

No...

WayneS (2/13/2011)

---

Stefan Krzywicki (2/9/2011)

---

An interview isn't just the employer deciding on an employee. The employee is also judging the employer. I think many people fail to realize this even during...

WayneS (2/13/2011)

---

Congratulations! Seems to be quite a few folks moving on... I myself just started a...

nadabadan (2/13/2011)

---

I did. Here I was answering the question "When did I claim it was a question about basic knowledge of "computer theory".

Are you now saying that everything you said...

nadabadan (2/13/2011)

---

Stefan Krzywicki (2/13/2011)

---

nadabadan (2/13/2011)

---

When did I claim it was a question about basic knowledge of "computer theory". What I SAID was it was a question to learn about someone's...