I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

October 2006 Blog Posts

I want a culture insensitive decimal separator for Sql server

If there can be a culture insensitive format for dates (yyyymmdd) then why is there no such thing as a culture insensitive format for decimals? I suggest a use of # or ~ instead of the decimal separator in update and insert scripts only. And it would be allowed only in numeric/decimal/float datatypes. so you could do: create table t1 (MyDecimalCol decimal (16,3)) insert into t1 (MyDecimalCol) select 123#456 union all select 789#123 select MyDecimalCol from t1 -- would give: 123.456 789.123 -- or 123,456 789,123 -- depending on your locale Wouldn't that be great? I already suggested to Microsoft a culture neutral decimal separator a while back. (Does anyone know the URL of the...

posted @ Tuesday, October 24, 2006 11:20 AM | Feedback (7) | Filed Under [ SQL Server ]

Entity-Attribute-Value (EAV) model with SQL Server 2005 xml datatype

I've seen this technique a few months ago on a local MS event called NT Conference presented by Slovenian MVP Dejan Sarka. However i haven't seen him blog about it yet (a shame) so after seeing this post by co blogger David Moloney here on SQLTeam blogs in this post about EAV i decided to give this little thing a go by myself. I've also chosen the same DB model as david for comparison: A Client can have many “end user” defined data elements. For the purpose of this example we will choose 5 data elements to focus on the modelling aspect Age – Integer greater...

posted @ Saturday, October 14, 2006 5:03 PM | Feedback (7) | Filed Under [ SQL Server ]

Interesting use of C# 2.0 ?? Coalesce operator when iterating through a collection

Ever since I discovered the ?? colaesce operator I embraced it with full force. Today I discovered another usefull use:   // this: string[] arrayOfStrings1 = new string[] { "arr1s1", "arr1s2", "arr1s3" }; foreach (string str in (arrayOfStrings1 ?? new string[0])) { // do some stuff on the array elements } // equals to this: string[] arrayOfStrings2 = new string[] { "arr2s1", "arr2s2", "arr2s3" }; if (arrayOfStrings2 != null) { foreach (string str in arrayOfStrings2) { // do some stuff on the array elements } } // in terms of what it does   This...

posted @ Monday, October 09, 2006 6:36 PM | Feedback (5) | Filed Under [ .Net ]

SQL Refactor beta is out

I usually don't do these kind of posts but for this i'll make an exception :) This is such an awsome tool for me for one reason only: SQL Formatting It takes you query and formats it with the template that you can also change yourself. you can download it here. support forum is here. It will also come in a bundle with SQL Prompt 3.0. If all that that was a woman i'd make sweet love to it. that's how much addiction this caused me. :)) SIMPLY AWSOME! 

posted @ Wednesday, October 04, 2006 3:43 PM | Feedback (1) | Filed Under [ Misc ]

Powered by:
Powered By Subtext Powered By ASP.NET