-
as seen on Stack Overflow
- Search for 'Stack Overflow'
We have a database in which all the PKs are GUIDs, and most of the PKs are also the clustered index for the table. We know that this is bad (due to the random nature of GUIDs). So, it seems there are basically two options here (short of throwing out GUIDs as PKs altogether, which we cannot do (at…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello colleagues.
I've got a question. I use NHibernate with MySql. At my entities I use Id(PK) for my business-logic usage and Guid(for replication). So my BaseDomain:
public class BaseDomain
{
public virtual int Id { get; set; }
public virtual Guid Guid { get; set; }
public class…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I want to have efficient query to get some rows from my table.
Here is I think the best presentation of my table.
-Somedate is not duplicated - it is date of modifiedon
-a,b,c are parent ids, let say countryCode
-1,2,3,4 are subparent, let say citycode
-guids are id of rows
-true, false are values…
>>> More
-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
Our partner was explaining to me that they are using GUID as primary key on all the tables. My immediate reaction was - why? and couple of basic doubts were: - since I can read uniqueidentifier, it does not tell me absolutely anything - if I will use my relational table, i sure will use other columns…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm trying to convert a string to GUID with sscanf:
GUID guid;
sscanf( "11111111-2222-3333-4455-667788995511", "%08x-%04x-%04x-%02x%02x-%02x%02x%02x%02x%02x%02x",
&guid.Data1, &guid.Data2, &guid.Data3,
&guid.Data4[0], &guid.Data4[1], &guid.Data4[2],
…
>>> More
-
as seen on Pro Webmasters
- Search for 'Pro Webmasters'
I've noticed this in the new version of chrome, and ie9 and 10.
Some urls in a photo gallery have a #id tag as they are supposed to display a full view of a picture. Basically, a div in a lower position on the page has that #id that i call via a.com/1.html#id.
This has never been an issue until…
>>> More
-
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
Over the years I have used a number of different types of phones. Windows Mobile, Blackberry, Nokia, and now Android. Until the Blackberry, which was my last phone (and I still have one issued from my office) I had never found a phone that “just worked” especially with email and messaging. The Blackberry…
>>> More
-
as seen on Super User
- Search for 'Super User'
Under Windows, is there any easy way to change or forge the vendor and product id of a USB device? Say for example there's a useful program which expects a particular (but ubiquitous and generic) device but you think it will probably work with the device that you actually have.
I've done lots of…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am working on an Android (v3.0) application that has a requirement of mimicking the weekly calendar layout found on Google Calendar:
The events will be based on external requests through the Google Calendar API (I already have this part working). Using the API, I can obtain a list of events for…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I will create multiple sale versions of the same application with push notifications feature:
CoolApp (full version)
CoolApp Free (free, features limited
version)
CoolApp InApp (free version
upgradable to full via InApp
Purchase)
While registering for App ID in Apple Program Portal is possible…
>>> More
