SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Who Built This Thing?


Who Built This Thing?

Author
Message
Miles Neale
Miles Neale
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4222 Visits: 1695
When things like OPENQUERY against an LDAP store are available in stored procedures you know that it has gone a long ways from create a table read a record.

What appears to have happened is that the platform has been expanded over time to become another solution for other problems. This adds complexity and challenges, but it sure does somee very nice things.

Think of 38 cooks all stirring the same pot.

Have a great day.

Not all gray hairs are Dinosaurs!
GSquared
GSquared
SSC Guru
SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)

Group: General Forum Members
Points: 57005 Visits: 9730
I've only used two versions of SQL Server (2000 and 2005), but it does seem to keep getting better. And as I keep learning more, I find it easier and easier to make it do more, faster, and more accurately.

All in all, I think it's quite a good product.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9737 Visits: 1407
SQL Server is improving day version by version and it is one of the best peroduct of MS. Kudos to them........Smile



Dalkeith
Dalkeith
Mr or Mrs. 500
Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)

Group: General Forum Members
Points: 563 Visits: 1116
I've had a go at producing systems with mapping as well and I must admit done well they are incredibly valuable. They are also really quite difficult to get right.

We get used to constantly working with records that don't always have a real world equivalent - most financial transactions for instance.

For georgraphical features though to correctly identify a record you actually need to see a map of its location and for instance see if it has the same boundary as something else.

Utiliites / land parcels / road and rail.

In this respect the geographical feature / definition is often the ultimate identity of certain geographic records and so if you don't hold its geographical location it its like holding a record without a primary key - ultimately inaccurate.
Dave Poole
Dave Poole
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16616 Visits: 3403
We hired an external consultant to look at our data tier. He genuinely knew his stuff and made some good suggestions surrounding best practise. But the more he found out about our constraints and our business the more he came to the conclusion that what we had kind of made sensew00t

With SQL Server it's a huge product. You can have a career specialism that means that you never touch large parts of it. In some cases I have seen people use a feature/facility with little understanding for what it was actually supposed to be used for (replication filters being a prime example). They would almost certainly be frustrated by their results though ultimately the results were down to inappropriate use.

It's like watching someone use mole grips to tighten a plumbing compression joint. Might work, will be hard to undo it, probably cause leaks!

LinkedIn Profile
www.simple-talk.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search