Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?
2011-12-07
3,950 reads
2011-08-02 (first published: 2011-07-28)
2,977 reads
An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries
2009-08-19
8,629 reads
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
2012-07-20 (first published: 2009-07-09)
52,606 reads
quote: Good one. In recent days I heard about Hirarchial Databases. What about them? Have they released?? The hiearchical database model is somewhat older than the relational model. I think the most prominent system is IBM's IMS which (still) runs on older mainframe systems. With the evolution of object-relational or object-oriented DBMS this model has […]
2003-09-16
1 reads
Agree with Andy Warren suggestion or add a column confirmed(Yes,No,Maybe,etc.).
2003-08-17
Hi, I reinstalled the SQL Server + SP3 but nothing has changed. The Agent still can't be started :((( I have 2 ideas left: 1. Something is wrong with the operating system. 2. There's a setting that prevents the Agent from starting. But what could it be??? Any other idea? Thanx, Csaba Csaba Mezo (mezo@inform.hu)
2003-06-20
1 reads
Another way to do it is: Convert(char(8),dteShipped,1) This will convert the date to a mm/dd/yy format.
2003-06-19
1 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers