GilaMonster (1/9/2009)

---

It's been 30+ degrees...

I don't know your location or training budget, but I'd be remiss if I didn't suggest looking into Andy Warren and his team down in FL at End2End training. Great...

See, my memory stinks. It's Massively Unified Code Keys (MUCK) tables.

The first article:

http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/%5B/url%5D

Here's a great discussion about the topic too. One True Lookup Table is another name for the design:

http://www.sqlservercentral.com/Forums/Topic154165-204-1.aspx

Suffice...

blandry (1/9/2009)

---

To me, nothing is any worse than a guy wearing a suit and tie who looks like he has been forced to wear a suit and tie and is...

See you in February after you finish reading everything.

Yeah, that's a winner.

Your initial table definition:

userid (uniqueidentifier)

username (nvarchar)

points (int)

plays (int)

comments (int)

The query giving you problems:

UPDATE UserStats SET TotalPlays=TotalPlays + 1 WHERE Username=@username

Where is the column TotalPlays coming from? It's not there.

I...

There's a whole section on identifying gaps in Itzik Ben-Gan's book T-SQL Querying. Here's a way to list all the gaps, their start points and stop points:

SELECT cur+1 AS start_range,...

I'm confused as to why BULK INSERT is not generating the correct data. It's generally going to work better than straight inserts just because of the difference in logging....

As to licensing, sure you can run SQL Server on a workstation and have multiple connections. No issues. Well, except for whatever limitations you might run into in terms of...

I cannot vouch for the wealth of the selection, but I know that the following places have SQL Server PDF books for sale:

http://www.mobipocket.com

http://www.lulu.com

http://www.booksonboard.com

I've done both and I have to say, having 100 seperate pick lists is easier, more functional, easier to maintain, easier to document and easier for others to understand, support...

I've had to do that, or run the script from the directory where I want to store/read all the files. I'm not that aware of any other choices either.

Adding the...

AndyD (1/9/2009)

---

I am surprised at several posts here which admit that they "dress-up" when they, or their boss, deem the situation requires it. This to me is disingenuous. Your presentation,...

I've climbed under desks and pulled cable in a suit and tie and I've worked in shorts & sandals at a dot com. In neither situation was I more or...