Viewing 15 posts - 18,781 through 18,795 (of 22,202 total)
GilaMonster (1/9/2009)
Grant Fritchey (1/9/2009)
There's about 3 inches of completely frozen snow in my yard and another 4-6 inches of the fluffy crap on the way tomorrow night.BLECH!
It's been 30+ degrees...
January 9, 2009 at 7:45 am
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...
January 9, 2009 at 7:43 am
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...
January 9, 2009 at 6:52 am
blandry (1/9/2009)
January 9, 2009 at 6:45 am
Domagoj Orec (1/9/2009)
Hi all.I just wanted to be part of this thread, 63 pages and I've just entered it today :w00t: :alien:
See you in February after you finish reading everything.
January 9, 2009 at 6:42 am
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...
January 9, 2009 at 6:38 am
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,...
January 9, 2009 at 6:32 am
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....
January 9, 2009 at 6:26 am
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...
January 9, 2009 at 6:22 am
I cannot vouch for the wealth of the selection, but I know that the following places have SQL Server PDF books for sale:
January 9, 2009 at 6:17 am
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...
January 9, 2009 at 6:06 am
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...
January 9, 2009 at 6:03 am
AndyD (1/9/2009)
January 9, 2009 at 5:48 am
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...
January 9, 2009 at 5:43 am
Viewing 15 posts - 18,781 through 18,795 (of 22,202 total)