Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapidea
Posting Yak Master
124 Posts |
 Posted - 2010-01-04 : 19:29:36
|
| I am analyzing a database.It has a GUID associated with each row which has a primary key.I know that GUID is used in web farm scenario. Is there any other use of it.Thanks. |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2010-01-04 : 21:04:24
|
A guid has a lot of uses. Anytime you need a identifier that will be unique regardless of the database, location, table, etc, then there is a potential use. In most smaller databases there is often a better identifier to choose to use besides a GUId.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2010-01-04 : 21:27:13
|
| Thanks Vinnie. |
|
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2010-01-04 : 21:49:37
|
| Can you give some examples....... one of them could be when we are using sessions across web farms and want to save it across databases....... |
|
|
|
balaganapathy.n
Starting Member
18 Posts |
Posted - 2010-01-05 : 09:48:36
|
| When you use enterprise beans in N' tier applications, you will be having more than 1 application servers, and 1 database servers. In such cases if a business object(bean) mapped to 1 or more database tables get modified in one application server, and it needs to be updated in other application servers cache, if it exists, in such cases if you have GUID, the updating of data between application server caches can be done easily.balaganapathy n.Anything you can imagine is real. |
|
|
|
mapidea
Posting Yak Master
124 Posts |
Posted - 2010-01-05 : 20:01:57
|
| Thanks Bala. |
|
|
|
|
|
|
GUID