Viewing 15 posts - 331 through 345 (of 7,631 total)
rstringer (5/21/2012)
No firewalls in this environment.
Windows has a software firewall built into the OS. You need to check that on the Server that is running your SQL Server instance....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 8:39 am
OK. But I've been playing Battleship since 1963 and we always had 5 ships, but it seems like you have 7? Are there any other variations from the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 8:34 am
formatting your code:
IPSearchLight.GeoLocator loc = new GeoLocator();
loc.Database_Path_or_URL = "GeoLiteCity.dat";
string VisitorIP = Request.ServerVariables["REMOTE_ADDR"];
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 8:22 am
Rachel Lee-244397 (5/20/2012)
What I really wonder, is to why they results should be different, asd the data is extacly the same -
Robert already explained this to you. Did...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 20, 2012 at 9:07 pm
This doesn't seem to follow the rules that everyone knows (and that you linked to at Wikipedia). Maybe you could post the rules that your game is following?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 20, 2012 at 8:55 pm
Methew (5/20/2012)
i do not know the internal structure(and i do not know how to know/check its internal structure)...i have this file GeoLiteCity.DAT.I am passing IP address of current user and...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 20, 2012 at 11:20 am
You know, You could also just use use a View that remaps the Table Default information already stored in the database's metadata and presents it in the same format as...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 20, 2012 at 7:52 am
What is the format / structure / contents of this DAT file?
You can certainly put the raw file into SQL Server and retrieve it again, however that alone will not...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 20, 2012 at 7:49 am
Which column is it and what exactly are you trying to enter?
(I ask because it doesn't look like a date column/value that you are trying to enter).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 19, 2012 at 3:11 pm
OK, I believe that I have it, though the why of it is still a mystery...
This line in your SELECT statement:
+ CASE WHEN dc.[name] IS NOT NULL THEN ' CONSTRAINT...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 18, 2012 at 12:46 pm
Surprisingly, I am able to (partially) reproduce this problem.
When I run it against one of my tables with the TOP clause I get:
smallidINT NOT NULL -- no default
,bigidINT NOT...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 18, 2012 at 11:42 am
gemisigo (5/18/2012)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 18, 2012 at 10:47 am
HowardW (5/18/2012)
Hi Barry,That's interesting. Here though, its not just the ordering that's incorrect, the entire accumulated resultset gets discarded, so it just doesn't work.
Right, but the "Why" of that...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 18, 2012 at 10:35 am
!!! How did you guys get in front of me?!?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 17, 2012 at 2:24 pm
CptCrusty1 (5/17/2012)
.....
AND (CASE WHEN COL_1 = 25 AND COL_2 <> 30 THEN 1
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 17, 2012 at 2:23 pm
Viewing 15 posts - 331 through 345 (of 7,631 total)