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...

Here in New England... it's a New England winter only a little more so. We could use a bit of global warming. There's about 3 inches of completely frozen snow...

GSquared (1/8/2009)

---

Grant Fritchey (1/6/2009)

---

GilaMonster (1/6/2009)

---

Which edition...

Also, is this a transactional system or a BI system? 60 columns for some of the BI systems I've seen is pretty standard.

Vijaya Kadiyala (1/8/2009)

---

Merge Join :

SQL Server performs a join between two sets of row data using the merge

join algorithm. The inputs are two separate sets of row data. Output...

Something I hadn't thought of earlier, but you might check the ANSI settings on the connection string from Access. If you use the ANSI standard settings, performance should be fine,...

Ah, then it's not going to be solved by tweaking indexes and messing with the execution plan. Something is going on in the network or with the Access app.