Mike C (5/29/2007)

---

God-awful loops and cursors. It's all I seem to see these days, and getting people to think about changing them? Even when you can demonstrate 100%, 200%, 500%,...

Adam Machanic (5/28/2007)

---

"A memory leak may occur in the common language runtime (CLR) if you pass a CLR user-defined data type as a parameter by using a stored procedure or...

We can always rewrite the question.

Does Windows XP by default come with Exchange Installed?

A. Yes

B. No

C. If you install Windows 2003 Server over it and then install Exchange

That's actually exactly...

I have to agree with GSquared. This one made me do some research to see which of these would work.

While I'm not a big fan of the undocumented things,...

Except that I just answered it... and it's saying...

Adam Haines (4/8/2008)

---

I believe I remember Antonio and Jeff doing some performance testing on parser functions and if I recall correctly the tally table is slightly faster (maybe a ms...

Actually... the joys of the Tally Table return... 🙂

http://www.sqlservercentral.com/Forums/Topic452198-338-1.aspx

SELECT TOP 11000 --equates to more than 30 years of dates

...

Antonio... that's some interesting code, but

select * from dbo.fListToText( 'a,b,c', ',' )

the function flisttotext is missing from the code.

At first I thought it was using flisttoitems, but when I...

I'm a US Citizen... doesn't change the fact that I'm...

I hate to beat this dead horse, but the corrected question/answer went out today.

Explanation: Either of the first two answers will work. All the month names have at least the...

Well...

I'm guessing as to what this is for, but I think it's basically making an attendance record for every user for every day. When a user is entered in...

Without the table structures, I can only give a sort of pseudo code but something like this.

Here's your trigger

CREATE TRIGGER NEW_USER ON USERS

FOR INSERT

AS

INSERT INTO ATTENDANCE([UID],[DATE])

SELECT

[UID],

GETDATE()

FROM INSERTED

The other...

Did you create indexes on the county and state fields? Need indexes to make it work.

I see some foreign keys, but not indexes in the structure above.

What do the...