... i just avoid GUID

Posted by Tomaz.tsql on SQL Blogcasts See other posts from SQL Blogcasts or by Tomaz.tsql
Published on Sun, 28 Nov 2010 13:36:00 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 547

Filed under:

guid

|

execution plan

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 to get the information out - SQL is terrible when setting up clustered index on GUID columns (and hence performance problems) - why not use INT? it will save you space on disk, optimizer will be able...(read more)

© SQL Blogcasts or respective owner

Related posts about guid

MS SQL Database with clustered GUID PKs - switch clustered index or switch to sequential (comb) GUID

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
Nhibernate Guid with PK MySQL

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
Please for efficient query

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
... i just avoid GUID

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
Convert string to GUID with sscanf

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

Related posts about execution plan

Iterative and Incremental Principle Series 3: The Implementation Plan (a.k.a The Fitness Plan)

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome back to the Iterative and Incremental Blog series. Yesterday, I demonstrated how shorter interval sets allowed me to focus on my fitness goals and achieve success. Likewise, in a project setting, shorter milestones allow the project team to maintain focus and experience a sense… >>> More
Improving Partitioned Table Join Performance

as seen on SQL Blog - Search for 'SQL Blog'
The query optimizer does not always choose an optimal strategy when joining partitioned tables. This post looks at an example, showing how a manual rewrite of the query can almost double performance, while reducing the memory grant to almost nothing. Test Data The two tables in this example use… >>> More
How do I deal with a third party application that has embedded hints that result in a sub-optimal execution plan in my environment?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
I have gotten many variations on this question recently as folks begin to upgrade to Oracle Database 11g and there have been several posts on this blog and on others describing how to use SQL Plan Management (SPM) so that a non-hinted SQL statement can use a plan generated with hints. But what… >>> More
Start a Mapping or Process Flow from OWB Browser

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Basically, we start a Mapping or Process Flow from Oracle Warehouse Builder (OWB) Design Client. But actually we can also start a Mapping or Process Flow from OWB Browser. This paper will introduce the Start Report first and then introduce how to start/rerun a Mapping or Process Flow from OWB Browser… >>> More
Career Plan: The one year plan. The three year plan.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Folks, I work as a developer however I only recently began developing full time having worked for 5 years in various roles. When it comes to career planning I think I pretty much agree with The Journeyman to Craftsman model coined in The Pragmatic Probrammer and used by Bob Martin. I see myself… >>> More